Logins are not really a thing in Azure. I mean, they are, but they're not. It's down to users at the database level. It's key to always think of the...

You could use the compare utility within SSDT to move only parts of a deployment. Automating that is likely to be somewhat difficult.

Lat & long are numbers, not characters. Transaction sequence, almost definitely a number. Wow.

I'm not sure what my point really was, but I guess it wasn't really arguing about where to put the semicolon. My issue is more with the lack of...

If you're exploring if stats are the problem, no, I wouldn't update first. Instead, look to the execution plans and see what the estimated number of rows is. Then, look...

Additionally, remember that unique indexes drive choices by the optimizer but may never end up in sys.dm_db_index_usage_stats, so be extra cautious about using that as a reference for which indexes...

For the love of Codd, store numbers in a number defined column and strings in string defined columns. Anything else is begging for trouble.

In this case, CAST is your...

Yeah, it's the "why" really, for the most part.

Look, code any way you want to. It's not my place to dictate or declare anyone wrong, or evil or anything like...

Hey all, a bit rushed this AM. Thanks for all the feedback. Appreciate.

And yeah, fully teaching the why's & how-fors & 'causes around stuff like SELECT * or ;WITH or...

100%. Absolutely. The semi colon is a statement terminator. Meaning, the previous statement has to have...

So, you're jamming that semi-colon, which is a statement TERMINATOR, at the front of your WITH clause. Are you doing that on the second query? That could be the issue....

And, you're hopping a pretty big gap, the cardinality estimation engine change that occurred in 2014. You need to plan for that just as you worry about the exact versions...

You can't create a view from a stored procedure.

Why do you need to create a view from a proc? A view is something that should be created and left on...

If a query was in a wait state, as soon as the blocking process clears, it will start to execute again, no manual intervention required. If the query in question...

Page Life Expectancy is a crappy measure of performance. A common pattern is that sawtooth look that it gets. It grows & grows, then there's a data load, so the...