Enable-all after a freeze wakes up jobs that were off on purpose. Save the starting state and put back exactly that.
Reading DBCC SHOW_STATISTICS Step by Step
Read SHOW_STATISTICS headers, density and histogram boundaries, compare estimates with your plan, and query the histogram directly.
SQL SERVER – Tools for Proactive DBAs – Central Management Server – Notes from the Field #009
John Sterrett shows how Central Management Server lets a DBA run the same query on many SQL Server instances at once, a handy tool for proactive DBAs.
Counting Rows per Month With Zero-Filled Gaps
Build monthly counts with zero-filled gaps, generate a complete month range, and retain empty categories through a reporting scaffold.
Ranking Items by Rating Fairly With a Bayesian Average
Use Bayesian average in SQL Server with practical examples, clear checks, and the limits you need before changing your database.
SQL SERVER – MySQL – LIMIT and OFFSET – Skip and Return Only Next Few Rows – Paging Solution
Paging in MySQL and SQL Server: use LIMIT and OFFSET to skip some rows and return only the next few, with examples for both databases.
SQL SERVER – MySQL – PostgreSQL – How to Concat Strings?
How to concat strings the same way in SQL Server, MySQL and PostgreSQL? I switched from the plus operator to the CONCAT function, and here is why.
Developer – 10 Phrases Developer Use Too Often
I am a developer and so are most of my friends. Here are 10 phrases every developer says too often, from ‘I can fix that’ to ‘That’s not my code’.
MySQL – How to Change Delimiter in MySQL – Supporting GO Keyword of SQL Server in MySQL
Copied a SQL Server script with GO into MySQL and got an error? Here is how to change delimiter in MySQL so it accepts GO as a statement terminator.
SQL SERVER – Roundup Post – Notes from the Field – Year 2013 – Performance Tuning and Database Health
How did Notes from the Field start? Here is the story behind the series and a roundup of the 2013 episodes on performance tuning and database health.










