Azure SQL Database is a platform as a service offering. You get a database. Under the covers, it's just SQL Server (a special version of SQL Server) running on Microsoft's...

If you're looking at a default setting for MaxDOP, good chance you also have a default setting for Cost Threshold for Parallelism. In addition to changing your MaxDOP setting, which...

Strong recommendation, get a copy of my book in the link below. It'll show you have to capture more information about your queries (you should use Extended events to capture...

CXPacket waits (prior to SQL Server 2016 sp1 and above) just mean that parallelism is occurring on your system. Look to other wait types to see what issues are happening.

Yeah,...

In addition to the infrastructure suggestions, tune the queries. Ensure appropriate indexes. Keep statistics up to date. Ensure an appropriate data infrastructure. These are very common issues in and around...

You want to get yourself familiar with AZCopy. That's the tool that will help.

Just a note, the only reason that CAST is not causing a scan in this scenario is because the column is a DATE column (or maybe DATETIME), so the optimizer...

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