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.
Congratulations to Gavin Payne – Microsoft Certified Architect
Huge congratulations to Gavin who became the 6th person in the WORLD outside Microsoft to qualify as a Microsoft Certified Architect in SQL Server today.Gavin Payne - Architect Extraordinaire
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.