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...
TSQL
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
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...
2016-03-19
TSQL – Simple Loop Through Result Set Using Cursor
This is the basic query text to use whenever you need to loop through a result...
2016-03-19
Rolling Back Dynamic SQL
Do transactions apply in dynamic SQL, in SQL Server? In a word, yes. For proof, run...
2016-03-18
SQL Server – Download all RDL files from Report Server
—- Allow advanced options to be changed. –EXEC sp_configure ‘show advanced options’, 1 –GO —- Update...
2013-05-20
TSQL – Loop Through Result Set WITHOUT Cursors
There is some controversy about using cursors in TSQL. Overall, I believe they tend to tie...
2013-02-01
TSQL – Simple Loop Through Result Set Using Cursor
(If you want to AVOID cursors, see: TSQL – Loop Through Result Set WITHOUT Cursors) This is...