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,264 reads
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,264 reads
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,118 reads
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,353 reads
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,101 reads
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,425 reads
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,029 reads
If you're a data analyst, you already know that SQL isn't just a nice-to-have...
By Steve Jones
Recently the Flyway Desktop (FWD) team release support for state-based deployments. These are similar...
By Steve Jones
insoucism – n. the inability to decide how much sympathy your situation really deserves,...
Comments posted to this topic are about the item The Costs and Rewards of...
Comments posted to this topic are about the item Manage Elastic jobs in Azure...
Comments posted to this topic are about the item Takeaways from Data Grillen 2024
When is a transaction mark first inserted into the msdb.dbo.logmarkhistory table?
See possible answers