Viewing 15 posts - 166 through 180 (of 496 total)
Toreador (3/16/2012)
jeff.mason (3/16/2012)
So if you look at this strictly as a syntax issue, the question is sound.
A fair point. Depends whether you thought (rightly) that the question was about forgetting...
March 16, 2012 at 8:55 am
For those who say that an error is built into the code because it will fill up the disk, which in the real world is true, step back a second...
March 16, 2012 at 7:44 am
Hugo Kornelis (3/7/2012)
March 7, 2012 at 7:23 am
Rowles (1/31/2012)
"Can a compressed backup and sn uncompressed backup of a particular database co-exist in a single media set? "What is an "sn uncompressed backup"?
A typo. Read "an uncompressed...
January 31, 2012 at 10:10 am
Yep, the question says to limit I/O as answer when clearly (even in the explanation) you want to limit CPU. Should be A and D.
January 22, 2012 at 9:50 am
tofan.nayak (1/18/2012)
Trigger always fire when SSIS load or insert in SQl Server Database label or table base triggermore.....
Not if you are doing bulk load. If you are doing bulk...
January 19, 2012 at 7:42 am
BarbW (1/18/2012)
Server-scoped DDL triggers are...
January 18, 2012 at 8:45 am
SQL Kiwi (1/11/2012)
L' Eomot Inversé (1/11/2012)
Nice and simple.
I see a lot of people saying this, but either my product knowledge is significantly below average or we're doing something differently. ...
January 11, 2012 at 7:36 am
"the 'local_net_address' parameter is used to get the IP address of the client."
Yet from books online:
"Returns the IP address on the server that this connection targeted. Available only for connections...
January 7, 2012 at 5:31 pm
Steve Jones - SSC Editor (1/5/2012)
jeff.mason (1/5/2012)
January 5, 2012 at 11:13 am
That brings up an interesting question -- how many DBAs have their backups go straight to tape? In my professional career I have never had a backup infrastructure where...
January 5, 2012 at 9:23 am
Exactly. I agree that this limitation really makes no sense. There's no reason why two backups can't go to the same file, one compressed, one not compressed, and...
January 5, 2012 at 7:22 am
And to add to that, the only time that the LSN resets is when you change recovery mode. If you leave it in FULL mode, the LSN will be...
January 4, 2012 at 7:26 am
I find the workload typically is easier since I can schedule tran logs without any reference to full backups. It would take longer to restore, maybe, to a certain...
December 30, 2011 at 12:16 pm
But at least we aren't arguing whether turkey is or is not more "Christmasy" than reindeer or some such thing. Pretty much everyone knows drunkenness is a standard part...
December 30, 2011 at 12:10 pm
Viewing 15 posts - 166 through 180 (of 496 total)