Viewing 15 posts - 1,636 through 1,650 (of 6,216 total)
Doesnt seem to be linear. Rather than trust what you hear, why not put together a simple test? Test with 1000, 10k, 100k, 1m, 10mil rows, run a query. Server...
September 9, 2003 at 5:13 am
Why wouldnt you just use the upgrade wizard? The 7 to 2k migration is one of the easier ones you'll do.
Andy
September 9, 2003 at 5:05 am
You can monitor it, I just typically override the percentage with fixed growth amount for large db's. Users shouldnt notice the time it takes to do a smaller grow and...
September 9, 2003 at 5:03 am
Have you considered something CD/DVD/VHS based? Probably cheaper than traveling if you cant find anything close.
Andy
September 8, 2003 at 1:04 pm
You do have to be careful with heaps to make sure the space gets reclaimed. Had problems a couple years ago, putting a clustered index solved it.
Andy
September 8, 2003 at 1:03 pm
Not a simple problem. I basically try to gate all access through stored procs and I typically build the apps to use a sql login for the connection (hidden from...
September 8, 2003 at 1:01 pm
Lock seems likely, easy enough to test - just open a table in EM, holds a lock. Why are you running the snapshot every night?
Andy
September 8, 2003 at 1:00 pm
Sound bad. I don't use the multi server thing, dont know. Wouldn't you be trying to quickly get the master running again? I guess you could defect all the targets,...
September 8, 2003 at 12:56 pm
Nope, best you can do is limit what they can do with the tool (which happens automatically based on whatever login they use).
Andy
September 8, 2003 at 8:16 am
I'll have to check. I need to fix another issue on the home page, might be related.
RSS, I've tried a couple, they didnt work from work, I think due to...
September 8, 2003 at 7:16 am
What I do is give them a way to insert a row in a table, then I scan the table every x minutes to see which to db's to process....
September 8, 2003 at 7:14 am
They did us a demo for us (me, Steve, Brian) at Pass, looked decent, very fast failover. It uses replication which adds some complexity there, but of course you dont...
September 8, 2003 at 7:13 am
I'd use replication over triggers if possible, why write code when replication will manage it for you (and its been tested).
That said, I'd consider another conversation with whoever said no...
September 8, 2003 at 4:20 am
September 8, 2003 at 4:14 am
The easiest way to rebuild the indexes and update stats at the same time is to run a maintenance job via the wizard. I agree with the above posting, if...
September 8, 2003 at 4:12 am
Viewing 15 posts - 1,636 through 1,650 (of 6,216 total)