update statistics with fullscan on all the table from which I get data didn't make a difference.

I ran my code in small pieces to see if I could find where...

I've already changed the procedure to use temp tables, that is no longer a...

First, thank you all for helping, I knew I was asking at the right place

I'm a self-taught DBA and tbh, I really don't know much about statistics, I never...

I've been doing my homework the last 2 days and got some information over a 48 hours period from Perfmon. Some numbers are encouraging while others raise some concerns.

Available...

I think I haven't been clear or maybe my original post was too long and this got lost in it.

We are not looking into this because we want...

Yes of course, I should have posted the link. It's about SQL 2008 but I'm sure it's good for 2005 as well.

http://sqlcat.com/whitepapers/archive/2008/10/03/running-sql-server-2008-in-a-hyper-v-environment-best-practices-and-performance-recommendations.aspx

LutzM (12/22/2010)

---

Gagne (12/22/2010)

---

...

Regarding your transaction log: you might want to perform a transaction log more frequently (the setting on our production system is 15 minutes...). But that's a different story....

David, Lutz,

Thank you both for sharing your thoughts on this. I agree that checking out I/O performance is the first thing I should do, if that is as "bad"...

Should I take the lack of answers as an indication that virtualizing SQL Server isn't popular and may not be a good idea ?

I really don't know much on database security and permissions but while reading your post I wondered if adding user2 to the db_owner role is enough, I would try adding...

Just as a safety net...

Lutz thanks for the reply. I've learned about Tally tables here in the forum and I already have a few but the "Cross Apply" is new to me. ...

SwePeso is right and I should I mentioned this, the first example will put a null value in all the records that don't have rows for the same employee in...

Assuming table names to be Employee and Salary.

Update Employee set TotalSalary = (Select sum(Salary) from Salary where EmployeeID = Employee.EmployeeID)

or

Update Employee set TotalSalary = a.TotalSalary

from (Select EmployeeID, SUM(Salary) as TotalSalary...

SQLPirate (1/20/2010)

---

There is no SAC tool in 2k8.

Instead, open your 2008 Management Studio.

In Object Explorer, right click on the server name > select facets

In the window that opens up, select...