Viewing 15 posts - 45,961 through 45,975 (of 59,062 total)
Hmmmm... is there a way for you to turn of the hyperthreading long enough to run another MAXDOP 1 test? I've got a feeling and would like to find...
January 11, 2009 at 9:18 am
Was it ever fast? If so, what changed? If not, then it's probably the code.
January 10, 2009 at 11:46 pm
There are way too many variations of how a name may be entered to write some "simple" SQL for this. Instead of trying to reinvent the wheel, why don't...
January 10, 2009 at 11:38 pm
majorbloodnock (1/8/2009)
I can just see the new posts being typed right now
"Dear SSC
Plz tell me what makes a good DBA and what else I need to know to become...
January 10, 2009 at 11:35 pm
Yogi Berra had a saying... "When you come to a fork in the road, take it!" In other words, given a choice, take all choices.
A partitioned table would work...
January 10, 2009 at 11:26 pm
Heh... nah... I just hate GUI's... too limiting... can only do what they were designed to do using only the ways they were designed to do it... unless you write...
January 10, 2009 at 11:02 pm
So, gvsriramakrishna... any feedback on this?
January 10, 2009 at 10:26 pm
Heh... of course, the simplest of all the solutions would be to do it all in T-SQL and perhaps a touch of BCP... SSIS not required. 😉
January 10, 2009 at 10:15 pm
:blush: Thanks, Dugi. Like I've said before and in the article, I didn't invent it... I just use the heck out of it. 😛
January 10, 2009 at 7:56 pm
Arun (1/10/2009)
BTW, if I upgrade to SP4 will this problem get resolved?
What problem? You've not yet identified what the problem is. And, upgrading to SP4 may be exactly...
January 10, 2009 at 7:50 pm
Lynn Pettis (1/10/2009)
January 10, 2009 at 5:09 pm
Lynn Pettis (1/10/2009)
It also could be due to disk fragmentation.
Ordinarily, I'd say that's a definite possibility... but not this time. I know for a fact that my...
January 10, 2009 at 3:35 pm
Lynn Pettis (1/10/2009)
GilaMonster (1/10/2009)
Lynn Pettis (1/10/2009)
January 10, 2009 at 3:27 pm
Maxim Picard (1/10/2009)
There are a few others on this site and on the web. Use 'sp_oa%' as your search pattern since we are looking for sp_OACreate, etc.
Oh, be careful... ...
January 10, 2009 at 8:48 am
Lynn, your home system absolutely smokes on this code... what does your home system consist of... I'm thinking that brand names and model numbers would also weigh in heavily here...
January 10, 2009 at 8:42 am
Viewing 15 posts - 45,961 through 45,975 (of 59,062 total)