Searching every stored procedure through sys.sql_modules finds text quickly, but comments, case, dynamic SQL, and other databases need care.
SQL SERVER – Retrieve Information of SQL Server Agent Jobs
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.