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...
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...
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...
I want to make partition of a table on some criteria. does there any changes in the existing Queries/SPs for accessing the table or SQL Server...
Separate names with a comma.