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
Menu
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 –
Just noticed this come up on my Facebook news feed – how to code assignment statements when programming (not in T-SQL): if (foo == 4)
In February this year we stopped off in Bangkok on the way to and from teaching in Hyderabad. On one of the days we did some
(And it's official – this is blog post 39 this month, making this my most prolific month yet for blogging. An arguably dubious achievement…) In
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
Just saw this on a forum – running REPAIR_ALLOW_DATA_LOSS on msdb to cope with corruption. Yes, this will work but it's certainly not safe and
(Yes, Kimberly's lecturing again…) Here's something that I've seen crop up a lot recently on corruption forums: Server: Msg 602, Level 21, State 50, Line
(Continuing my habit of blogging while Kimberly’s presenting – at least I’m not on stage this time…) In early versions of SQL Server, it was
I'm very pleased, and deeply honored, to announce that I've been made a Microsoft Regional Director. This is one of a very small group of
After teaching some of the MCM-SharePoint class last week, one of the attendees pointed me at a blog post about measuring churn in SharePoint databases.
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
A thread cropped up on SQLServerCentral involving IAM chain corruption (see Inside the Storage Engine: IAM pages, IAM chains, and allocation units for details of IAM
In this week's survey, I'd like to know *how* you run consistency checks, not how often. I'll report on the results next week (around 3/27/09)
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
Way back at the start of me blogging here I wrote a comprehensive description of ghost records and the ghost cleanup process – see Inside
I’m teaching the Microsoft Certified Masters – Database qualification this week here in Redmond, and in part of day one I discuss the FILESTREAM directory
There's a long-running discussion with people tagging each other to post advice for people new to SQL Server, about what they know now and wished
Yes, it's that time again (well a little bit earlier than usual). With the Spring SQL Server Connections show coming up next week, its time
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
Last week I kicked off the first weekly survey – on whether you validate your backups or not (see here for the survey). The results
Ola Hallengren, who we meet every so often at SQL Connections, has a great script that helps automate consistency checking, backups, and index maintenance. He's
Ok – so Kimberly got on Facebook last weekend after peer-pressure from a bunch of people at Katie's 9th birthday party. I resisted, in vain
After writing the FILESTREAM whitepaper for Microsoft, I’ve had lots of questions about the structure of the FILESTREAM data container. The FILESTREAM data container is
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.