Viewing 15 posts - 20,161 through 20,175 (of 22,219 total)
Not knowing your system, your code or any special circumstances that you're laboring under, I'd go with my standard set. I've got them documented here[/url].
"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
June 12, 2008 at 12:34 pm
It doesn't give enough details on that page to determine if there's a funky business requirement or even if that initial model is updated in the demo. I'm still falling...
"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
June 12, 2008 at 11:45 am
No, I haven't gone there yet. Actually, I keep forgetting that dmv exists.
Yeah, it's working just fine.
"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
June 12, 2008 at 11:40 am
It might be possible in Access. I'm happy to say, I wouldn't know how to go about it at 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
June 12, 2008 at 11:38 am
Unless there's a pretty major application or performance reason, I'd have to agree that this is a crappy "real world" example.
"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
June 12, 2008 at 11:18 am
SQL Server is not Access.
Access is doing two things there. First it's maintaining referential integrity between two tables. Second, it's providing you with a GUI (graphical user interface) to look...
"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
June 12, 2008 at 11:15 am
If you're in the GUI, you can simply right click the job and select "Script Job as... CREATE to" and pick where you want the script stored. Edit any localization...
"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
June 12, 2008 at 11:04 am
I agree with you. Your MaxDop should be 8 or less.
As to the main question. I'd run a trace out to a file and start working on the longest running...
"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
June 12, 2008 at 10:59 am
Some of them. I've gone out to eat or to the bar with co-workers that I basically refer to as friends once we start that type of behavior. Others... No....
"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
June 12, 2008 at 10:53 am
Triple cross post. Please no one answer here.
"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
June 12, 2008 at 10:49 am
Two answers. Yes, it's possible. What you want is a foreign key to another table to ensure integrity between the data entered on one table and the data entered on...
"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
June 12, 2008 at 10:44 am
All right, now I'm mad.
If I run a profiler trace and capture XML execution plans, I can save those to file. They save correctly as UNICODE.
What the heck is...
"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
June 12, 2008 at 10:40 am
Yes, that was the answer.
Well, at least it wasn't something stupid that I did (for once).
This is a bit of a pain. I wonder if there's a work around.
"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
June 12, 2008 at 10:26 am
It sounds like you're using up resources. I'd suggest using perfmon & trace to see what's happening with the server & the queries respectively.
90% cache hit ratio isn't 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
June 12, 2008 at 5:50 am
I can't help you with SSIS. I just don't know anything about what's going on there in 2008 yet.
SSRS on the other hand, I've got some knowledge. In addition to...
"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
June 12, 2008 at 5:42 am
Viewing 15 posts - 20,161 through 20,175 (of 22,219 total)