Viewing 15 posts - 14,176 through 14,190 (of 22,227 total)
Alvin Ramard (10/6/2010)
Kit G (10/6/2010)
Grant Fritchey (10/6/2010)
bitbucket-25253 (10/5/2010)
Now how many members of the thread will be coming...
"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 6, 2010 at 7:18 am
samalex (10/6/2010)
Thanks for the great advice, but the problem we're running into is we don't know if a client will want cash flows and other tables that roll...
"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 6, 2010 at 7:16 am
I don't completely understand what's going on, so please excuse my ignorance.
First, can you explain in further detail why you can't have constraints?
I'm not a huge fan of GUIDs,...
"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 6, 2010 at 6:37 am
Even without an execution plan, I count five (5) different IN statements and I see a number of functions on columns in the WHERE clauses. Those alone will kill performance.
"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 6, 2010 at 6:06 am
What about setting up a server side trace to monitor for that query? You can capture who is calling it, when, from where, pretty much everything you need.
"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 6, 2010 at 6:03 am
Although, using sys.dm_exec_requests won't show blocking if parallelism is involved.
Another way to do it, and you can use almost the same query, is to look at sys.dm_os_waiting_tasks.
"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 6, 2010 at 6:01 am
Less than a thousand to go. I think it'll take another couple of days, but it's sure to be this week.
"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 6, 2010 at 5:54 am
GilaMonster (10/5/2010)
sqlbuddy123 (10/5/2010)
My two cents..You can check these books to become a master
I'll disagree slightly...
Books alone will not make you a master. Books + experience + experimentation may, with sufficient...
"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 6, 2010 at 5:41 am
Derrick Smith (10/5/2010)
"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 6, 2010 at 5:39 am
GilaMonster (10/6/2010)
Does anyone think my response here was over-the-top? http://www.sqlservercentral.com/Forums/FindPost999124.aspx
Not even a little bit. Very clear, to the point, fact based... looks fine to me.
"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 6, 2010 at 5:36 am
bitbucket-25253 (10/5/2010)
Just have to throw my 2 cents in and help the count along ....Now how many members of the thread will be coming to SQL Saturday#60 in Cleveland......
Sorry, not...
"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 6, 2010 at 5:34 am
John__A (10/5/2010)
Grant Fritchey (10/5/2010)
"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 5, 2010 at 1:55 pm
Alvin Ramard (10/5/2010)
Steve Jones - SSC Editor (10/5/2010)
Perhaps Gail could practice some archery in view of the office. Maybe aim for low down on the torso 😛
Waving a shiny piece...
"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 5, 2010 at 1:54 pm
I can't point to specifics, but I've seen anecdotal evidence that suggestions in some edge cases, the changes to the optimizer between 2000 and 2005 can product sub-optimal execution plans....
"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 5, 2010 at 11:39 am
GilaMonster (10/5/2010)
We're officially in UAT, though both the front-end dev and I are still developing. Had a meeting...
"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 5, 2010 at 11:24 am
Viewing 15 posts - 14,176 through 14,190 (of 22,227 total)