Find List of Columns Updated inside Trigger
This will list the columns used by the update statement inside a trigger. More generic and useful for columns > 32.
2014-02-10 (first published: 2012-06-06)
1,572 reads
Delete Duplicates in SQL 2000, SQL 2005, SQL 2008 or Higher
Delete Duplicates in SQL Server without using Cursor or Temporary tables
2012-06-21 (first published: 2006-11-22)
3,239 reads
Finding other database objects referenced in an SP
Script can be used to find out the objects which are available in other database and are referenced in your stored procedure. These objects will not be listed with sp_depends system stored procedure.
2007-07-31 (first published: 2006-11-21)
279 reads
Blogs
The fundamental requirements of a reporting system
By ChrisJenkins
There are some fundamental boxes that your reporting system must tick. ✅ The figures...
Seeing the Bigger Picture: How A Monitoring Tool Changed My Approach to Estate Management
By Chris Yates
When it comes to managing complex database environments, having the right monitoring solution is...
Check Power BI report interactions with Semantic Link Labs
It can be tedious to check what visual interactions have been configured in a...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
The Last Good DBCC Run
Comments posted to this topic are about the item The Last Good DBCC Run
count the number of NULLs in a row
Hi everyone I have a SP that finds the average based on 3 tables. ...
Question of the Day
The Last Good DBCC Run
I want to check when DBCC CHECKDB was last run on my Baseball database. What code should I use?
See possible answers