I'm not sure I understand the example that's giving you problems. Yeah, if the column names are different, you have to explicitly state them on an INSERT ... SELECT. That's...

One difference between the two is that the text field, where you're looking for table names, is different between the rpc_completed event and the sql_batch_completed event. In fact, you can't...

Nice work. I marked your second comment as the answer to the question. No need to delete your initial post. You answered it and shared that with others. All good.

Oh, I think they've done a much better job on that stuff lately. Most upgrades these days (talking SQL Server, not Windows, don't get me started on the OS) have...

When dealing with pre-release versions of SQL Server, I would strongly advise to do a full, and thorough, uninstall and not attempt to upgrade. You never know what bits of...

Measuring performance before and after the addition of the index and an examination of your execution plans (which are not a performance measure, merely a description of behavior) will tell...

Just saw this on a search for some information on Query Store. So, I know this is three years old. However...

I forgive you Mike.

Reboots, etc., do not directly affect the...

If we're talking IDE, it's mostly just ADS & SSMS. I also use VS Code when I'm writing Powershell for Azure. I'd definitely learn how to program Azure through Powershell....

There are any number of things to check, but I generally focus on wait statistics and query times. And honestly, mostly query times. Wait statistics tell you what things are...

I'd suggest adding a Continuous Integration step into your setup. Just deploy the code, without data, into a database, on commit of the code (or a push to a particular...

Stuff grows over time and we will absolutely, occasionally, make some poor choices. I would say external-internal-external-internal calls to the database are less than efficient and so, should be avoided....

I doubt there's a single video explaining that because some of that stuff is quite detailed. Take FILESTREAM for example. It's not enough to simply say that you have FILESTREAM...

Indexes?

Seems like a lot of work.

DBCC SHOW_STATISTICS

That does it.

You can also see some of this info from sys.dm_db_stats_properties, or, if you're on 2016, go straight to sys.dm_db_status_histogram...

It's called deferred name resolution. It allows you to create a procedure, view, or in your case, function, on objects that do not yet exist. It does this under the...