Yep. AdventureWorks in all it's messed up glory. Honestly, I love that sample database. Why? Because it looks like all the other messed up constructs I see everywhere else. It's...

Actually it sounds like you could put a tally table, or a table of numbers to work and simply pass in your 1-10 tanks (which really does sound like a...

Also, don't set the max of SQL Server to max of the system. You have to leave room for the operating system to have memory as well. While you can...

Without a WHERE clause, no filtering occurs, so it goes to the cluster to pull stuff together. If you want to eliminate the sort, you can create an index on...

Thank you everyone.  I have been saving the files to a folder.  it works for me because I only have a few queries. I am so used to...

If you do this a lot, create a stored procedure or maybe a view. If nothing else, have the query in a file that you can open & run. That...

Welcome to the party.

Pretty much what Jeff says (btw, that's a good mantra around here).

SQL Server's principal tool, SQL Server Management Studio (SSMS), has a thing called a project. I...

Along with what Grant has stated and since they said it did "regular" SQL Backups, have them do a test restore using native tools only to prove...

Yeah, go get that lottery ticket now.

Happy to hear it all worked out. As Jeff says, get going on those backups. In addition to all his great info, let add...

Are you sure the execution plans are identical? Did you run a compare on them to validate that? Just because they look the same, doesn't mean they are the same....

Deny is a trump over all other security. So, you may have a complex set up where a given user, because they're in a group, has access to a table...

ALL THE TESTING!!!!

I have to ask, what...

The problem is very likely in the queries, as has been stated. You can capture execution plans from Azure SQL Database. You can do it pretty much all the same...

Not to mention, learning how to present will help you at work, presenting a solution to the boss, teaching the team how to do stuff. It's a VERY transferable skill....