Viewing 15 posts - 17,371 through 17,385 (of 22,206 total)
RBarryYoung (5/22/2009)
Grant Fritchey (5/22/2009)
May 23, 2009 at 2:13 pm
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...
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...
May 22, 2009 at 11:26 am
Yep, in the Navy on Subs. Hated it, but I'm glad I did it.
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...
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...
May 22, 2009 at 11:14 am
Steve Jones - Editor (5/22/2009)
Grant Fritchey (5/22/2009)
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,...
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...
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...
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...
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...
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...
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....
May 21, 2009 at 11:27 am
Viewing 15 posts - 17,371 through 17,385 (of 22,206 total)