SQLCMD is one of many methods to export your database data to some text file  Read more...

When code is getting stall, sometimes the execution plans are point to the wrong or out dated or old objects. You would need to recompile all the stored procedures  Read more...

If you have any requirement to extract next 100 sequential date from a present date, you can use the below script. You can change the @datetimeformat value and the output will appear in the same format.  Read more...

DBA many a times need to shrink the log files if that grows very large. Though I am not recommending to do it daily or often but if space is an issue and you want to release space to OS, you may use the script.  Read more...

If you have a requirement to enable email notification to all the SQL Jobs, then you may use my script.  Read more...

Identifies SQL and or Jobs that are using tempdb space.  Read more...

Delete files via TSQL procedure in shared location  Read more...

Checks currently running sessions and blocking queries with session information  Read more...

Server principal 'xx\yy' has granted one or more permission(s). Revoke the permission(s) before dropping the server principal. (Microsoft SQL Server, Error: 15173). If you are gett  Read more...

This stored procedure extracts template variable names and values from a SQL result set in order to process the template.  Read more...

Find databases without backup and alert you by email with databases affected  Read more...

One way to calculate how many minutes a person has worked considering holidays and shifts, being given starting and ending date / time  Read more...

This script rebuilds all indexes in a selected database (tables and indexed views). Ifm you have a very large Database with many indexes and indexed views please consider before you run this script it might take a while to run. I myself run it around once a month after new data comes my way  Read more...

Return the 600 last days of backup history for all databases  Read more...

Performs a loop on all database to retrieve tables sizes and compression type  Read more...

CPU Utilization by database and SQL Query  Read more...

Romanian Number Humanizer  Read more...

This Simple script will help to do a Server wide search for an object name or usage of a String in Object Code like Function, Procedure, Views  Read more...

Script to quickly check the drive space utilization.   Read more...

This script takes path and dbname and then prints the command.   Read more...