2005-12-30 (first published: 2005-12-09)
121 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,376 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,557 reads
Blogs
SQL Server on Linux Storage Secrets on Microsoft Channel 9
By kleegeek
I’m thrilled to have recently released a video with Microsoft’s Data Exposed on Channel...
Daily Coping 29 Jul 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Server vs Instance. A rant.
It’s a SQL Server Instance not a SQL Server. The product is SQL Server....
Forums
Having sum(amount) = 0 returns negatives as well.
Hello all, I'm trying to get a list of ID's that have a total...
How to limit SQL Job Success events
Hi, We have a monitoring tool that reads Windows Event Log entries for Failure...
SQL Server Agent producing unreproducible error
I've built a Powershell script, which I want to run through SQL Server Agent....
Ask SSC