Viewing 15 posts - 3,616 through 3,630 (of 22,224 total)
Can't you just reverse the relationship then? The "child" sure sounds like it's the primary record more than the "parent".
For what it's worth, you could have a nullable...
"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
September 2, 2017 at 6:49 am
The question you're attempting to answer consists of two data sets. One is the FirstName, etc, that comes from the straight forward part of the query joining Employee and Person....
"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
September 1, 2017 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
August 31, 2017 at 8:10 am
Hi 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
August 31, 2017 at 6:47 am
Please, listen to what Lowell said. Don't shut off the server. I see that happen so often and it just makes this situation worse. Wait. It will clear eventually.
"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
August 31, 2017 at 6:43 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
August 31, 2017 at 6:25 am
Happy to hear SQL Monitor is helping.
I agree on the community. SQL Server Central has helped me tons over the years.
By the way, if you 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
August 31, 2017 at 6:23 am
Blocking will lead to waits, but it's not necessarily going to appear in the top waits, depending on which resource is blocking on what. It can all get pretty much...
"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
August 30, 2017 at 10:02 am
In addition to MAXDOP, it's a good idea to set the Cost Threshold for Parallelism to a higher value than the default of 5. Out of the box. You'll see...
"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
August 30, 2017 at 8:54 am
It's only 10 at a time in the GUI. You can query the database directly to get more specific info if you want. If you highlight a query, you will,...
"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
August 30, 2017 at 8:44 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
August 30, 2017 at 7:20 am
You absolutely cannot reference master from another database, so that won't work at all (currently, wait until the Instance as a Service is released, that could change). My immediate though...
"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
August 30, 2017 at 6:55 am
Using SQL Monitor, you can sort the queries by duration, waits, several different ways. If you use the top of the screen to highlight a particular time range, say 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
August 30, 2017 at 6:04 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
August 29, 2017 at 9:43 am
Yowch! Things sure took a turn for the worse on those. I can see...
"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
August 28, 2017 at 10:14 am
Viewing 15 posts - 3,616 through 3,630 (of 22,224 total)