A SQL Server DBA myth a day: (19/30) TRUNCATE TABLE is non-logged
(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
(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
Yes, it's that time again. We've just completed the Spring show so its time to start planning for the Fall 2010 show. Once again Kimberly and I
(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
(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
(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
(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
(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
(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
(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
(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
(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
(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
(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
(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
(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
(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
(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
(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
(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
(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
(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
We both just got the MVP renewal emails – although I must admit to having some April Fools fun this morning on Twitter and the
I couldn't think of a really good April Fools Day joke to play, so I thought I'd share with you one that I played on
Blog posts in this series: For the hardware setup I'm using, see this post. For an explanation of log growth and its effect on perf, see this
Great news! Kimberly and I have started doing a bunch of work with SQL Server Magazine (of course we're already pretty heavily involved with their parent
Once in a blue moon I come across something cool and it happens to be Friday, and I blog about it. Last time was drinking
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
Back in January I offered a promotion as a way of introducing our maintenance/operations auditing services. Now I've completed a bunch of them, with some
Blog posts in this series: For the hardware setup I'm using, see this post. For an explanation of log growth and its effect on perf, see this
The March 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
Christmas comes but once a year… really? Then mine just came early on this afternoon's UPS truck. The very nice folks at Fusion-io just sent
Our first public class of the year is just over 3 weeks away! This is the *only* public class we'll be teaching in the US
(Check out our Pluralsight online training course: SQL Server: Improving Storage Subsystem Performance.) A while ago I blogged about disk partition alignment, and how the default
The very worst piece of advice I ever saw on the Internet was in response to someone asking on a SQL newsgroup ‘how can I
Blog posts in this series: For the hardware setup I'm using, see this post. For the baseline performance measurements for this benchmark, see this post. For the
[Edit 2017: this query is still entirely applicable on all current versions of SQL Server.] Here’s a little script I knocked up this afternoon to
(For the hardware setup I’m using, see this post. For the baseline performance measurements for this benchmark, see this post.) In my previous post in the
Back in September I blogged about an old 2005 bug that prevented DBCC CHECKFILEGROUP checking the partitions of an object on the specified filegroup unless
(For the hardware setup I’m using, see this post.) As part of my new benchmarking series I first wanted to play around with different configurations of
Okay, this post is describing some new services we provide (we are a consulting firm after all :-), but there's a promotion at the bottom where
I'm running some performance tests on the hardware we have (more details on the first of these tomorrow) and I was surprised to see some
At the start of the year I decided to get seriously back into playing with electronics after a long haitus. I agonized about where to
Yesterday I was discussing life-direction-changing-events with Kimberly and our great friend Libby and I thought it would be interesting to find out from people how
A couple of years ago I blogged about 3rd-party file system filter drivers and how if they're not coded correctly to cope with NTFS alternate
I've blogged about ghost records and the ghost cleanup task a couple of time before (the only place it is really explained AFAIK), but one
This is a quick post to clarify an article I saw on SQLServerCentral this morning that seemed to state that transaction rollbacks push data into
Due to some Microsoft date changes, the Spring SQL Connections show had to move to the week of April 12th. As a knock-on effect –
Happy New Year! The January edition of TechNet Magazine is available on the web now and has the latest installment of my regular SQL Q&A
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.