I am looking for this query. Thanks

You didn't say, or at least I didn't see, in the article where you were doing this tuning, which environment. Because you didn't say, people might not know, that running...

Good Introductory article.

Performance tuning is varying on case to case basis but you need to first identify where the problem or bottleneck is.

Some times, query is perfect, it is following...

If you have mentioned "Transaction Name" while opening it then you are able to findout open transactions by following query:

select DB_NAME(database_id), * from sys.dm_tran_active_transactions tc inner join

sys.dm_tran_database_transactions td

on tc.transaction_id =...

Thanks 🙂

As per my understanding of the problem following paramters may be NULL as per user's selection:

@date1 nvarchar(20),

@description1 varchar(50),

@date2 nvarchar(20),

@description2 varchar(50),

@date3 nvarchar(20),

@description3 varchar(50),

@date4 nvarchar(20),

@description4 varchar(50),

@date5 nvarchar(20),

@description5 varchar(50),

@date6 nvarchar(20),

@description6 varchar(50)

so you can...

There is no difference but when you see the table structure in Desinger mode (in SSMS) then "Default value or Binding" displays "((0))" though during creation of table you have...

Do you require help for "SQL Server 2005 Integration Services" ?

If you are finding solution for T-SQL (means query related) then post the question in TSQL forums.

Issue may be with your Protocols (they are disabled).

Enable - TCP/IP if you are using the machine name as serverName

Enable - TCP/IP & Named Pipes if you are using machinename\instanceName...

Good Question. Thanks

ISNUMERIC is returing 0 so implicit conversation is not converting BLANK to ZERO. Therefore the reason behind this is something else.

Nice observation Nakul.

We should post the query to Microsoft forums using this link as reference, so those who knows SQL Server internal in deep can answer.

Shall we require any...

This is really strange case. As per my view, whenever we try to insert the result set into another table, SQL Server is pushing/pumping the data in batch and release...

If Index is not present then add index as per your requirement. Also, check statistics and if it is old then update it

For ex. UPDATE STATISTICS tablename;

You can also...

You need to create View & INSTEAD OF trigger to achieve the desired result.

search "INSTEAD OF triggers" in SQL Server books online - it has more details as well as...