2016-03-19
Database File Space and Free Space
/* Author: Ben Farnsworth Date: 1/7/14 Get info on Data files */ IF OBJECT_ID(‘tempdb..#space’) IS NOT...
2016-03-19
Autogrowth On But Database Not Growing
An issue arose where a database was giving the error: Could not allocate space for object...
2016-03-19
Shrinking Database Files With Excess Free Space
This script is intended for environments where space constraints require the space to be closely maintained....
2016-03-19
SQL Server – Lots of Empty Space But Database Won’t Shrink
Today I ran a script to delete a huge portion of data in a DEV environment...
2016-03-19
SQL Server – Get Latest Backup File Sizes For All Databases
This returns a result for each database and includes its size in MB. SELECT DATABASE_NAME DBNAME...
2016-03-19
SQL Server – Get Size of Database Files
This script gets the size of each database file, not including backups. Essentially, you’ll see .MDF,...
2016-03-19
TSQL – Get Number Of Cores & MaxDOP In Single Query
This is a handy script to show the number of cores and MaxDOP in a single...
2016-03-19
TSQL – Orphaned User Script
Finding Orphaned Users USE [db] GO EXEC sp_change_users_login ‘Report’ GO Fixing Orphaned Users USE [db] GO...
2016-03-19
Estimating the Size of an Index
If you’re creating a new index in SQL Server, it is good practice to make sure...
2016-03-19
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 more...