2005-12-30 (first published: 2005-12-09)
121 reads
2005-12-30 (first published: 2005-12-09)
121 reads
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,378 reads
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,943 reads
By Steve Jones
I saw someone struggling with getting started with a Visual Studio project and Azure...
By Brian Kelley
If you’re looking at data masking tools, I recently was able to review the...
By Steve Jones
This week the cost of the PASS Data Community Summit jumps up to full...
Hello Gurus, I have a requirement and need to implement the solution quickly. SQL...
Comments posted to this topic are about the item Deleting the Standby file
Comments posted to this topic are about the item If You Build It, Will...