Viewing 15 posts - 17,701 through 17,715 (of 22,226 total)
Tara (4/16/2009)
insert SIRSdata
select R.*
from Budget..Hrbg as R , Revenue..BudHrbg as BD
where R.BudID= BD.BudID and R.servcdate between BD.startDate and BD.endDate
this query is taking too long to run, is there any alternate...
"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
April 16, 2009 at 11:33 am
Jeff Moden (4/16/2009)
Thread softly and carry a big pork chop.
You owe my company a new monitor.
Ha!
"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
April 16, 2009 at 11:26 am
If you know the values of StartDt & EndDt are likely to be, break them down into smaller chunks so that you're only moving certain date ranges.
"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
April 16, 2009 at 11:25 am
Jack Corbett (4/16/2009)
GSquared (4/16/2009)
"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
April 16, 2009 at 9:25 am
Grant Fritchey (4/16/2009)
Bob Hovious (4/16/2009)
First there was.... "The Thread".
Then came the "The Son of Thread".
Future Titles
The Other Thread
Revenge of The Thread
Return...
"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
April 16, 2009 at 8:25 am
Sounds like pressure on the memory. Were you capturing performance counters. Do you have Page Life Expectancy? That's a good measure of what's happening with SQL Server memory management.
"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
April 16, 2009 at 8:12 am
I'm sorry, but I really don't understand the question. Can you post a bit of sample code for what you're trying to 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
April 16, 2009 at 8:06 am
Bob Hovious (4/16/2009)
First there was.... "The Thread".
Then came the "The Son of Thread".
Future Titles
The Other Thread
Revenge of The Thread
Return of 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
April 16, 2009 at 8:04 am
All I know is, if the THREAD starts to approach 5000 posts, I'm going to hunt it down & kill it before it passes 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
April 16, 2009 at 8:00 am
Sounds pretty normal. As companies grow, a certain amount of tiers develop, at least for reporting purposes. I can talk to the CIO any time I want (I don't want...
"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
April 16, 2009 at 7:43 am
Maybe it's a delay? Steve would know. I'm sure he'll be by in a minute or three.
"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
April 16, 2009 at 7:41 am
Because every time you post to the forums you also get a point... there's another 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
April 16, 2009 at 7:28 am
It really depends on the system. We have a few tables on a couple of databases where, due to some issues, we're running update stats a couple of 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
April 16, 2009 at 6:00 am
I'm not aware of that one. Most of the showplan events are under the Performance section. Make sure you have "Show all Events" selected.
"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
April 16, 2009 at 5:50 am
The way to do something like that would be with at least two tables. The first table would hold the information about the person. The second table would hold relationships...
"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
April 16, 2009 at 5:38 am
Viewing 15 posts - 17,701 through 17,715 (of 22,226 total)