this server has Win2003, SQL2005, 16g RAM, AWE enabled, min server memory = 0, max server memory = unlimited. how do I know how much memory is used by...

oops.. what I did?

This db design definitely has flaws, the query is from cognos application so that I have to live with the current query. the only thing...

this db design definitely

thanks for your very quick replies.

Thanks Gail, I wish I could post table structures, indexes, query and its execution plan. But, the query is Cognos application and could take 3 pages. I...

I have a data warehouse query which joins 8 tables together, 1 table has extremely high scan count & logical reads, how can I reduce high scan count & logical...

I tried affinitty, but it came back after 3 days.

thanks Jeff, I will allocate some time that I can bring down the server and test it out.

Dell suggested to go BIOS and turn off Stepping, but warned processors speed could be down by 50%. Is it worth to turn off Stepping?

Dell suggested to go BIOS and turn off Stepping, but warned processors speed could be down by 50%. Is it worth to turn off Stepping?

I have changed the power to "always on" and set the affinity mask. But the message came back after 3 days. Any idea? Thanks.

Thanks for the example.

I coded the max(date) in script task and saved it as a variable, then passed this variable to sp in Execute SQL Task.

I have the same problem, need to pass a input parameter to a stored procedure. I have the following in General setting:

ConnectionType = OLE DB

Connection = ServerName.DBName

SQLSourceType = Direct...