Viewing 15 posts - 736 through 750 (of 22,227 total)
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 22, 2022 at 1:44 pm
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 22, 2022 at 1:40 pm
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.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 22, 2022 at 1:25 pm
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 21, 2022 at 4:39 pm
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 21, 2022 at 2:04 pm
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 10, 2022 at 1:29 pm
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 10, 2022 at 12:57 pm
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....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 9, 2022 at 4:23 pm
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 7, 2022 at 5:56 pm
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 4, 2022 at 2:04 pm
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....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 4, 2022 at 2:01 pm
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 4, 2022 at 1:58 pm
Indexes?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 4, 2022 at 1:55 pm
Seems like a lot of work.
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 3, 2022 at 11:44 am
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 3, 2022 at 11:39 am
Viewing 15 posts - 736 through 750 (of 22,227 total)