What do the wait stats look like? What are the processes on the server waiting for? That'll help you determine the biggest pain points.

You have to start troubleshooting the system. First, are all users on all applications on all databases suffering, or only some? That help determine where to look. Have things been...

avinashily (2/18/2011)

---

Hi all,

i have a table with the following data types defined for the columns,

a nvarchar(50) not null,

nume numeric(18,0) not null,

time1 datetime null,

variab nvarchar(max) null,

abc text null,

numcha nchar(20) null,

can you...

I'll also add one to the list, hash tables and work tables created as part of execution plans.

I'll go Roy one step further and suggest that you have to approach the index hints with extreme caution, especially if it's adding a large list of INCLUDE columns.

It sounds...

I've found through a lot of testing that the use of ROW_NUMBER when returning more than a few rows has a tendency to degrade faster than using a TOP with...

mstjean (2/17/2011)

---

Hi Grant-- thanks for the quick reply. (I think you meant "Unfortunately your tests are NOT quite fair")

Point taken regarding indexing. Let me ask a smaller question: The query...

You're just noticing?

Unfortunately your tests are quite fair. You need to have an index on a column so that you see if the implicit conversion causes a problem or not. You had...

There must be duplicate data in Table1 or rows already exist in Table2.

I've put just about everything except the server configuration itself into source control. Yes, you can do this will all projecs and objects. Visual Studio works really well with Team...

Yep. It's just you.

jcrawf02 (2/17/2011)

---

Brandie Tarvin (2/17/2011)

---

I'll supply the...

Could you explain what that means please? I don't understand what you posted.

I'd go to the Quest web site and take a look at the SQL Litespeed documentation. Depending on how you installed Litespeed, it can use standard restore syntax.