The file is coming down as a binary, so I can't look at it. Sorry. However, it's likely that it's what everyone else says. Also, you may see more reads...

Take a look at what the execution plan is doing. That query hint may be resulting in a scan instead of a seek. That would explain an increase in the...

Excellent post Dave, and not just because I got mentioned. Ha!

Seriously though, I think you're hitting the nail on the head with this one. Now, I work for Redgate, so...

Yes, get the CUs installed. That's very important.

Sure, you can increase the connection timeout, but it's not going to address the core issue.

The core issue is performance. You have long...

OK. So, first question, does it matter that the numbers are perfectly sequential? Is it OK if there are gaps occasionally? If so, you should look to the SEQUENCE...

Yeah, I'm with Andrey. Something along those lines could be likely. However, at a fundamental level, comparing the on-premises version of SQL Server to Azure SQL Database at any level...

My name is Grant Fritchey and I endorse this message. Except I'd change it slightly:

I don't trust anyone... especially not myself!

Do you guys run EVERYTHING that goes into production through QA/UAT, or do you trust some users if they have a proven track record of high scores, and only...

If your primary key is not the clustered index, this is extremely concerning. If it is, how are you measuring the table size as compared to the index size? As...

Oh boy, this is a fun topic.

So, SSDs. VERY fast. However, I/O is I/O. No matter how fast your disks, more I/O means slower performance. Comparing reading 8 pages on...

My Mom (who isn't a tech person) thought that Microsoft updates would come down to her laptop if it was plugged in, but the lid was closed. She...

Just shoot me.

I endorse this message.

YAY!

Buy more licenses. I love making...

1. If you only have batches, and no prepared statements or stored procedures, fine, you don't need rpc_completed. Otherwise, you do.
2. Extended Events is not trace. You don't pick columns....