2005-12-30 (first published: 2005-12-09)
118 reads
Index Locking Strategy
This script returns the index locking strategy informationfor all user tables in a database. It also generates the required TSQL statement to alter locking strategies if required. These statements require CTRL-C and CTRL-V individually into query analyser for execution. Results are best viewed in text only. This TSQL can be wrapped in a stored procedure […]
2002-07-04
1,371 reads
DBCC REINDEX all user tables
This script reindexes all user and system indexes in the database using the original fillfactor allocated to that index. It can be executed from the Query Analyzer as stand alone SQL or you could wrap it in a stored procedure.
2002-01-11
7,078 reads
Blogs
Pluralsight Free April
By Gail Shaw
It’s a few days into April, but not too late I hope to mention...
Daily Coping 7 Apr 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...
Reading a SharePoint List with Azure Logic App
Sometimes in life you have to do things you really don’t like to do....
Forums
Understanding and Improving Query Plans
Hi everyone. I have a process that is taking a long time to execute...
Daily Coping Tip 7 Apr 2020
Daily Coping Tip: Rediscover your favourite music that really lifts your spirits. My thoughts:...
Developer Edition
I am proposing to the business that we use SQL 2019 Developer in our...
Ask SSC