Viewing 15 posts - 17,236 through 17,250 (of 19,564 total)
I think somebody just DBCC timewarped me. I lost 17 post points over night. (I was counting down to 5000, thus the reason for knowing.)
February 17, 2010 at 9:20 am
TECHBABU (2/16/2010)
step 3 Look the status column for lot of repetitious number two 2 , if they are more then you go ahead and try shrinking of log file.
A very...
February 17, 2010 at 12:22 am
Thanks Paul. Excellent question. I learned quite a bit about checksums for this question (most of it coming from your blog).
February 17, 2010 at 12:18 am
When the log file needs to grow, it will block transactions from completing until the log file has adequate space. The reason it will grow is due to inadequate...
February 16, 2010 at 11:53 pm
Paul White (2/16/2010)
CirquedeSQLeil (2/16/2010)
I want a Hippopotamus for ChristmasOnly a Hippopotamus will do...
This strikes me as very funny - but I'm not sure why. Am I missing a reference,...
February 16, 2010 at 11:23 pm
WayneS (2/16/2010)
Anybody interested in reviewing an article on the ROW_NUMBER() ranking function? It's in a .doc file. PM me if interested.
Sounds fun. You know my email address.
February 16, 2010 at 11:08 pm
Lynn Pettis (2/16/2010)
CirquedeSQLeil (2/16/2010)
Lynn Pettis (2/16/2010)
Kind of got a bit heated, didn't it.I think that is a bit understated.
Did you see that hippo I left for you outside your tent?
Sure...
February 16, 2010 at 11:07 pm
Paul White (2/16/2010)
Lynn Pettis (2/16/2010)
Kind of got a bit heated, didn't it.
Yes. I've just read every post in that thread, and the previous posts by 'GT' referenced by Gail...
February 16, 2010 at 11:05 pm
Lynn Pettis (2/16/2010)
Kind of got a bit heated, didn't it.
I think that is a bit understated.
Did you see that hippo I left for you outside your tent?
February 16, 2010 at 10:09 pm
Steve Jones - Editor (2/16/2010)
I want an dolphin to take me away from all this, ride the waves and chase the sun.
As long as a pork chop flinging hippo can...
February 16, 2010 at 10:08 pm
I still do not consider it a long amount of time to insert 1 record.
That said, I would still find a way to break up your data into batches. ...
February 16, 2010 at 10:06 pm
Anam Verma (2/16/2010)
How many indexes do you have?
There are total of 5 indexes on this table
- 1 clustered as primary key
- 3 non clustered created on foreign keys
- 1 non...
February 16, 2010 at 9:10 pm
Yes, yes it did. The thread got enough juice today for several months. 😀
February 16, 2010 at 9:08 pm
As Jeff mentions Indexes - it is a valid point that indexes will have an impact on length of time to insert records.
If i were inserting these records one at...
February 16, 2010 at 9:05 pm
Elliott W (2/16/2010)
CirquedeSQLeil (2/16/2010)
WayneS (2/16/2010)
CirquedeSQLeil (2/16/2010)
... I use one instance of SSIS 2008 to perform various tasks against all of my 2000, 2005 and 2008 databases...
Hey Jason, how about...
February 16, 2010 at 7:58 pm
Viewing 15 posts - 17,236 through 17,250 (of 19,564 total)