Quick entry to let you know that Kimberly L. Tripp will be on .NET Rocks tomorrow evening from 7-9p.m. Pacific Time. The show is recorded
These pictures are amazing so I thought everyone would enjoy this entry but it’s mostly to say congrats to Kevin and Stephen for summitting another
Q: Is there another way to determine fragmentation? I don’t want to use DBCC SHOWCONTIG as it locks objects. Well, this is a good question
So, this weekend my partner went a bid mad. He decided that we needed a holiday with the kids and his parents… So off we
Before I launch into the Q&A from this area there are a few other resources with Index Usage Q&A that you should also check out:
Q: What about using uniqueidentifier fields for keys in a clustered index, will this affect performance? They are random numbers so they are not monotonically
Q: Does clustering rely on the operating system for performance? Well, I have to admit I am not entirely sure of the question here… But
Q: Can I view a recording of this webcast? On demand MSDN webcasts (in general) can be found here. The Index Defragmentation Best Practices session
NOTE: These have NOT yet been completed and there are still a few questions that need to be answered. I will wrap these up shortly
Abstract: In SQL Server, Performance Tuning can be achieved through many avenues: hardware, software, the database and the client. While there are many pathes that
** Well, this started out as an easy “row size” write-up but I ended up adding a bunch of tangents in it and well, there’s
Well, the person then asked if we could sitdown… I said sure… We sat down at a table and they proceeded to rummage through their
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.