opc.three (3/15/2012)

---

Some of the queries...

SQLKnowItAll (3/15/2012)

---

Lowell (3/15/2012)

---

duplicate post.

no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.

the "Recent Posts" link shows us everything.

continue the...

SSMS is distributed with SQL Server, no extra cost as long as each user having it installed is licensed (which has to be true of tools as well). It...

Lowell (3/15/2012)

---

duplicate post.

no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.

the "Recent Posts" link shows us everything.

continue the thread...

opc.three (3/15/2012)

---

Here's a little cheat for you using the Query Designer in SSMS 2008R2.

1. Restore a copy of your database into a DEV environment.

2. Change the database to 80 compatibility...

Could you post the DDL for the table, the indexes, and the procedure/code being executed please.

You may want to do some reading in Books Online, specifically regarding Full Test Indexing.

Without anything else from you, don't expect much else than this.

http://blogs.msdn.com/b/chrissk/archive/2008/06/19/i-o-requests-taking-longer-than-15-seconds-to-complete-on-file.aspx

Here are the two URLs from above so that they are hot links:

http://www.sqlskills.com/BLOGS/PAUL/post/CHECKDB-From-Every-Angle-Can-CHECKDB-repair-everything.aspx

http://www.sqlskills.com/BLOGS/PAUL/post/Corruption-bug-that-people-are-hitting-Msg-8914-PFS-free-space.aspx

herladygeekedness (3/15/2012)

---

When you're on a job interview, you're interviewing them as much as they're interviewing you, though it may not always feel like it, especially in a bad job market....

Just one possibility is a lack of worker threads. Don't really have enough information to really provide you more than guesses unfortunately.

Why not use a table constraint where SellingPrice > CostPrice?

GabyYYZ (3/15/2012)

---

Is it too much to ask that a DBA candidate, who says he has 10 years experience with SQL Server, know what a primary key is, or know the...

Have you even bothered to look this up in Books Online? The @ is the first character of a local variable or parameter.

Maybe I missed it but I can't seem to find a complete declaration of the table and all indexes, could post (or report) the DDL for the table and all...