Thanks for the prompt reply. but this article does not contain any information regarding reducing CPU Time.
Dynamic SQL we are having using...
Proc using Dynanic SQL are taking alot CPU time . Can any one guide how to reduce it?
We are upgrading to SQL2005 from SQL2000. So I need to review the TSQL of existing procs to incorprating new features of SQL2005 for...
Quick question: If in a proc in SQL Server 2005 there are multiple if conditions like
Create proc A @p1 int
Is there any tutorial on the internet that can help me understanding XML execution plan thorughly ?
Is it good to have columns of type bit in the composite indexes like (col1,col3,bit-cloumn,col5,col7 etc.) ?
In SQL SERVER 2000 , How can we see that the indexes built by us are being utilized by query optimizer.
Means i want to identify the indexes...
I have question which is better way of following performance wise
1) Filter rows in Where clause using IN(...
Any other way for this. means any system table that can help?
As we can use dmv in SQL Server 2005 to read cached Execution plans(in xml). which table in SQL 2000 gives the same information ?
when we run queires , the plan used by optimizer inserted into sys.dm_exec_text_query_plan.
I want to extract the queries that used index...
In SQL Server 2005, in the execution plan instead of showing bookmark lookups its says ClusteredIndex Seek if the table has clustered index....
UPDATE tblx SET C1 = 5, C2 = GETDATE(), C3 = GETDATE(), C4 = 2
WHERE (C7 = 24) AND (C8 = 1)
There is PK Clustered on column "ID". When ever we...
Hi,Table 'tblX'. Scan count 1, logical reads 34795, physical reads 1, read-ahead reads 34853, lob logical reads 0, lob physical reads 0, lob...
Yes sp has more than selects statments.
I haven't cleared the cache before running it.
Yes , SP has more than on selects.
I haven't clear cache before running it.
I have run the sp using SET STATISTICS IO ON and got following output:Table 'Worktable'. Scan count 2, logical reads 597, physical reads 0,...
I have run a procedure using SET STATISTICS TIME ON and got following:SQL Server parse and compile time:
CPU time = 0 ms, elapsed time = 3 ms.
I have a table havnig clustured index in indentity column C1.
If i make another non clustered index COMBINED on onther columns : C4,C3,C6,C1,C8...
I got a Index usage report using DMV in which few indexes got 0 value in all fields (User_Scans,Lookups,Seeks etc.). What does it mean and what...
Separate names with a comma.