Viewing 15 posts - 1,891 through 1,905 (of 22,224 total)
I'd suggest next time you run a blocking report to understand why it's blocking. SELECT COUNT(*) has to do a scan, either of the table or an index. It's counting...
"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
March 10, 2020 at 11:05 am
Running out of support software is a serious business risk. I'd focus on that above anything else. I know this stuff comes with a price tag, but talk to 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
March 9, 2020 at 1:31 pm
Take a look at the execution plans when it's compiling in each compatibility mode to understand how the behavior is changing.
"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
March 9, 2020 at 11:49 am
You're trying to do an in-place upgrade? This is the installation software that is generating these errors? I'm unclear precisely what's happening.
Also, whatever you do, avoid updating to 2014. It'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
March 9, 2020 at 11:47 am
Without seeing the code, it's hard to know for sure if this is the best way to get things done. It is possible within T-SQL to reference a data set...
"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
March 9, 2020 at 11:42 am
"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
March 5, 2020 at 8:05 am
Well, that's the answer to your questions.
"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
March 5, 2020 at 8:01 am
Without data, we're talking nothing but guesses, and vague bad guesses at that. Go and turn on monitoring on the server. Set up Query Store. Enable an Extended Events session....
"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
March 5, 2020 at 4:33 am
The answer to both questions is Extended Events. That's what it's there for. Why would you NOT use it?
There is SQL Server Audit for the logins (not query calls),...
"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
March 3, 2020 at 10:01 am
Without more information, it's hard to say. An INSERT requires exclusive access while a SELECT can used shared access, or, if you have it enabled, snapshot copies of the data....
"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
March 3, 2020 at 9:58 am
one specific object common.
We have Object A which is common in some database, will have to retrieve the current row of Object A in all databases and insert 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
March 3, 2020 at 9:35 am
CHECKDB is actually a series of commands. Just break down the commands and do them separately. The documentation is online and elsewhere.
Your prod and non-prod databases have to be...
"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
March 3, 2020 at 9:33 am
we are looking for a list of databases where there is one objects in common, Is there DB script ?
Thanks
So any object in common or a specific object in...
"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
March 2, 2020 at 8:30 am
I'd look into the Activity Logs then. That's going to be the best bet from what I can see.
"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
February 28, 2020 at 6:22 pm
Honestly, I don't know that I'd be knocking down the door today to move from 2017 to 2019. Mostly, 2017 is just working great. Mostly, 2019 is an awesome upgrade,...
"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
February 27, 2020 at 1:44 pm
Viewing 15 posts - 1,891 through 1,905 (of 22,224 total)