Viewing 15 posts - 46 through 60 (of 136 total)
Brandie Tarvin (4/30/2010)
But you will have a LOT of code & stuff to upgrade, so get ready to work hard.
I hope not. The only real reason we're upgrading is...
May 3, 2010 at 1:26 pm
Never mind - in the meeting the boss decided to update to SQL 2008.
April 29, 2010 at 2:29 pm
OK now I have a better idea of what you meant. The depth of the tree is obviously very important.
You referred to the downsides of heaps, and I wasn't sure...
March 11, 2010 at 3:23 pm
Yes I read part 3, and covering indexes are a good thing for us to think about.
But it's hard for me to imagine how traversing a (clustered) B-tree in a...
March 11, 2010 at 11:25 am
GilaMonster (3/11/2010)
if it's a vendor app that you can't change, then that's pretty much that, you can't change it.
Well, we can't change the width or contents of that field, but...
March 11, 2010 at 9:28 am
I'd like an opinion. Part 2 of the article (which I'm just now reading) says a clustered index should be narrow, unique, unchanging, and ever-increasing. I have tables (some quite...
March 10, 2010 at 11:06 am
OK, I just looked back at your original post and saw "Edit: Clarified that I was talking about the hypothetical case of delete/truncate without logging at all." So now I...
October 7, 2009 at 2:29 pm
OK, so from that aspect it looks like DROP is safer (and faster) than TRUNCATE, especially for very large tables. (And being faster makes it safer still.)
Worst-case scenario (in either...
October 7, 2009 at 8:49 am
Steve Jones - Editor (10/5/2009)
October 5, 2009 at 3:43 pm
We also have a situation where periodically we are need to bulk-delete an entire table (about 3 million records) and bulk-reload it from a file we receive from elsewhere. At...
October 5, 2009 at 11:43 am
Well, I'm out of any more time to spend on this. We're going to have to use the IP address workaround for the time being, unless/until a true solution comes...
October 2, 2009 at 11:04 am
I did try that once before, but long enough ago that I forgot the results. I figured putting that account in the target's Administrators group should be enough (unless Windows...
September 30, 2009 at 7:33 am
Well, I can try that, but I can already create, edit, and delete files on the target machine while logged in to the source machine. Everything I try works, except...
September 30, 2009 at 7:01 am
OK, now that I'm back from vacation and gotten past a few server emergencies, I can get back to this thread.
Yes, as far as I can tell, full permissions are...
September 28, 2009 at 1:46 pm
Although I'm on vacation this week, I connected to my office PC and looked for the option you describe (I had never heard of it before). I did find how...
September 14, 2009 at 8:45 pm
Viewing 15 posts - 46 through 60 (of 136 total)