Viewing 15 posts - 1,861 through 1,875 (of 22,224 total)
No company could have been prepared for this. And, because of that, I fear that real thought will not be put into the decision about who to get rid...
"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
April 8, 2020 at 7:42 pm
Well, the big company meeting announcing what changes will be made was held this morning. I will still have a job, but everyone making over 60k is getting...
"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
April 8, 2020 at 7:40 pm
Sensitive data should absolutely not be in use in dev & test servers that means the data needs to me masked in dev?
Yes!
General Data Protection Regulation, California Citizens Privacy...
"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
April 8, 2020 at 6:06 pm
Sensitive data should absolutely not be in use in dev & test servers. So that shouldn't be a problem.
"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
April 8, 2020 at 2:08 am
Pretty sure it was Jesus who said: You will always have the idiots with you. Or something like that. I'd just say that even with that... individual, better 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 28, 2020 at 11:56 am
Nuts. I'm stuck. Have you compared the plans?
"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 25, 2020 at 3:06 pm
Since you can't do a backup & restore locally, you're doing a BACPAC I assume? Since that rebuilds the indexes, it also resets all statistics. I'd focus there as 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 25, 2020 at 1:59 pm
You can't do that.
If you want to, you can:
SELECT @Result = a.SomeColumn
FROM dbo.ATable AS a
WHEREa.id=42;
"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 24, 2020 at 11:51 am
Grant - just reading your wordpress blog - it strikes me that I'm missing some skills in monitoring SSRS and SSIS using XE... might be a nice topic
we all...
"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 23, 2020 at 3:06 pm
If you can, post both execution plans. By and large, Azure SQL Database just works exactly the same as regular SQL Server. So, all things being equal, a good index...
"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 23, 2020 at 10:23 am
maybe rather than live webinars, you could do what Microsoft virtual academy did... stick a 10 minute video up on line and we have it on demand. brent ozar...
"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 23, 2020 at 10:15 am
Right now I need someone to watch the toddler so I can appropriately encrypted databases on 2 servers with a third party key holder. This is hard to do...
"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 23, 2020 at 10:08 am
Serious question for the Thread.
What do you need that I could do to help you out right now? I don't mean give you my toilet paper supply. I mean is...
"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 23, 2020 at 9:41 am
Strongest possible consideration, completely ignoring your SSRS question, don't do it. Don't upgrade to 2014. It introduces problems without good solutions. 2016 or better is the way to go. 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 18, 2020 at 9:31 am
Now you've gone and done it - I need to boil my laptop now.
In keeping with the tenor of the times, I'm just throwing mine away rather than take...
"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 17, 2020 at 12:12 pm
Viewing 15 posts - 1,861 through 1,875 (of 22,224 total)