Viewing 15 posts - 2,746 through 2,760 (of 22,219 total)
I'm actually exploring it. Having some login issues using Azure AD, but...
"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, 2019 at 4:57 am
I have one app which usually keep checking for some reminder stuff and if find...
"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, 2019 at 4:55 am
How is the SSIS package run? If it's run from within SQL Server, meaning it gets deployed to the instance (and this is not the way that most people I...
"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, 2019 at 4:47 am
I agree with Steve's and Jeff's advice, but if this is HIPAA applicable PHI data, I'd stop providing that information right now. If you knowingly supply PHI data to unauthorized...
"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, 2019 at 4:28 am
I remember reading about a new campus which intentionally did...
"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 29, 2019 at 8:09 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
January 29, 2019 at 8:06 am
Glad to hear the book was useful. Thank you!
In that case, hit the stairways series, especially the more advanced topics. They'll give you lots to work on. Or,...
"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, 2019 at 9:15 am
Yep. You've got 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, 2019 at 6:49 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
January 28, 2019 at 5:53 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
January 28, 2019 at 5:38 am
Yeah, that's absolutely a violation of the GDPR, if you have EU citizens data in that. It's also a violation of HIPAA if there is private health information in 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, 2019 at 5:35 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
January 28, 2019 at 5:27 am
Yeah, that works. It's hard to convince people that behavior is behavior is behavior. It's down to the system settings and the statistics. In fact, I'd worry more about inconsistency...
"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 25, 2019 at 1:39 pm
Yep. Effectively you're dropping and recreating the table, so everything has to go.
"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 25, 2019 at 6:38 am
The only suggestion I have is to make sure you're on the latest version of SSMS. They're updated completely independently from SQL Server now, so you need to patch them...
"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 25, 2019 at 6:36 am
Viewing 15 posts - 2,746 through 2,760 (of 22,219 total)