sp_help_job returns information about SQL Server Agent jobs in msdb. Run it with no parameters to list every job, plus a few related Agent posts.
CTE Column Names: Rename Positions Without Moving Values
CTE column names rename positions without moving values. Compare inner aliases, report names and a misleading reversed list.
Which SQL Server Client Driver to Use Now
Choose a SQL Server client driver by application stack: ODBC, current OLE DB, Microsoft.Data.SqlClient, or JDBC, then test security defaults.
SQL SERVER – Change Default Fill Factor For Index
The Default Fill Factor in SQL Server is 0. Change it with sp_configure to leave free space on index pages and reduce page splits. I like mine at 90.
Composite Keys: Match Complete Pairs Instead of Separate Lists
Composite keys need a complete pair match when the allowed values are defined together. I don’t split the components into independent lists. Doing so can admit combinations that were never allowed.
A Quote of the Day From a Table, With No Repeats Until All Are Used
Build a quote of the day table that rotates without repeats, handles concurrent requests, and supports a stable date-based selection.
SQL SERVER – 2005 Comparison EXCEPT operator vs. NOT IN
The EXCEPT operator returns distinct rows from the left query with no match on the right, just like NOT IN. Both give the same plan, but EXCEPT reads simpler.