When did SQL Server stop putting indexes on Foreign Key columns?
The title is a common question I've received in the past and I thought I'd take a few minutes to explain a bit about keys
The title is a common question I've received in the past and I thought I'd take a few minutes to explain a bit about keys
People always ask me how I keep up to date with SQL Server and how I could possibly know so many intricate details about SQL
Q: How do I interpret DBCC SHOWCONTIG WITH ALL_INDEXES on index id = 255 on a table with multiple text columns. I’m looking at a
Q: Can I automate DBCC DBREINDEX to rebuild all tables on all databases on a server? Actually, yes and no… With stored procedures you’ll have
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
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, 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.