Forum Replies Created
Viewing 15 posts - 36,151 through 36,165 (of 39,720 total)
-
RE: Concurrent restore
Do you mean you want to restore the same database to multiple servers at the same time?
Steve Jones
-
RE: Some questions not relevant
Tend to agree, but these are things that MS asks, so it makes some sense.
Steve Jones
-
RE: Scheduling DTS package
If htere is any interactive section, like a dialog box, it will hang. Run it interactively and be sure there is no dialog that appears.
Steve Jones
-
RE: VBScript command-line performance question
could be logs. Have you tried committing in smaller batches? Not one transaction. Also, are there triggers?
Steve Jones
-
RE: DBA Certification Question
And congrats!!!!!!!
Don't forget to update your resume.
Steve Jones
-
RE: DBA Certification Question
They track that (at least they did for my MCSE) and will send you your cert pretty quickly.
Steve Jones
-
RE: Trigger on Sysxlogins/syslogins table
Also, if I remember Karen Delaney's talk at PASS correctly, triggers are not guarenteed to fire on system tables.
Steve Jones
-
RE: Is there a way to tell who dropped a table?
As far as I know, Log Explorer is the only retroactive way to do this.
Steve Jones
-
RE: Change licensing mode
I think you must install again, but that's not too dificult a process, just time consuming.
Steve Jones
-
RE: Current Activity/Process Info sorting
This data is mostly from sysprocesses with joins to syslogins, etc.
You could get it from QA and then sort it.
Steve Jones
-
RE: Search String on HomePage
-
RE: How long would a backup take?
Two words: SQL Litespeed.
http://www.sqlservercentral.com/columnists/sjones/sqllitespeedlightningfastbackups.asp
http://www.sqllitespeed.com/slsdefault.asp
Is the db 30GB or the backup file? no that it matters, neither should take 15 hours. If the DBAs need some help, sjones@sqlservercentral.com, US$100/hour, 4 hour...
-
RE: Dynamic Views
Personally I'd write multiple views to cover the possibilities. How often would they change? If it's not that often (you have to judge that), I'd then just hit the right...
Viewing 15 posts - 36,151 through 36,165 (of 39,720 total)