I think that green is an appropriate color for the US

Thanks for the note.

I edited this to reflect SSMS, which is what I think you mean. It's Management Studio. Note that this isn't an instance. SSMS on your machine does...

That's in the "them" section of the world map, isn't it?

this says no: http://msdn.microsoft.com/en-us/library/ms143393.aspx

You can compare integer and varchar in some cases. An implicit conversion may occur, but it...

Chances are if you have your SQL Server allowing remote connections, it is exposed.

In the firewall, you want to allow connections to 1433 TCP on your SQL Server, ONLY from...

jay holovacs (1/12/2011)

---

GSquared (1/12/2011)

---

...Keep your data in two places if it matters. Three if it's important. Four or more if it's critical. E.g.: RAID-10 is 2 places,...

CriticalStatus (1/12/2011)

---

Hey Steve

Interesting thought. Made me think about how we would handle availability within our control. Another thought popped as I finished reading your article.

Can you replicate between...

I have corrected the question to note that indexes on computed columns will not be used.

Because of this, I have also awarded back points to everyone that has answered this...

What edition of SQL Server is this? If it's not Enterprise, you can't restore Primary and then get people working while you restore other files.

I have heard this advice before,...

Apologies. I was unclear.

That's good to know, but more about what connects to what, and for what purpose? How does this application work?

Are you thinking this is a series...

Alvin Ramard (1/12/2011)

---

Don't...

Make sure you dig in and understand what happens.

Also realize that when the CIO says "shrink", he doesn't necessarily mean "run dbcc shrinkfile". What he means could be "make sure...

You have to have primary available, and then you can restore another filegroup.

So if you have your db at 5:00pm. Some things in Primary, some in Reporting. If you have...

If it is subsequent actions, you would schedule a few log backups to clean it up. The reindex will be one large logged operation.