Viewing 15 posts - 38,731 through 38,745 (of 39,456 total)
December 5, 2001 at 12:55 pm
I think VB.NET is a good step forward, but personally I'll lean more towards C#. Always loved C.
Steve Jones
December 5, 2001 at 12:53 pm
caveat DBA. If you have no pwd, then MS doesn't want to hear it and I agree in this case.
Steve Jones
December 5, 2001 at 12:50 pm
I used it with a couple small lookup tables. On our server, it didn't really provide any noticable difference.
Steve Jones
December 5, 2001 at 11:53 am
I spoke with a few DBAs that had an array and they loved it. It performed beautifully and notified them when disks failed. It was the most painless array and...
December 5, 2001 at 11:41 am
Note You cannot implement log shipping between two instances of SQL Server 2000 if one part of the log shipping pair is not an Enterprise Edition installation. Log shipping can...
December 5, 2001 at 11:39 am
the trigger always fires before the update is complete. it is part of the transaction.
In the trigger, work with the inserted and deleted tables to determine the values you need....
December 5, 2001 at 11:36 am
December 5, 2001 at 11:32 am
Not that I know of. I've loaded a couple mil, but never 7. I'll generate some data and try it tomorrow.
Steve Jones
December 4, 2001 at 10:34 pm
I'll tkae a look tomorrow, but my guess is that there is a bug inthe parser for this insertr operatrion. sorry, tired.
Steve Jones
December 4, 2001 at 10:33 pm
SQL 2000 will use the lowest lock it thinks it needs. For a single row insert, this will be a row lock. For multi rows, it might be a page,...
December 4, 2001 at 10:32 pm
You'd restore the Sun full, Wed diff and wed log up to the time when the transaction occurred. Everything from that point until Thur would have to be re-run.
BTW, the...
December 4, 2001 at 10:31 pm
good comments, but I'd still say that a good dba will not depend on the gui. he might use it, but will not depend on it.
Steve Jones
December 4, 2001 at 5:23 pm
You won't get much in error trapping from using xp_cmdshell. If you need the trap, use FSO.
Steve Jones
December 4, 2001 at 5:20 pm
No XP server, there is .NET, however, in Beta 3 now. I'd use W2K. Can't even buy NT now.
Steve Jones
December 4, 2001 at 5:18 pm
Viewing 15 posts - 38,731 through 38,745 (of 39,456 total)