Stop a monitoring job from waking anyone at 3 AM. Build the schedule, decode the weekday mask, and see what the window does not cover.
SQL SERVER – Wrap on Series of Temporary Statistics
The final post on temporary statistics answers reader questions, like whether you can update them. Only SQL Server can, but you can drop them.
SQL SERVER – Finding Frequently Running Query and Elapsed Time – Notes from the Field #005
When the server is slow, first see what is running. Brian Kelley shows how to find a frequently running query and its elapsed time, two key facts for tuning.
SQL SERVER – Scripting Statistics for Read-Only Database and Making it Permanent
Learn scripting statistics for read-only database use from TempDB, then make them permanent so they survive a SQL Server restart.
Weekend Project – Connect your Database and Automatically Generate a Fully Customized Back-office Interface
Tired of building the same data entry UI again? I tried backand.com, which lets you connect your database and generate a customized back-office interface.
SQL SERVER – Location of Statistics Before and After Database is Marked as a Read-Only
Where do old statistics go when a database becomes read-only? The location of statistics created before the change stays the same, and they remain permanent.
Why the Same Query Is Fast Then Suddenly Slow
Recognize parameter sniffing by comparing compiled values, data distribution, and reused plans, then test a remedy with its tradeoffs.