Index Fragmentation Report
It’s very easy to automate a report to check your index fragmentation levels on your databases. Here is a query that I use to check the fragmentation level before deciding whether or not to act on it.
SSAS Reporting Actions
When trying to create actions with SSAS I really struggled to find any information or easy “how to’s” to show me how they were done.
Finding Queries to Tune
Just a quick post because I’ve written a script I’m quite proud of this afternoon to help find queries that need tuning.
Have you enabled Lock Pages in Memory?
Firstly for those that already know about this feature of Windows, have you enabled this permission to your SQL Server service account? If not why not? I’d be interested to know so please leave a comment below.
RCSI Demo Script
Someone recently asked if I could post the demo script that I mention in my RCSI blog post on this site.
Efficient, partial, point-in-time database restores
This article is about a situation that many of us could describe the theoretical approach to solving, but then struggle to understand why SQL Server wasn’t following that theoretical approach when you tried it for real.