Viewing 15 posts - 3,601 through 3,615 (of 22,219 total)
Hey guys, a bunch of you are older and a bunch of you are SF fans, so I'm hoping the Venn touches.
There was a book from the 70s...
"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 6, 2017 at 7:08 am
Full disclosure, I work for a software vendor that makes a monitoring product, so feel free to dismiss this on that basis.
Don't try to build your own...
"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 6, 2017 at 6:03 am
Errors. Lots of errors. It doesn't fail all that gracefully at all. Best to avoid 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
September 6, 2017 at 5:52 am
However,...
"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 5, 2017 at 3:33 pm
Not entirely.
The query optimizer is completely dependent on the statistics on the table. So, let's say you turn off the automatic statistics maintenance when there is only one...
"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 5, 2017 at 9:51 am
I'm not aware of a specific type of recommendation along those lines. I can say, 16gb of memory and 32 cores is NUTS! My laptop has 16gb of memory for...
"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 5, 2017 at 8:09 am
COPY_ONLY backs up everything that the regular backup does. It just doesn't put a marker down in the database that a backup has been done (possibly interfering with differential backups)....
"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 5, 2017 at 7:08 am
I am a hop fanatic. IPAs are glorious and wonderful.
"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 5, 2017 at 7:03 am
Thom has it nailed. Without information, we can't help.
One little point, depending on the type of query (and since we can't see it, who knows), putting everything into...
"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 5, 2017 at 5:56 am
If you could post an actual execution plan, it would make diagnosing the query much easier. Make it a plan that includes the aggregations because what you're seeing is changes...
"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 7:02 am
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
Viewing 15 posts - 3,601 through 3,615 (of 22,219 total)