Right. So see the difference? One thinks nearly 100 rows. The other thinks only 8. The slow one used a loops join to process 1200 rows. A hash join is...

So, the issue isn't the particular join, different ones are used for different reasons. What the issue is, is likely data or statistics related. It's probable that each of your...

I haven't read the whole article. The core of both statements is correct. Fragmentation can lead to extra reads on disk. The issue is, defragmentation leads to refragmentation. To really...

Oh, I'm not practicing law or offering legal advice. It says right there in the editorial, first, legal and business, second, technical. However, meeting the technical needs of pretty much...

Heck, I didn't know it checked for available space.

Fixed it. Not sure how to deal with anyone's lost points though. Sorry. I'm new to this whole admin thing.

Sorry everyone. I'm working to get this fixed.

We have an excellent primer on T-SQL right here on this web site. I'd suggest you read through that and if anything doesn't make sense, please ask. However,...

I do love me some SQL Prompt from Redgate Software. It does more than just format the code. It also provides type-ahead, supports Azure SQL Database and Managed...

Check the links in my signature. The book on execution plans will help.