Viewing 15 posts - 36,901 through 36,915 (of 39,818 total)
If you are tight on disk space, what about a remove disk backup? Preferred to tapes.
Also, look at SQL Litespeed (www.sqllitespeed.com). It compresses the backups and runs faster than...
November 26, 2002 at 1:35 pm
What do you mean? Limited set of data?
It really depends. There are some generators for data, but they tend to be a little pricey and they work for certain scenarios...
November 26, 2002 at 1:33 pm
Can they just take a differential backup? Replication will work, but that may be overkill.
If it's a few tables, you could just create an audit table and use triggers, then...
November 26, 2002 at 1:22 pm
What does the insert trigger do? Does it update the table? Might cause a 2nd trigger to fire there.
Steve Jones
November 25, 2002 at 2:54 pm
No. I asked this question of MS last year for the same reasons. You must license each proc.
Licensing is per physical CPU, however, not logical. The new hyperthreading CPUs appears...
November 25, 2002 at 10:29 am
select * is built at view compile time. You should really specify the columns so you know to add them to the view (with Alter View).
Steve Jones
November 25, 2002 at 10:06 am
November 25, 2002 at 9:45 am
In sysindexes, a row will be added for the table with indid > 0. A 1 is clustered, other numbers are nonclustered.
Steve Jones
November 25, 2002 at 9:36 am
Very very true. Be sure that if you move servers, the target server issue may crop up as well.
See my kill that target article for details.
Steve Jones
November 21, 2002 at 1:51 pm
Shouldn't hurt to reinstall SP3 and might help.
Steve Jones
November 21, 2002 at 1:49 pm
connect to master, not the db to be restored.
Steve Jones
November 20, 2002 at 6:48 pm
Look at Brian's book. Basically, you need to be monitoring and baselining over time. Brian has ways to make this easy.
Steve Jones
November 20, 2002 at 6:41 pm
Viewing 15 posts - 36,901 through 36,915 (of 39,818 total)