New live online training class in March: Columnstore Indexes
Continuing our series of live, online classes, Jonathan will be delivering his new IECS: Immersion Event on Columnstore Indexes in March! The class will be delivered live via WebEx
Continuing our series of live, online classes, Jonathan will be delivering his new IECS: Immersion Event on Columnstore Indexes in March! The class will be delivered live via WebEx
Continuing our series of live, online classes, Erin, Jonathan, and Kimberly will be delivering their new IEQUERY: Immersion Event on Fixing Slow Queries, Inefficient Code, and Caching/Statistics Problems in
Continuing our series of live, online classes, Kimberly will be delivering her new IETLB: Immersion Event on Transactions, Locking, Blocking, Isolation, and Versioning in October! The class will be delivered
A question came up on the Data Platform MVP email list last night asking what the FCB_REPLICA_SYNC spinlock is. I answered the question and then
Continuing our series of live, online classes, Erin, Jonathan, and Kimberly will be delivering their new IEQUERY: Immersion Event on Fixing Slow Queries, Inefficient Code, and Caching/Statistics Problems in
Continuing our series of live, online classes, Kimberly will be delivering her new IETLB: Immersion Event on Transactions, Locking, Blocking, Isolation, and Versioning in October! The class will be delivered
SQLskills has an ongoing initiative to blog about basic topics, which we’re calling SQL101. We’re all blogging about things that we often see done incorrectly, technologies used the wrong
Erin’s latest Pluralsight course has been published – SQL Server: Analyzing Query Performance for Developers. It’s four hours long, and from the course description: Developers are sometimes charged
It’s been a while coming but it’s worth the wait! Kimberly’s latest Pluralsight course has been published – SQL Server: Indexing for Performance – and it’s a
A few months ago while I was teaching wait statistics, I was asked whether there’s any expected differences with waits stats when SQL Server is
A few years ago I realized that there was a huge gap in knowledge in the SQL Server community – what do all the various
In Monday’s newsletter I discussed an email question I’d been sent and promised to blog about it. The question was “how can latch waits for
This is something that came up recently on the Microsoft Certified Master DL, and is something I discuss in our IEPTO1 class because of the
This is a quick post to blog a script that allows spinlock statistics to be captured for a defined period of time (as I need
It’s finally ready! For the last two years, I’ve been working on-and-off on a new community resource. It was postponed during 2015 while I mentored
Edit 10/30/19: the latest version of this script, with additions and adapted for newer versions is here. A question came up in class today about easily seeing the
Through the end of July, we’re offering a complete single-instance health-check for a flat fee of US$2,500… One of the most popular services we provide
In my Insider newsletter a couple of weeks ago, I discussed how index fragmentation is often considered when designing indexes, but index depth often isn’t. In
My latest Pluralsight course has been published! It’s called SQL Server: Index Fragmentation Internals, Analysis, and Solutions and is just over 2.5 hours long. The modules
Kimberly’s latest Pluralsight course is live! This is part 2 of her very popular course: SQL Server: Optimizing Stored Procedure Performance. The course is more
(Check out my Pluralsight online training course: SQL Server: Performance Troubleshooting Using Wait Statistics and my comprehensive library of all wait types and latch classes.) One of
Edit 10/30/19: the latest version of this script, with additions and adapted for newer versions is here. Over the holidays I was playing around with parallelism
A month ago I kicked off a survey asking how much memory is installed on your largest server that’s running SQL Server. Thank you to
One of the cool new features in SQL Server 2014 is delayed durability (available in all Editions), which is described in detail in Books Online here.
In both my wait statistics pre-conference workshops at the PASS Summit and SQLintersection I promised to do a bunch of blog posts. The second one
[Edit 2016: Check out my new resource – a comprehensive library of all wait types and latch classes – see here.] (Script last updated June
We’ve just released two new courses on Pluralsight: The first new course is the conclusion of Joe Sack’s query-tuning course: SQL Server: Common Query Tuning Problems and
I’ve just released our final US classes this year for registration! We’ve revamped our IE1 and IE2 classes so they’re now both focused on performance
[Edit 2016: Check out my new resource – a comprehensive library of all wait types and latch classes – see here.] Back in February I
(Check out my Pluralsight online training course: SQL Server: Performance Troubleshooting Using Wait Statistics and my comprehensive library of all wait types and latch classes.) In many
[Edit 2016: Check out my new resource – a comprehensive library of all wait types and latch classes – see here.] In some of the
[Edit 2016: Check out my new resource – a comprehensive library of all wait types and latch classes – see here.] Wait statistics, as you
Two weeks ago I kicked off a survey that presented a scenario and asked you to vote for the log_reuse_wait_desc value you’d be most worried to
(Check out my Pluralsight online training course: SQL Server: Performance Troubleshooting Using Wait Statistics and my comprehensive library of all wait types and latch classes.) Two weeks
Kimberly’s second Pluralsight online training course has just gone live and is available for watching! Her course is SQL Server: Optimizing Ad Hoc Statement Performance
(New for 2020: we’ve published a range of SQL Server interview candidate screening assessments with our partner Kandio, so you can avoid hiring an ‘expert’ who
Kimberly’s first Pluralsight online training course went live today: SQL Server: Why Physical Database Design Matters It’s 4 hours long and is the first in a
(New for 2020: we’ve published a range of SQL Server interview candidate screening assessments with our partner Kandio, so you can avoid hiring an ‘expert’ who
Back in February I ran a bunch of performance tests of DBCC CHECKDB on SSDs, to evaluate the effects of degree-of-parallelism (DOP) and various options
[Edit 2016: The team ‘fixed’ the problem in SQL Server 2016 by skipping consistency checking these indexes unless WITH EXTENDED_LOGICAL_CHECKS is used.] It’s no secret
At the SQL Connections conference earlier this month, at the start of my talk on Making SQL Server Faster, Part 1: Simple Things, I talked
For the last few weeks I've been thinking about performance baselines, mostly because I've been producing Erin's new Pluralsight course on Benchmarking and Baselining. It
(Check out my Pluralsight online training course: SQL Server: Performance Troubleshooting Using Wait Statistics and my comprehensive library of all wait types and latch classes.) Back in
Earlier this morning I noticed a discussion on the SQL MCM distribution list (that all the original MCM instructors are part of) that was trying
I first started blogging about latches and some of the deeper parts of SQL Server internals last year (see Advanced performance troubleshooting: waits, latches, spinlocks)
During every one of our Immersion Events, we designate Thursday evening as 'open mic' night where anyone can do a 15-minute presentation on anything they
A long time ago, in a galaxy far, far away I kicked off a survey about memory configuration. Actually it was back at the start
Back in January I posted the results of the cluster key size survey I ran in 2011 and explained how the larger the cluster key
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.