There are multiple ways by which we can find a list of SQL Server instances name instances on a machine. In this blog, I would show a few ways to do it.
Performance Comparison EXCEPT vs NOT IN – Interview Question of the Week #095
EXCEPT vs NOT IN: which is faster? An attendee at PASS Summit asked me, and my simple example shows they work the same way and perform the same.
SQL SERVER – Displaying SQL Agent Jobs Running at a Specific Time
A client’s server froze every morning at the same time. The cause was a background job, so here is a query for displaying SQL Agent Jobs running at a set time.





