@Brandie Tarvin

Yes.

It's something you'll have to get used to, because it comes in handy, but may also bite you in the back because you forgot you were having a...

Did you have a look at http://www.sqlservercentral.com/Forums/FindPost1008735.aspx

It contains nice feedback info from MS.

Maybe Paul Randal has more info on that at http://www.sqlskills.com/blogs/paul/post/checkdb-from-every-angle-emergency-mode-repair-the-very-very-last-resort.aspx

Thank you for sharing !

Many people didn't find this setting.:ermm:

With sql2008 that option is included with the right-click on the grid. :w00t:

You should be able to find who/what caused your dblog to grow if you have your default trace active.

ref: "Did we have recent autogrow?" by Tibor Karaszi

http://sqlblog.com/blogs/tibor_karaszi/archive/2008/06/19/did-we-have-recent-autogrow.aspx

If that doesn't get...

Need it to be said that from an OLTP database perspective only R2 doesn't have that much an advantage over the original.

We are skipping the original because of report server...

Thank you for the great feedback.

Since it seems so dificult to alter the sa password ....

this must be another reason NOT to use sa !

If you need sysadmin auth, which 99.99999% of the apps will...

AFAIK there is no @@connectionIPaddress, but you can use this DMV to get this info

Select client_net_address

from sys.dm_exec_connections

where session_id = @@spid

A regular user (=non sysadmin) by default only gets to...

If I'm correct, datadude (visual studio for DBA) has that functionality, in case you're searching for other means than sql itself.

HTH.

Most of us still fall in that trap every once in a while.;-)

Jeffrey Williams-493691 (10/24/2010)

No, I don't think a full backup will be any smaller because of backing...

- Why don't you just directly 7zip your existing full backup file(s) ?

If you precede your fullbackup with a logbackup, wouldn't your fullbackup be smaller ?

- using 7zip, you can...

the columns of both queries are not in the same order.

Keep in mind SQLserver doesn't map your columns by name but by ordinal position.

That is the ultimate, one and only valid reason to...