2001-08-08
2,587 reads
Scripts
BCP out a table
This procedure will BCP out all data in a table. The format is designed to be used with the dbsp_bcp_in stored procedure to import the data back into a server.
2001-08-08
3,937 reads
Database Growth Monitor
The script will monitor the growth of the databases on your server. It is really meant to just get you started on a more detailed solution.
2001-08-08
5,317 reads
Defrag Tables
Over a period of time, because of the inserts, updates and deletes, the data and the index pages can get fragmented. Here's a script that can help to defrag the database:
2001-08-08
6,148 reads
Drop all Connections from a Database
On development servers, at times there is a need for dropping and renaming database(s). These scripts can be used for achieving these tasks. The usp_DropDB script will kill the connections to the database and then drop the database. It takes care of the space in the database name, if any and also makes sure that […]
2001-08-08
5,451 reads
Forcibly Shrink the Transaction Log
I got this script from SQL Server Professional Magazine in an article by Andrew Zanevsky. It performs transactions to fill up virtual log files and continually shrinks the log until the desired level of shrinkage is achieved.
2001-08-08
10,129 reads
Kill All Users in A Given Database
This script will kill all users in a given database. Before disconnecting, it can optionally send the user a NET SEND Message giving them a warning to disconnect. To run, simply call it like usp_killusers 'dbname'. Make sure the @dbname parameter is not the master database.
2001-08-08
4,473 reads
Quickly Enable/Disable Triggers and Constraints
When loading data, nothing can be more frustrating than having to deal with stubborn constraints and triggers. This is especially true when you know your data is fine but the constraints are too prohibitive for a mass initial load. Here's a technique I use to disable the constraints and triggers temporarily during a mass load. […]
2001-08-08
3,067 reads
Blogs
Monday Monitor Tips: The Jobs Report
By Steve Jones
A customer wanted a report they could email to their boss about jobs, something...
Automating SQL Maintenance: How DevOps Principles Reduce Downtime
By Chris Yates
In the world of modern data infrastructure, SQL databases remain the backbone of enterprise...
From Couch-Potato to Triathlete – and What This Means for Your SQL Server
Do you know if your SQL Server is really running at its best? To...
Forums
Single User SQL Server on Linux
Comments posted to this topic are about the item Single User SQL Server on...
All the Costs of Downtime
Comments posted to this topic are about the item All the Costs of Downtime
How Well Does the MSSQL Extension in VSCode Work?
Comments posted to this topic are about the item How Well Does the MSSQL...
Question of the Day
Single User SQL Server on Linux
How can I start SQL Server on Linux in single-user mode to restore the master database?
See possible answers