Performance bug: NOLOCK scans involving off-row LOB data
Here's an interesting bug that was just recently fixed, and someone actually hit it today, so it's time to blog it. Bottom line is that
Here's an interesting bug that was just recently fixed, and someone actually hit it today, so it's time to blog it. Bottom line is that
(Thanks to David Baffaleuf for pointing this out to me) Ever wanted to know a bit deeper how memory works in your laptop or servers?
I was in a discussion earlier today, and it's one I've had lots of times in the past – both inside and outside Microsoft and
People are saying they can't find me – that's a Twitter issue with indexing. Here's the direct link: http://twitter.com/PaulRandal and Kimberly's at http://twitter.com/KimberlyLTripp
After being mercilessly pressurized by many people (and I blame Jason Massie the most), I've joined Twitter and I'll be commenting lots on it. Why
In this week's survey I'm interested in what kind of backups you take, and also what recovery model you mostly use. If you have multiple
A couple of weeks ago I kicked off the latest survey, on what the physical layout of your databases are and why you have them
Finally! All those customers out there who are frustrated by not being able to turn on the 'lock pages in memory' option to protect the
[Edit 2016: This trace flag is required in all version of SQL Server up to and including SQL Server 2014. Every instance of SQL Server
In this trip to India (teaching for MS again) we're in and out, with no time for sight-seeing, but there's always time for bird-watching! I
In my previous posts on FILESTREAM I discussed the directory structure of the FILESTREAM data container and how to map the directories to database tables and
A short post to start the day (in India) and then at lunchtime I'll do how it works: FILESTREAM garbage collection. This is a question
Every so often (well, ok, very frequently) my internal list of ‘I must blog about that’ gets too big and I have an almost
Last week I kicked off a survey about the physical layout of your databases, based on database size. I'm running it for two weeks and
This feels like a bit of a strange post for me to make, but I want to make it anyway, and don't take it the
Not much to do here in Tokyo while waiting for the Bangkok flight except read and blog, and I've already done enough reading for one
Microsoft's popular performance troubleshooting whitepaper has been updated for SQL Server 2008. You can download Troubleshooting Performance Problems in SQL Server 2008 at http://download.microsoft.com/download/D/B/D/DBDE7972-1EB9-470A-BA18-58849DB3EB3B/TShootPerfProbs2008.docx. I've
At the last few conferences I've presented at, there have been questions about using SSDs (Solid-State Drives) for enterprise storage and whether that will change
This week's survey is a little more complicated. I'm interested in the physical layout of your databases. I've got four surveys, for a variety of database
Last week's survey was on how *you* manage the size of your transaction log (see here for the survey). Here are the results as of 4/10/2009
See http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=66ab3dbb-bf3e-4f46-9559-ccc6a4f9dc19 for the download, release notes, etc
This is a hilarious video of what Facebook would be in real-life – well worth a couple of minutes for a lunch-time laugh. http://www.youtube.com/watch?v=LrFdOz1Mj8Q Enjoy!
In this week's survey, I'm interested in how *you* manage the size of your transaction log. I'll report on the results around 4/10/2009. Thanks! (No
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
The May 2009 TechNet Magazine is now available online, and it's the annual security issue. In there is an article I wrote highlighting 10 common
Not an April Fool (although SQL Server Central has a great one) – Kimberly and I were both re-awarded MVP status for another year –
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.