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,373 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,330 reads
Blogs
Daily Coping 2 Dec 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
SQL Database Corruption, how to investigate root cause?
By nelsonaloor
Introduction: In this article, we will discuss the MS SQL Server database corruption. So, first, we...
Would You Pass the SQL Server Certifications Please? What Do You Mean We're Out?
I have held various certifications through my DBA career, from CompTIA A+ certification back...
Forums
SQL Server Load
Hi, The application team is pushing more than 7 lakhs records per day to...
Converting minutes to hh:mm:ss
I'm trying to develop a formula to convert minutes (my raw data) to hh:mm:ss...
Interpreting Index Usage Stats on an Availability Group
I've been querying sys.dm_db_index_usage_stats on the nodes of an availability group, and I've noticed...
Ask SSC