Backup Paths and File Management (SQL Server)

How often do you execute a SQL Server backup on a remote server and then say to yourself, “Oh I Read More …

Change the Compatibility Level of a Database (SQL Server)

Compatibility level sets certain database behaviors to be compatible with the specified version of SQL Server. It affects behaviors only Read More …

SQL Server memory performance metrics and bottlenecks

Let’s begin saying that monitoring any system is strongly recommended in an IT infrastructure, and for data analysis and good Read More …

Kill All Process in a Database SQL Server

At times, there may be a chance, when we, intentionally, want to kill all active processes in a given database Read More …

T-SQL query to enumerate database size and Engine version (SQL Server)

The following [gs query] will display the size of each DB available on the SQL Server actually analyzed (on which Read More …

How to search all columns of all tables in a database for a keyword? (SQL Server)

This stored procedure accepts a search string as input parameter, goes and searches all char, varchar, nchar, nvarchar columns of Read More …

Marking a stored procedure as System Object (SQL Server)

Word PDF Epub Text XML OpenOffice XPS MHT Send Us a Sign! (Contact Us!) Show More Info This article has Read More …

Capture And Display Execution Time Of SQL Query In SQL Server

Word PDF Epub Text XML OpenOffice XPS MHT Send Us a Sign! (Contact Us!) Show More Info This article has Read More …