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...
sql server
2016-03-19
SQL Server – Find Stored Procedures User Can Access
Returns a report that has information about user permissions for an object, or statement permissions, in...
2016-03-19
SQL Server – Email Results of Stored Procedure Conditionally
Within a Stored Procedure, you may want the results of a particular query emailed to you,...
2016-03-19
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 was...
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...
2016-03-18
PowerShell – Get SQL Server Info
$assemblylist = “Microsoft.SqlServer.Management.Common”, “Microsoft.SqlServer.Smo”, “Microsoft.SqlServer.Dmf “, “Microsoft.SqlServer.Instapi “, “Microsoft.SqlServer.SqlWmiManagement “, “Microsoft.SqlServer.ConnectionInfo “, “Microsoft.SqlServer.SmoExtended “, “Microsoft.SqlServer.SqlTDiagM “,...
2013-06-18
SQL Server – Rolling Back Dynamic SQL
Do transactions apply in dynamic SQL, in SQL Server? In a word, yes. For proof, run...
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...