Reindex - Reorganize or Rebuild
In the first time you execute this procedure, might take a long time, but not in the next time. Later you can execute this procedure daily.
2011-08-10 (first published: 2011-07-06)
2,408 reads
Scripts
Status de Replicação via E-Mail
Script que envia um relatorio para o seu email com o status de sincronismo de sua replicação.
2011-08-10
329 reads
NetApp Dynamic Backup Script
TSQL Script to backup selected databases. Use this to override the script generated by snapmanager for sql in a sql job which doesn't cater for new or deleted databases
2011-08-09 (first published: 2011-07-27)
807 reads
Modify All Database Data and Logfile Names
This script modifies all dtabase .mdf and .ldf to have a standardized name of DatabaseName_Data and DatabaseName_Log.
2011-08-08 (first published: 2011-07-28)
964 reads
2011-08-05 (first published: 2011-07-23)
2,252 reads
2011-08-04 (first published: 2011-07-25)
3,257 reads
SQL Server Security Extract (Reverse Engineer) for ALL Databases
These scripts will extract security for Windows Logins, Database Users, Roles, Objects and SQL Logins.
2011-08-03 (first published: 2011-07-28)
2,204 reads
2011-08-02 (first published: 2011-07-28)
3,042 reads
2011-08-01 (first published: 2011-07-28)
3,194 reads
Changing Primary key names to standard naming convention across the DB
This script will rename the Primary keys to standard notation - PK_TableName
2011-07-29 (first published: 2010-02-09)
1,695 reads
Blogs
Power BI Performance in 2026: A Practical Guide to Faster Semantic Models and Reports
By James Serra
Originally published April 2022; substantially updated July 2026. This post is a complete replacement...
Getting Started with Azure SQL Developer on Macbook
The idea behind Azure SQL Developer is for anyone to build, iterate, and test...
AI Experiments: Claude Solved a DAB Issue
By Steve Jones
I’m sure many of you are using AI regularly, perhaps chatting, perhaps using some...
Forums
Can You Really Downgrade from Enterprise to Standard and Save Thousands? Here's What Happened
Comments posted to this topic are about the item Can You Really Downgrade from...
What is CPU Usage?
Comments posted to this topic are about the item What is CPU Usage?
Limiting Checkpoints
Comments posted to this topic are about the item Limiting Checkpoints
Question of the Day
Limiting Checkpoints
If I use the -k parameter with a number after it, what does this change in SQL Server?
See possible answers