Viewing 15 posts - 2,461 through 2,475 (of 6,216 total)
I think its all still under NDA. Will be a while before we see a public beta I think.
Andy
March 3, 2003 at 12:05 pm
March 3, 2003 at 11:05 am
Not much to work with. I'd put the data on one, the log files on the other. Without RAID you're living on the edge, definitely should do frequent backups and...
March 3, 2003 at 7:49 am
Have you tried all the fixes it suggests and still having the problem?
Andy
March 3, 2003 at 5:48 am
I think you'll have to detach the new db and temporarily rename the files.
Andy
February 28, 2003 at 7:40 am
Easiest is to copy the mdf (and ldf if you have it) to the new machine, then attach. Then you can either leave the data there and access as you...
February 27, 2003 at 8:41 pm
Pkey = primary key, sorry. Any time you make a col/row wider, it will have some impact on performance. If your uniqueidentifier is the clustered key, then it will have...
February 27, 2003 at 1:49 pm
Im in the minority, but I like uniqueidentifiers. One big reason is that I can generate the pkey on the client, not have to do an insert AND return the...
February 27, 2003 at 1:24 pm
Not to argue (much), but I dont think its always feasible to make your code self explaining. To some degree a good solid name for the proc is the best...
February 27, 2003 at 1:15 pm
I think SMS will work, it does for the standard install.
Andy
February 27, 2003 at 1:11 pm
If you're running that frequently, maybe a better solution would be to use a loop with a delay built in? Or build the job as a service that runs continuously....
February 27, 2003 at 12:47 pm
Thanks for the follow up, easy thing to overlook.
Andy
February 27, 2003 at 12:40 pm
Rarely. I've had zero problems with idents. Doesnt mean it cant happen, but I think in practice its very rare. Suggested in this case just to be sure!
Andy
February 27, 2003 at 12:39 pm
Interesting thread. Lets know throw too many rocks though. I agree that I don't think it can be done to the point of unbreakable. That said, perhaps there are situations...
February 27, 2003 at 9:09 am
I'd double check the fragmentation of the db. More fragmentation will make the backup take longer as it follows the chains. Might also check that the disk itself is defragmented,...
February 27, 2003 at 9:04 am
Viewing 15 posts - 2,461 through 2,475 (of 6,216 total)