Viewing 15 posts - 2,911 through 2,925 (of 22,227 total)
One point, since there are a large quantity of completely different databases that store healthcare information, you are unlikely to find a generic list of "SQL queries" that will apply...
"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
October 16, 2018 at 5:55 am
The basic principle of CROSS APPLY can be summed up as, for each row in my data set (defined by the table or tables you're using the CROSS APPLY against)...
"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
October 16, 2018 at 5:52 am
If you'll notice it appears a third time right next to the first CONSTRAINT. What you're seeing are different pieces of the command. The first, capitalized, reference is 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
October 16, 2018 at 5:44 am
That's.... a lot.
From an update I can imagine a scenario where you get quite a few page splits and end up with the size growing 2-4 times. A...
"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
October 15, 2018 at 12:27 pm
"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
October 15, 2018 at 10:20 am
Haunted mouse for Halloween. Seems appropriate.
"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
October 15, 2018 at 7:33 am
There are a bunch of things that could cause differences between environments. ANSI connection settings, cost threshold for parallelism, max degree of parallelism, memory, cpu, disks, data, statistics, structures. Any...
"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
October 15, 2018 at 7:29 am
And our buddy is sending me private messages now. I can't believe how far he's gone in trying to get answers to questions he already has answers to. Ah well....
"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
October 15, 2018 at 7:07 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
October 11, 2018 at 3:21 pm
"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
October 11, 2018 at 11:11 am
He's trolling us. His last post said he'd been working on this bug...
"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
October 11, 2018 at 5:46 am
And I'm done. I really did try, but at the end, it was a serious waste of typing and CPU power. Ah well. I guess I'll never see the super...
"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
October 11, 2018 at 5:37 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
October 11, 2018 at 5:32 am
Just reemphasizing the single most important idea here... Test your restores. Test a point in time recovery. Validate that none of this results in you violating your RPO & RTO...
"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
October 11, 2018 at 4:33 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
October 11, 2018 at 4:30 am
Viewing 15 posts - 2,911 through 2,925 (of 22,227 total)