Do you have a clean backup (from before the corruption) and an unbroken chain of log backups?

Since it's a reporting DB, can it be recreated from another source?

Is that the...

Jeff Moden (2/3/2014)

---

This guy isn't the only person of such ilk when it comes to indexes. I also see that Brent Ozar published an article about what a waste...

Grant Fritchey (2/3/2014)

---

Please, please, please, no piling on, but I'm curious what you guys think about this: Unreasonable Defaults. I think most of the fundamental info is fine. I'm just......

That kind of query generally doesn't perform well. To give you an idea, I had a query the other week that was written to do just that and took 3...

Why are you explicitly adding an unknown value, rather than allowing NULL to indicate unknown?

No, they won't. Most aren't technical and won't have any idea of the implications. now,...

If you have nolock...

BWFC (2/3/2014)

---

What transaction level should I be setting it to? I assume, to make sure it's clean data I should be using read committed. I know it's not...

colin Robinson-345240 (2/3/2014)

---

I imagine using bulk logged on the subscription replica is a replication throughput issue,

all the insert update action from the replication stored procs will be getting logged in...

Replication doesn't require any recovery model from any of its databases (publisher, distributer, subscriber). It's technically in simple recovery anyway since the log is truncated without another backup running.

Where is that error coming from? Can you post the code?

No, the plan cache is...

Dashs are not valid characters in object names, so if you do use...

Could you give a little more info as...

The...