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....

Local variables won't be sniffed, so you avoid parameter sniffing... Unless you're getting recompiles. Then, a local variable also gets sniffed.

Ain't query tuning fun?

May be a data issue. The stuff getting loaded into the temp table is not stored as a date maybe? Hard to know not seeing the data. Check the data...

When say standard SQL, did you hard code passing the filters or use local variables? If you hard coded the values, it's the same as parameter sniffing (it's using those...