Viewing 15 posts - 1,456 through 1,470 (of 22,219 total)
Personally, I want to bring back the in-person events.
However, I suspect that Ed is correct. It's not really a question of organizing one, or being legal within your locality. 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
February 1, 2021 at 7:10 pm
I like all these ideas, especially William's.
Keep 'em coming.
"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 1, 2021 at 7:04 pm
Nope. No code. Just the brand stuff.
"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 1, 2021 at 7:02 pm
You can't tell me I'm wrong. Don't you know who I am?
Wait. You know exactly who I am.
Ha!
No real arguments here Jeff. DevOps is about culture first, not tools. Process...
"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
January 30, 2021 at 3:11 pm
Grant/Steve/anyone else, just received the email about PASS legacy moving to RedGate, well done for any/all of you who made that happen!
Cheers!
Wasn't me, but I'm pretty excited about it.
"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
January 28, 2021 at 8:51 pm
Literally nothing to go on.
Where are you running backup commands from?
Look there to see what the connection settings are, etc. If necessary, fire up an Extended Events session and watch...
"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
January 27, 2021 at 12:24 pm
Nope.
A restoring database is in the process of moving all the data pages and then recovering any transactions. They just can't be accessed. At all.
To solve this, I'd look outside...
"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
January 26, 2021 at 12:59 pm
Same answer as on 2012. The CU, cumulative update, is what it says, cumulative. Any other patches are individual.
"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
January 22, 2021 at 11:55 am
The security updates are not cumulative, so yeah, you'd need to install them separately. BTW, according to this site, there are three, not two for 2012 SP4.
"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
January 22, 2021 at 11:54 am
Hard to say without details.
It depends.
It could be that you simply have queries running against the table that are filtering on columns where a non-clustered index could help. But, it...
"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
January 21, 2021 at 6:17 pm
Just remember, the first column is the column used to create the histogram in statistics. The histogram is one of the leading drivers for the optimizer to make determinations on...
"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
January 21, 2021 at 1:33 pm
The only way you can tell this is if you have a monitoring system set up. Either one you build yourself using Perfmon counters, or a 3rd party tool. There'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
January 13, 2021 at 1:56 pm
Personally, I'd got the third party route. It's going to be a lot easier. However, yeah, there are tools. First, get PerfMon. Capture the appropriate counters there. You can program...
"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
January 13, 2021 at 1:52 pm
It's completely dependent on the indexes. I know Minion lets you pick lists of indexes & break up the process. I suppose Ola's script must too. Do that. Do 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
January 13, 2021 at 1:47 pm
There's a lot to unpack here, but I'll try to answer some of it.
First question, can you identify which tables have been changed between two dates? Yes. The key to...
"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
January 13, 2021 at 1:45 pm
Viewing 15 posts - 1,456 through 1,470 (of 22,219 total)