As Kimberly blogged about earlier this year, 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
As Kimberly blogged about earlier this year, 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
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
A while back I kicked off a survey asking what mechanism you use for running your regular SQL Server database maintenance. Here are the results:
Whenever I’m teaching about index fragmentation I get asked how to track page splits proactively. This can be useful to discover fragmentation occurring in indexes
The September edition of TechNet Magazine is available on the web now and has the latest installment of my regular SQL Q&A column. This month's
(Check out my Pluralsight online training course: SQL Server: Index Fragmentation Internals, Analysis, and Solutions.) Back in April I kicked off a survey where I asked
(Look in the Misconceptions blog category for the rest of the month’s posts and check out the 60-page PDF with all the myths and misconceptions
Way back in the mists of time, at the end of the last century, I wrote DBCC SHOWCONTIG for SQL Server 2000, to complement my
I made them up. Yup. I’m talking about the guidance which is: if an index has less than 1000 pages and is in memory, don’t
I'm teaching a class this week on database maintenance, for DBAs inside Microsoft. One of the things we're discussing today is index fragmentation and how
Quickie this morning to start the day off. I saw a question on a forum: if I *have* to use a GUID and *must* have
Page splits are always thought of as expensive, but just how bad are they? In this post I want to create an example to show
Last week’s survey was on how you should store large-value character data in SQL 2005+ (see here for the survey). Here are the result as
Jack Li, one of the Senior Escalation Engineers in Product Support, just posted details of an interesting case over on the CSS blog – his article
While I was teaching the MCM-Database class last week, we were discussing fragmentation and the effect of a high-order GUID key on an index. Without
Last week’s survey was on what kind of regular index maintenance you perform (see here for the survey) as a way of kicking off a
I'm about to start a new series of post about index fragmentation and removing it. For this week's survey, I'd like to know what index
The April edition of TechNet Magazine is available on the web now and has the latest installment of my regular SQL Q&A column. This month's
At the user group meeting on Monday I spent some time explaining how GUIDs can cause fragmentation in clustered indexes AND in non-clustered indexes, even
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.