Steve Jones - SSC Editor (7/20/2012)

---

I'm sure that's a typo. Probably the author is used to typing raid 5 and copy writers didn't realize. RAID is mentioned a number of...

Did anyone notice that they mentioned a Raid 5 array and described RAID 10 or 1+0?

What is wrong with fact checking articles these days? I checked the server specs online...

rVadim (7/19/2012)

---

What is the difference?

.......

What two things? What...

vk-kirov (7/19/2012)

---

Weird logic. I don't understand how the answer could be "No", while in fact the database can be restored from any of the snapshots (although not with a single...

😛 Revert from a snapshot and Database Restore from a snapshot are two differant things covered by two differant BOL articles. 😛

Restore (includes how to restore from ANY snapshot)

I Now...

It would depend on the recomendations of performance tuner or missing indexes dmv.

Poor query performance caused by extra seeks are historicly resolved by better indexing, primary key...

Nice straight forward easy question. Not certain why adding the server version would cause the answer to be any less clear. Second sentance in BOL for Truncate is;

TRUNCATE...

What happens when you index?

Is there a Connect Article that list this issue?

GilaMonster (6/25/2012)

---

CheckDB only runs when someone...

Gail I understand what what your are saying and agree with your statement.

I do not think clear enough with my question.

Do you have any information for those using SQL 2005...

Agreed, you will have to test against your reports or at least thier SQL. Taking the report SQL and executing it in SQL Performance tunner should help with that....

GilaMonster (6/25/2012)

---

sql.AB (6/24/2012)

---

What this option does is when the last user disconnect, database shutdown and when new user try to login, database reopens. Every time it opens it will...

Great question. I knew the answer because of work with our TFS server.

http://msdn.microsoft.com/en-us/library/ms253144(v=VS.90).aspx

It some things you have to look at event logs of a TFS SQL Server to find.

Are you looking for confirmation that the error is telling you what you need to do?

It is. Once a subscription is marked inactive it needs a new snapshot, etc... to...