sqldba_newbie (1/29/2013)

---

GilaMonster (1/29/2013)

---

If you want all queries to only use one processor, why not pull the other 23 out? That's essentially what you've done by setting maxdop to 1. It...

jcrawf02 (1/29/2013)

---

I've been farming for post count, and I gotta say, it's really confusing because I can't tell where you're supposed to go cash in all these points for better...

Not enough information to draw any conclusions. What does the backup app log say? Anything useful in the SQL error log?

wolfkillj (1/29/2013)

---

GilaMonster (1/29/2013)

---

I went through all of the ones I saw yesterday, his post is not relevant, the over-sized plan cache problem on SQL 2005 RTM and SP1 is not...

https://www.simple-talk.com/sql/database-administration/gail-shaws-sql-server-howlers/

ChrisM@Work (1/29/2013)

---

How many rows in the table? How many rows are you returning? If you are returning more than say 25%* of the rows in the table, SQL Server may...

DominantDBA (1/29/2013)

---

We are using AlwaysOn to a DR site so we do have High Availability

The 2 hour restore is if we lose both it has to be available within 2...

MyDoggieJessie (1/29/2013)

---

Sorry to...

I went through all of the ones I saw yesterday, his post is not relevant, the over-sized plan cache problem on SQL 2005 RTM and SP1 is not going to...

Mirroring is a high-availability feature that can additionally be leveraged for reporting. It is not primarily a reporting solution. As a HA feature, the mirror is an exact, identical copy...

Log shipping, database mirroring?

Why not?

sp_updatestats does sampled updates. That may not be good enough.

Why are you partitioning? What's the goal there?

Ratheesh.K.Nair (1/29/2013)

---

DBCC CHECKDB WITH TABLOCK GAVE BELOW ERROR

---------------------------------------------------------------

Msg 5030, Level 16, State 12, Line 1

The database could not be exclusively locked to perform the operation.

Msg 7926, Level 16, State 1,...