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,689 reads
Blogs
Daily Coping 23 May 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Cloud Formations – A New MVP Led Training Initiative
By Kamil
Hello, data friends! Let me spread a few words about the new MVP led...
Daily Coping 20 May 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
How to change datasource on multiple reports deployed to power bi report server
Each query in power bi report has it's own connection string. If something wrong...
Call multiple packages based on result set of the query
Hi, I have a query like "Select tablenumber from a table" Tablenumber 1 2...
LDF is not automatically shrinked with simple recovery mode
Hi there, we have SQL Server 2014 (Build - 12.0.6259.0) and my database have...
Ask SSC