2005-12-30 (first published: 2005-12-09)
120 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,374 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,510 reads
Blogs
Data Saturday #8–Southwest US
By Angela-Henry
I am very excited to announce that I will be speaking for Data Saturday...
Data Weekender v3.1
By Angela-Henry
I am super excited about this new version of Data Weekender, coming up on...
Thanks Kathi and Mala
By Steve Jones
I have to thank Kathi and Mala for putting on the WIT Mental Health...
Forums
Checking Up on Vendors
Comments posted to this topic are about the item Checking Up on Vendors, which...
Search all Tables in DB for a String but using Postgres - What is the difference
Hi Forum, I want to search a Database for a String value and I...
SQL 2016 - Need help with complex calculations based on paycodes - New Changes
Hello Friends, Posting this for help as the client made more requirement changes. I...
Ask SSC