Philip,

thank you so much. Are you in Hawaii ? I'm in San Francisco.

Mike.

Philip,

we have exactly the same case here as you had before.

IMPLICIT_TRANSACTIONS option behavior has changed and Java/Hibernate (jTDS old version 0.9) code does not commit every DML stmt (intended...

Philip,

thank you for the post. I will try to incorporate your finding and let you know how it works in my case.

Mike.

Gail,

do i need to run SQLDiag to post Error log here ?

Our environment is a home grown Java application , not 3rd party...

Thank you for helping us, Mike.

Hi,

Unfortunately removing ORDER BY  clause  ( 4 columns are involved) doesn’t  help to prevent enormous tempdb growth…Technique suggested by Michael Earl  (replacing stmts like isnull...

Guys,

all your comments are valuable. Optimizer shows a full table scan on all tables and we're working  on reducing number of joins and transforming them as you suggested. Microsoft has redesigned...

Daryl,

removing all case stmts doesn't impact tempdb growth....

Hi Daryl,

Thanks for the quick reply, but what you do mean by "a.*". There is no wildcard search in this query. Do you mean anything start with the alias...

Kaddie,

thank you. SSIS is not GUI intuitive as DTS is. To me the entire SQL Server 2005 environment looks very cumbersome. It doesn't look like a Microsoft product anymore...

Kaddie,

I'm new to SSIS and what is mechanism to deploy a package from VS 2005 to SQL Server 2005 to schedule it as a job later ?  I've followed Books online approach called...

Guys,

I've already found a solution. You have to use Maintenance Toolbox (go to view, click on Toolbox). It looks very combersome, but it works. Thru graphical interface you can drug available...

Thank you, Dan.

Lesson #1 : don't install RTM version thru Terminal Services. It takes 50 mins for configuration checking vs 5 mins to install directly.

My installation saga continues...

Initial installtion that allowed...

Guys,

problems I've been experiencing with the error "Time out expired" are related to underlying hardware. Server's disk I/O subsystem can't keep up with SQL Server Engine locking management requests (thank you, Rudy Komascar). Tempdb database must...

Guys,

when I go to EM and click on Current activity it gives an error 1222 "Lock request time out period exceeded". I've already tried to change tools..options..advanced. It didn't work.

Guys,

location ? location ? location ?