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
One of my favorite features of Management Studio is the ability to “script” a step rather than execute it. Within SQL Management Studio, each dialog
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:
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
** 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
Well… the performance ramifications are… not good! Without seeing more of the proc I’d have to suggest that you avoid this like the plague! I
Index Management/Maintenance Questions: Q: Is there a tool or method for monitoring a database for awhile to identify indexes that are rarely or never used
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.