The covering index you listed there is not being used, because it's not efficient. The query filters on EW.EmployeeID AND EW.Overwritten, while those are in the index, they're not the...

sqldba_newbie (3/19/2013)

---

opc.three (3/19/2013)

---

Cores, or threads? What exactly are you seeing that is making you think...

sqldba_newbie (3/19/2013)

---

So if i look at the cost from estimated execution plan, lets say cost of a query from estimated exec plan is 40. Does that mean my query will...

Never use task manager to monitor SQL Server's memory, it displays incorrect values in some cases. Also be aware that, prior to SQL 2012, the max memory setting limited the...

Profiler or extended events work well.

Ok, so the effective MAXDOP for a query is then the minimum of the query hint value and resource governor value (if specified), otherwise the server maxdop setting.

clintonG (3/19/2013)

---

I don't know what's supposed to be so funny. How else could somebody lock down a Windows 7 client OS functioning as a "server" than to use Group...

There's a decent coverage at the start of chapter 6 in http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

The query hint overrides...

Right before the BEGIN TRANSACTION, put SET TRANSACTION ISOLATION LEVEL REPEATABLE READ, since you are writing the begin tran, you can write that too.

SET TRANSACTION ISOLATION LEVEL REPEATABLE READ before the begin tran.

Not sure what you're trying to do. A select by default takes shared locks, those locks are released as soon as the row is read (in the default isolation level...

That's not true. The...

No they're not.

A: I am guessing B as the answer as...

sqldba_newbie (3/18/2013)

---

At the server level i have CTP set to 20 and MAXDOP value set to 8. If i understand correctly , any query whose cost is more than 20...