Index Defragmentation
Index Defragmentation is one of the most important DBA tasks. This will significantly improve query performance.
2012-09-26 (first published: 2009-11-18)
12,492 reads
Scripts
SQL Start up Script
This is a script that I run when SQL starts to notify me via email that a server has restarted as well as the location of the server.
2012-09-25 (first published: 2012-08-29)
1,921 reads
Backup Database Size calculation Report - Monthwise
The script helps to calculate the size of the backup of the databases monthwise. This will help to understand the database growth rate from the backup file if we do not have any data collection utility to find the exact details of the DATA File growth.
2012-09-24 (first published: 2012-08-20)
1,648 reads
Run SQL Hosted VBS Script from SQL
This routine allows you to run VBScript directly from SQL (i.e. without having to create a file in advance) by pushing the script to a temp file.
2012-09-20 (first published: 2012-08-21)
1,027 reads
Show all Objects used by Linked Server
Stored Procedure will list all objects, object type, and linked server name. The stored procedure can either be passed in a linked server name as string or null.
2012-09-17 (first published: 2012-08-23)
1,104 reads
Query to check whether my Full Database Backup is running fine.
The query will help to find whether my database backup to a specific instance of SQL Server is running fine. If HH> 1, this would signify that the backup is running, else this is a failure.
2012-09-13 (first published: 2012-08-25)
1,264 reads
ASCII Character Groups in String
Powerful function to find strings containing or excluding classes of ASCII characters.
2012-09-10 (first published: 2012-08-28)
1,097 reads
2012-09-07 (first published: 2007-11-15)
3,535 reads
2012-09-04 (first published: 2008-04-24)
1,181 reads
Find Mismatched Views and Stored Procs
Find missing and mismatched views and stored procs between 2 Databases
2012-09-03 (first published: 2008-05-29)
1,760 reads
Blogs
Wait… Could This Be the End of Index Maintenance?
While attending SQLCon and FabCon Europe in Barcelona, there were a lot of announcements...
Copilot on the Power BI Report Canvas vs. Modern Report Builder
By James Serra
(This is the second post in a three-part series on how AI is changing...
The #MS_DatabaseConnector## Role: #SQLNewBlogger
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Packing and Decoding Device Status Codes with LEFT_SHIFT() and RIGHT_SHIFT() in SQL Server
Comments posted to this topic are about the item Packing and Decoding Device Status...
SQL Server Audit Failures
Comments posted to this topic are about the item SQL Server Audit Failures
Question of the Day
SQL Server Audit Failures
If I have a SQL Server Server Audit setup, what are my options for configuring the instance in the event it can't write to the audit log?
See possible answers