Even though we just release Database Health Monitor version 991 the January 2022 release, I am already working on the next version. I have added… Read More »Working on the February 2022 Database Health Monitor Version
The question of how to delete a trigger after a specific date came up. Here is what could be done. If you want to… Read More »Drop a trigger after a specific date
On Wednesday June 24th at 6:00pm pacific time or( 25 Jun 2015 01:00 GMT ) will be speaking at the 24HOP (24 Hours of Pass) conference which… Read More »Advanced Common Table Expressions – 24 Hours of PASS
Earlier in the week I added a blog entry on using the OUTPUT Clause on INSERT Statements, today I will expand it by exploring the use of… Read More »TSQL OUTPUT Clause With UPDATE Statements
One of the often overlooked features of SQL Server is the OUTPUT clause, which applies to INSERT, UPDATE, DELETE, and MERGE statements. In this post… Read More »TSQL OUTPUT Clause on Insert Statements
I will be attending SQL Saturday #265 in Portland Oregon on November 16th 2013. This will be my second time attending SQL Saturday in Portland,… Read More »SQL Saturday #265 in Portland Oregon
I used to be able to do the Common Table Expression in a single 1 hour session, but after writing the book on Common Table… Read More »Common Table Expressions Presentations Updated.
Queries with Common table expressions (CTE) are made up of two parts, the CTE part, and the SQL that references the CTE. In preparation for… Read More »CTE – With An Insert Statement