An alternative to CHECK constraints are Foreign Keys referencing lookup tables. These are useful when you need to validate that a value in a column is within a set and...

You can have SQL server listen on a specific IP, one that is bound to the NIC card you want to accept the traffic. You set the IP and Port...

You could make your own. If you run this against any instance in your environment it will return an XML document that you can then save as a file for...

Michael Valentine Jones (9/26/2012)

---

I am trying to imagine a real world situation where IF/ELSE nested so deeply would be the way to go, instead of some other logical construct.

You should...

No problem. These dang written words. I thought for sure you had it after this comment:

As I have been trying to say (unsuccesfully) it all depends when the LS broke...

paruchuri4 (9/26/2012)

---

I am not considering about space but some databases are generating 0Kb size when they are taking backup for that purpose i need to know the size, if the...

Tara-1044200 (9/26/2012)

---

How can i make sure any login on the server can view only the database that they have access to.

I did remove "view any database" permissions at the server...

Yes, and it takes years to get to the bottom of it. Oh yeah, and Microsoft...

Jai-SQL DBA (9/26/2012)

---

Hi,

I want to understand the Logshipping reestablishment Scenerio After a Failover.Below Mentioned are the details of the Environment for the Better Understanding.

Server A: Primary Server

Server B:...

One other note. If you're compressing your backups then all estimates will be off because compression rates are data-dependent. In round numbers though I see about a 90% compression rate...

It's not an exact science but it should give you an idea. Why are you worried about the diff between a 1MB backup and 10MB space used? if you're that...

Here is a good primer to set you in the right direction asking the important questions:

Designing a Recovery Strategy for StackOverflow (December 16, 2009) by Brent Ozar[/url]

Have you explored Change Tracking?

Change Tracking Overview

Heh, that looks nicer. I'll have to try it out. Maybe I'll update my toolkit-script. Thanks.

Jeff Moden (9/25/2012)

---

What I'd like to know is.... why does someone need to know what size the backup is? SQL Server figures that out and if there's not enough...