Viewing 15 posts - 2,896 through 2,910 (of 22,219 total)
Nope. Not normal. So...
How are the measures being done? I'd suggest doing the measures on the server using extended events (or, if this is really 2008, trace events)....
"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 22, 2018 at 12:20 pm
There are exceedingly few books on any topic in Azure because it moves too quickly for most of us to write a book on the topic. There are however tons...
"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 22, 2018 at 6:41 am
Without the structure, I'm not going to attempt to write the T-SQL, but you could use a TOP 1 value for the matching between your temporary table and the actual...
"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 22, 2018 at 6:29 am
Look at the statistics directly. Evaluate why it's receiving the numbers it's receiving. Is the data in the histogram accurately reflecting the data in the underlying table? Is your filter...
"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 22, 2018 at 6:25 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 19, 2018 at 1:17 pm
BrainDonor - Tuesday, October 16, 2018 8:09 AMAnybody else from here going to Thursday's SQL In The City event?
I might swing by.
"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 9:08 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 16, 2018 at 6:24 am
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
Viewing 15 posts - 2,896 through 2,910 (of 22,219 total)