Viewing 15 posts - 43,846 through 43,860 (of 59,063 total)
Nah... that should do it. Just make sure that "TextData" is one of the columns returned so you can see the actual offending SQL. Since you're not interested...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 5, 2009 at 6:54 pm
m.berggren (5/5/2009)
Jeff:I think youré right. I think it has something to with clustered index on the table.
// Magnus
It absolutely does... UPDATE will update the data in the order of the...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 5, 2009 at 6:04 pm
Thanks for the info folks. Learned something new which is always a pleasure. I was just going for the "old doctor" trick. You know the one... go...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 5, 2009 at 5:59 pm
ifila (5/5/2009)
I now have to find a parsing solution.Thanks
The numbers I quoted included parsing. Lookup BULK INSERT in Books Online... you'll see. 🙂
--Jeff Moden
Change is inevitable... Change for the better is not.
May 5, 2009 at 5:52 pm
Very interesting link, Jason. Sounds like my installation is pretty much hosed and there's nothing I can do about it because they moved my servers to a different State...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 5, 2009 at 5:47 pm
Grant Fritchey (5/5/2009)
RBarryYoung (5/5/2009)
Alvin Ramard (5/5/2009)
David Burrows (5/5/2009)
Then you have those that would bite the hand that is trying to feed them.
Lucky for the OP that is was not Jeff,...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 5, 2009 at 5:18 pm
Grant Fritchey (5/5/2009)
RBarryYoung (5/5/2009)
Alvin Ramard (5/5/2009)
David Burrows (5/5/2009)
Then you have those that would bite the hand that is trying to feed them.
Lucky for the OP that is was not Jeff,...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 5, 2009 at 5:10 pm
Oh... and my definition of "Performance Tuning" is one of two things... either writing code to let the optimizer do its job, or rewriting someone else's code to let the...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 4, 2009 at 11:04 pm
The basic idea is to allow the optimizer to do it's job using properly written set based code. You do that by avoiding cursors and while loops in 99.99%...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 4, 2009 at 11:02 pm
GilaMonster (5/4/2009)
No, it is covering and the optimiser should, theoretically, be picking it. Might be a bug, might be something subtle that we've missed.
I'm not sure how creating a filtered...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 4, 2009 at 10:23 pm
I'd like to know why anyone cares? Either the DBA is doing (or can do) a good job or not. When I conduct an interview for a potential...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 4, 2009 at 10:07 pm
Barkingdog (5/4/2009)
I agree with what you wrote:
>>
You need to reset TempDB to a reasonable size and setup a trace for TempDB growth to help isolate the code that's causing this...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 4, 2009 at 9:42 pm
Clark Bones (5/4/2009)
I have a simple csv-file that I want to import into a table. I have some code and the file is imported, but the columns in the...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 4, 2009 at 8:42 pm
Drop the following into the URL field of BOL for how to implement it. It has nothing to do with the app...
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/035b3297-6f89-4043-9ba0-76108781b827.htm
--Jeff Moden
Change is inevitable... Change for the better is not.
May 4, 2009 at 8:32 pm
Barkingdog (5/4/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
May 4, 2009 at 8:28 pm
Viewing 15 posts - 43,846 through 43,860 (of 59,063 total)