Viewing 15 posts - 17,386 through 17,400 (of 22,219 total)
The queries look identical.
Post the execution plans.
Depending on the complexity of the query, the table order in the JOINs doesn't matter because SQL Server can rearrange them as needed, based...
"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
May 22, 2009 at 11:47 am
Just to deviate a bit from what everyone else is saying, if I were going to put any indexes on the system at all, because of how SQL Server stores...
"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
May 22, 2009 at 11:26 am
Yep, in the Navy on Subs. Hated it, but I'm glad I did 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
May 22, 2009 at 11:21 am
Oh, and my wife runs a Girl Scout troop and I pitch in there occasionally. That's one strange organization, especially after dealing with the BSA so much.
We're considering getting involved...
"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
May 22, 2009 at 11:19 am
Congratulations on achieving the rank of Eagle. That's an accomplishment I can only stand in awe of.
I'm currently an Assistant Scout Master for my local troop. I've only been directly...
"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
May 22, 2009 at 11:14 am
Steve Jones - Editor (5/22/2009)
Grant Fritchey (5/22/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
May 22, 2009 at 10:22 am
Now I'm second guessing what we're doing. If we're storing files directly in the DB, I'd expect it to be fairly large since we've got a pretty extensive Sharepoint installation,...
"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
May 22, 2009 at 8:50 am
I suspect it's the temp table in the query, but you know what, instead of both of us guess, run the query with a Profiler trace going and look 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
May 22, 2009 at 7:36 am
Have you looked at the execution plans? It's possible it's doing lots of scans and you're seeing contention. Have you tried running a blocking monitor (do a search in 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
May 22, 2009 at 6:12 am
Really? I'm sorry if I put out bad info. Maybe it's a setting during the install because we've been dealing with file systems seperate from the data store for 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
May 22, 2009 at 6:04 am
mverma4you (5/21/2009)
check this for automation
Before I'd go in that direction, I'd look into Powershell. It's going to work as well or better for minor bits of automation, especially within 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
May 22, 2009 at 6:00 am
No one is going to believe this, but a friend of mine & I were very minor characters in one of the Destroyer novels. We were introduced and killed within...
"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
May 22, 2009 at 5:54 am
Jack Corbett (5/21/2009)
GilaMonster (5/21/2009)
Oh yay. 🙁Another email accusing me of personal attacks and damaging someone's public image by 'misleading' people about his statements.
Sometimes I wonder why I bother.....
That's always fun....
"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
May 21, 2009 at 11:27 am
GilaMonster (5/21/2009)
Lynn Pettis (5/21/2009)
Are we talking about our window washer friend here?
No. It's someone who answers questions, not asks. (no one here, obviously)
Steve: Apologies in advance if this...
"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
May 21, 2009 at 11:25 am
Lynn Pettis (5/21/2009)
Would anyone mind if I asked him how he got this job if he can't even figure out how to read error messages and complete simple tasks?
Actually, 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
May 21, 2009 at 8:18 am
Viewing 15 posts - 17,386 through 17,400 (of 22,219 total)