This script gets the size of each database file, not including backups. Essentially, you’ll see…
Month: March 2016
TSQL – Get Number Of Cores & MaxDOP In Single Query
This is a handy script to show the number of cores and MaxDOP in a…
TSQL – Orphaned User Script
Finding Orphaned Users USE [db] GO EXEC sp_change_users_login ‘Report’ GO Fixing Orphaned Users USE [db]…
Estimating the Size of an Index
If you’re creating a new index in SQL Server, it is good practice to make…
Finding Duplicate Records In Database
SELECT COL_TO_CHECK, COUNT(COL_TO_CHECK) FROM TABLE_NAME GROUP BY COL_TO_CHECK HAVING COUNT(COL_TO_CHECK) > 1 If there is…
SQL Server – Find Stored Procedures User Can Access
Returns a report that has information about user permissions for an object, or statement permissions,…
SQL Server – Email Results of Stored Procedure Conditionally
Within a Stored Procedure, you may want the results of a particular query emailed to…
SQL Server Profiler New Templates Failing
Source of info: http://www.mattbutton.com/2011/06/01/sql-profiler-templates-missing/ Upon trying to create a trace template in SQL Server Profiler, I…
TSQL – Simple Loop Through Result Set Using Cursor
This is the basic query text to use whenever you need to loop through a…
Rolling Back Dynamic SQL
Do transactions apply in dynamic SQL, in SQL Server? In a word, yes. For proof,…