On index key size, index depth, and performance
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
Menu
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
[Edit 2016: Check out my new resource – a comprehensive library of all wait types and latch classes – see here.] SQL Server 2014 (and
This year’s Fall SQLintersection conference in October is fast approaching and we’ve got some excellent full-day workshops lined up for you: Sunday 25th: Kimberly with Queries
I’ve just released our London classes for 2016 for registration! We’ll be teaching the following classes: IEPTO1: Immersion Event on Performance Tuning and Optimization – Part
We’re very excited to announce that we’re partnering with our friends at Linchpin People to offer two new Immersion Events on SSIS, both debuting in 2016 along
I’ve just released our first sets of US classes for 2016 for registration! Our classes in April/May will be in Chicago, IL: IE0: Immersion Event
I just spent a couple of hours fruitlessly trying to solve a problem and thought I’d blog the solution in case anyone else hits the
The two major Fall conferences (PASS Summit and SQLintersection) are coming up in October so I wanted to give you a heads-up about what I’ll be presenting.
One of the corruptions that can stymie all efforts at disaster recovery is broken boot page. If the boot page can’t be processed, the database
On the second Tuesday of each month, many people in the SQL Server community join together to all blog on the same topic – a
We’ve released our Fall lineup of classes for registration! Our November classes in Chicago, IL will be: IE0: Immersion Event for Junior/Accidental DBAs November 16
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
In the last IEHADR class we just had in Chicago, I was doing a demo of looking in the transaction log to find the point
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
Last weekend there was a suggestion on the MVP distribution list about having temporary nonclustered indexes on AG readable secondaries, in the same way that
It’s been a while since I’ve done a survey, and this one is inspired by a discussion I had with Matt Slocum (b | t) yesterday that led
Last year PASS introduced some eligibility requirements for voting in the 2014 PASS elections, but a lot of people didn’t get the message for various
(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
We’re very excited to announce that we’re offering a new Immersion Event on Practical Data Science using Azure Machine Learning, SQL Data Mining, and R,
Here’s an interesting question that came up in our IEPTO1 class in Chicago this week (paraphrasing): I was doing a demo recently where I was demonstrating
We’re just about to leave for three weeks of Immersion Events in Chicago, starting next week, and if that wasn’t enough, we’ve got our Spring 2015
Last week, for the second time in as many weeks, I was sent a question in email from someone who had a transaction log that
PASS has just released the top-10 rated sessions from the 2014 PASS Summit for everyone to watch for free! My Advanced Data Recovery Techniques session
Back in 2009 I blogged about how checkpoints work (see How do checkpoints work and what gets logged) and I received a question in email
The story I wrote for our SQLskills Insider newsletter on Monday last week resonated so well with people that I thought I’d publish it here
A couple of weeks ago I kicked off a competition of sorts, to find some people to mentor to celebrate the community voting me “Person You’d
This month’s T-SQL Tuesday (hosted by Kenneth Fisher – @sqlstudent144) is about security This hasn’t been my area of expertise for a long time, although I did write a long
Every year Redgate hands out a series of Tribal Awards, voted for by the SQL Server community around the world. In the 2013 awards I won
Since SQL server 2014 was released back in April last year, there have been some rumblings about changes to how many VLFs are created when
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
The last post of the year! It’s been a really excellent year all round and time for my traditional post counting down some of the
Back in 2009 I started posting a summary at the end of the year of what I read during the year (see my posts from 2009, 2010, 2011,
Last week we joined our wonderful friend (he MC’d our wedding in 2007) Richard Campbell for RunAs Radio show #400, where we jet-laggedly discuss all kinds
It’s hiring time again, as our consulting volume has reached the point where we need more help on our close-knit, expert team! Specifically, we’ve asked
As we all wind down for the 2014 holiday season, we want to give the SQL Server community a holiday gift to say ‘thank you’
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
My friend Wayne Sheffield (b|t)is hosting T-SQL Tuesday this month and it’s been a long time since I’ve taken part
Through popular demand we’ve managed to juggle a bit more of our schedule around and found space to fit in another European class in 2015, and it’s
On Friday I made my signature pork ribs for our good friend Bob Ward (along with Kimberly’s truffled cauliflower mash and caramelized broccoli) and I promised
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.
This is a quick post to let you know about a bug that a few people are hitting when running DBCC CHECKDB. The symptoms are
Starting in 2015 we at SQLskills would love to present remotely for your user group, anywhere in the world. Kimberly and I recently did a
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 12/10/14: Survey is closed see the editorial here.] One of the trends I’m seeing this year is a slow increase in the number of
[Edit 2016: Check out my new resource – a comprehensive library of all wait types and latch classes – see here.] (Script last updated June
Through popular demand we’ve managed to juggle some of our schedule around and found space to fit in our only class of 2015 in the UK, and
Back in August I wrote a long post about how to ask questions politely and correctly to address what I see as a growing volume
We’ve managed to juggle some of our schedule around and found space to fit in our only class of 2015 in Australia, and it’s open for registration!
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.