Are you seeing any particular wait type? (check sys.dm_exec_requests)

Is one of the logins sysadmin and the other not?

Do they both have the same default schema?

Which one are you running? What indexes are there on the Emp table?

I'd suggest move it to a larger drive. If it's filling up with a simple update and a temp table, then the drive it's on is probably too small.

How...

Is tempDB restricted in size? Is it on a drive that's full?

1976 (10/31/2008)

---

Hi,

If your parameters are optional, do not create dynamic sql, but construct WHERE clause this...

Depends. If they're pretending to be someone they're not...

Nandy (11/4/2008)

---

However I just have small doubt, every time I have to use default value or any other way where I can insert the values to GUID field in the...

Lynn Pettis (11/4/2008)

---

Don't simply truncate the transaction log. You will break your log chain, and won't be able to do a restore to a point in time. Also,...

SQL Server mostly uses unordered clustered index scans when NOLOCK is specified,

this can cause duplicate records to be returned when page splits occur while your query is scanning the index.

Using...

Grant Fritchey (11/3/2008)

---

I don't understand the question?

All you're doing with the -+- operators is simple math, a + adds an equivalent value and a - takes it away. +++@param is...

Not unless you want to do your own form of auto-increment column.

Why are the values of the identity column important?

Probably at least 8 hours. Depends if those 8 hours were all doing processing...

Is the deadlock happening frequently? If so, please enable traceflag 1222 (DBCC TRACEON (1222,-1) ). That will write a very detailed deadlock graph into the error log. Please post the...

Tony (11/3/2008)

---

So, can I disable ongoing maintenance on the non-clustered/non-unique indexes, keeping those indexes online? Those indexes would continue to be used by the production system to access the...

Have a look at these links. They should give you everything you need to study for and write the exams.

For SQL 2008:

http://www.microsoft.com/learning/mcp/mcts/sql/2008/default.mspx

http://www.microsoft.com/learning/mcp/mcitp/sql/2008/default.mspx

For SQL 2005:

http://www.microsoft.com/learning/mcp/mcts/sql/

http://www.microsoft.com/learning/mcp/mcitp/dbadmin/