Viewing 15 posts - 5,581 through 5,595 (of 22,226 total)
There's a lot in there that needs addressing. The biggest issue is all the places where there are functions on the columns like this:
AC.dt>=(cast(CASE WHEN dbo.AGM_isdatenull(POR.PromiseDt) = 1 THEN POR.DueDate...
"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 4, 2015 at 5:21 am
TomThomson (9/3/2015)
Alvin Ramard (9/3/2015)
Grant Fritchey (9/3/2015)
Nope. Just faked out the entire MSDN...
"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 3, 2015 at 9:10 pm
Alvin Ramard (9/3/2015)
Ed Wagner (9/3/2015)
Grant Fritchey (9/3/2015)
Alvin Ramard (9/3/2015)
Jeff Moden (9/3/2015)
Alvin Ramard (9/3/2015)
Grant Fritchey (9/3/2015)
"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 3, 2015 at 12:59 pm
sqlkohai (9/3/2015)
"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 3, 2015 at 12:53 pm
Alvin Ramard (9/3/2015)
Jeff Moden (9/3/2015)
Alvin Ramard (9/3/2015)
Grant Fritchey (9/3/2015)
Nope. Just faked out...
"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 3, 2015 at 12:07 pm
Jeff Moden (9/3/2015)
Alvin Ramard (9/3/2015)
Grant Fritchey (9/3/2015)
Nope. Just faked out the entire...
"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 3, 2015 at 12:04 pm
Brandie Tarvin (9/3/2015)
Grant Fritchey (9/3/2015)
Nope. Just faked out the entire MSDN web...
"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 3, 2015 at 12:03 pm
Another funny one today. Provided a DMV and a link to the documentation. I was asked "Is that real?"
Nope. Just faked out the entire MSDN web site to pull 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
September 3, 2015 at 11:22 am
SQLRNNR (9/3/2015)
Lynn Pettis (9/3/2015)
Isn't it interesting how people think some things are bugs instead of not doing things right?Well not doing it right is a bug!!
If it doesn't do what...
"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 3, 2015 at 11:21 am
Yes. Click on the link. It's a dynamic management view (DMV) for tracking referenced objects from another object. It does at least part of what you need. The only issue...
"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 3, 2015 at 11:18 am
Not really. Certain parts of the language seem like a pain until you see all the possibilities for their use.
Let's take schemas. Most people, most of the time, use dbo...
"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 3, 2015 at 11:15 am
AAAAARRRRGGGHHHH!
The STUPID! It burns.
No, no links. Just needed to scream in agony for a moment. Go about your lives.
"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 3, 2015 at 10:41 am
Nope. If you change them to be owned by you, you have to give different sets of permissions to all the users. They won't even necessarily see them. Further, good...
"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 3, 2015 at 10:37 am
If what you're looking at says that SQL Server is consuming 24gb, that's what it's consuming, not 24 + 100. You're missing the point.
Also, while there is some OS memory...
"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 3, 2015 at 10:32 am
ZZartin (9/3/2015)
"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 3, 2015 at 10:29 am
Viewing 15 posts - 5,581 through 5,595 (of 22,226 total)