Like a conductor at a concert, the scheduler makes sure every task in SQL Server gets its turn. Here is how the SSMS Scheduler Health Report shows its state.
Constant Folding: Expressions the Optimizer Solves Before Running
SQL Server does the math on your literals once, while it builds the plan. Here is where that helps, and where it quietly stops.
MySQL – How INSERT() Function Works for MySQL
MySQL has an INSERT() function that has nothing to do with adding rows. It replaces characters within a string at a given position. Here is how it works.
SQL SERVER – What is Biml and How Can it Help Me with SQL Server BI? – Notes from the Field #036
What is Biml, and how can it help with SQL Server BI? Reeves Smith explains Business Intelligence Markup Language and how it adds automation to BI work.
Reading the Top Five Wait Types on Your Server
Top five wait types become useful when you filter background waits, measure changes over time, and connect them to active work.
SQL SERVER – Round Up From Notes from the Field of Blog Posts of Tim Radney
A round up of all the Notes from the Field posts by Tim Radney of Linchpin People, from finding the last backup to database file names.
Foreign Keys Without Indexes: Finding and Fixing Slow Deletes
Find foreign keys without indexes, inspect parent-delete plans, and choose leading child-table keys that support relationship checks.