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
5,834 reads
Rahul Sharma
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
3,831 reads
Blogs
Azure Synapse Analytics new features
By James-Serra
Almost lost in all the announcements from Ignite was a bunch of amazing new...
Docker, Git and DBATools
For those who don’t know, last week was the PASS Summit. It’s an amazing...
SQLSaturday Orlando Notes – Coffee
By Andy Warren
I like to say that the goal for any event is to meet the...
Forums
result in same line
Hello, trying to query the result by success or failure in 2 seperate...
Dropping SP's safely
Hi, Is the below script good to delete 3 sp's... Please let me know...
SQL 2017 Listener with Read-Scale (Clusterless environment) AG not working
Hello, I have a Read-Scale AG set up. I have it failing over back...
Ask SSC