This is a DBCC command I learned from Brent Ozar’s Indexing video. To get statistics on an index, simply use:
|
1 |
DBCC SHOW_STATISTICS ('Person.Person', IX_Person_LastName_FirstName_MiddleName); |
Views –…
Read More
Here is a good article describing what lock compatibility is all about as well as a few charts for reference: TechNET: Lock Compatibility…
Read More
Below is the link to install (on your local workstation instance of SSMS) the SQL Server 2012 Performance Dashboard Custom Reports. SQL Server…
Read More
SQL Server 2012 Posted from TechNet The Transact-SQL programming language provides DBCC statements that act as Database Console Commands for SQL Server. Database…
Read More
This will also display the SQL Statement that is the offending blocker. Online index operations: Online index operations were added as an availability…
Read More
|
1 2 3 4 5 6 7 8 9 10 11 12 |
SELECT OBJECT_NAME(st.objectid,st.dbid) AS ObjectName, cp.usecounts AS ExecutionCount, st.TEXT AS QueryText, qp.query_plan AS QueryPlan FROM sys.dm_exec_cached_plans AS cp CROSS APPLY sys.dm_exec_query_plan(cp.plan_handle) AS qp CROSS APPLY sys.dm_exec_sql_text(cp.plan_handle) AS st WHERE cp.objtype = 'Proc' AND OBJECT_NAME(st.objectid,st.dbid) = 'YourStoredProcedure'; |
Views – 2149
Read More
Setting ANSI_NULLS ON will make make the Sprocs run fast. See this article: Query is fast but Sproc is slow Views – 1747
Read More
Here is a great article on trouble-shooting T-SQL query slowness: Trouble-shooting SQL Server Slowness Views – 1751
Read More
Updates query optimization statistics on a table or indexed view. By default, the query optimizer already updates statistics as necessary to improve the…
Read More
Clustered Clustered indexes sort and store the data rows in the table or view based on their key values. These are the columns…
Read More