THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web
Browse by Tags
SQL Server 2012
ICYMI: Partitioning Advice, Purging Data Bloat, and an example of TVF Misbehavior - SQL Server Performance
Here are some oldies, but goodies that I recommend you read:Two Partitioning Peculiarities and Aggregates and PartitioningMost of us know that partitions are one of the best ways to scale very large databases or very large IO workloads. However, there are risks, two of which are explored in detail by internals master Paul White ...
March 30, 2015
Learn More About SQL Server IO and Query Tuning in These Webcasts
I'm doing two new webcasts next week on Wednesday, December 19th, one in the morning and the other after lunch. SSDs are a Game Changer for SQL Server Storage No, session is not exclusively about SSDs. But this is my first session on IO and storage tuning that emphasizes SSDs over hard disks. As Bob Dylan said ''Times, they ...
December 14, 2012
Brought to you by