The Log Watcher
A fast way to get a quick look at all the log sizes and space used in a real time fashion.
2001-09-25
2,525 reads
Scripts
Script to Attach Multiple MDF
Copies mdf files located in a directory on a client and attaches them to the connected server. This is the winning solution to the contest that was presented in an article posted at http://www.sqlservercentral.com/columnists/awarren/reattachingdatabases-somecodeandacontest!.asp. That article shows how to do the same thing using DMO. Wynn Muse is the author of this stored procedure.
2001-09-23
3,523 reads
Disable and Enable Keys (with some validation)
Here are two stored procedures for enabling and disabling all keys (primary and foreign) for a specified database. It makes sure the database specified is not the system databases and the users session is at the DB to have its keys enables/disabled.
2001-09-19
824 reads
Trim Backup Files
This script runs within a DTS package. It searches the backup directory stored as a global variable in the script and trims all backup files older than some number of days. the script includes logging to the C: drive so you can trace the effects of the script. You need to create the global variables […]
2001-09-12
1,503 reads
List Where SQL Server Files
This SP checks the path where SQL Server is installed, and then lists all the .mdf and .ldf files. Also list the quantity of tables, views, sp, xp and users on the given database.
2001-09-10
2,769 reads
Automatic Backups
Creates the backup devices where sql server is installed, creates an error message above 50001, an alert, and an adittional job in case the scripts fails. In the first time backups all databases and then backups the logs until two days past from the last full backup. Then backups the databases again and so on. […]
2001-09-07
1,226 reads
List Only User Tables
A simple stored procedure that only shows the user tables. It is like sp_tables but fixed to give a simpler vision of the tables.
2001-09-07
1,643 reads
Backup Transaction Logs on all Databases
Here we go again. This is the last in my backup series that I use to do backups of the databases. As far as I know this should only kick out errors when there really is one. This stored procedure is designed to take 4 parameters @bksrv : This is the name or the IP […]
2001-09-06
853 reads
Differential Backups of all Databases
This is the SP I schedule to do diff backups on the DB's that I can. I still need to add errorchecking to see if there is a full available before I do a diff. I'll add that when I get time. This stored procedure is designed to take 4 parameters @bksrv : This is […]
2001-09-06
1,526 reads
Display Identity Values and Other Info
Displays identity values, number of rows in the table, and the difference between the two. The difference can indicate the amount of deletions that could be going on.
2001-09-06
334 reads
Blogs
Large System Databases on SQL Server
This one is an oldie in my blog drafts, but a goodie! So, I...
Free Advanced SQL Course for June: Don’t Miss Out!
Summer is here, and it's the perfect opportunity to enhance your SQL expertise with...
How to give developers access to Query Store
Let’s have devs look at their own query performance. Yes, please, sign me up...
Forums
How to sum the CountDistinct in the detail rows
The SSRS report has a CountDistinct in the detail row grouping by Facility. It...
Ledger Feature In Sql Server 2022
Hi All, Wonder if someone can clear something up for me and let me...
The name of column index 9 is empty ADF
Hi I am brand new to Data Factory I am getting the following error...