Late reply to an old post but Talend is worth a look. Its free (Open Source) it runs in Java can talk to any JDBC source and a whole load...

When you run the stored proc in SQL Server Management Studio with menu option

Query -> Include Actual Execution Plan

Does the plan show a recommended index to add?

What parts of the...

I know this thread is old (very old but it may help someone else)

But with a high log flush I would look at the autogrowth settings. SQL 2008...

You see

When you apply a service pack

Hi,

Have a look at

http://support.microsoft.com/kb/216399

I've used Java awell in the past to convert from EBCDIC to ASCII. You can also get JDBC drivers for the AS400 and push to SQL...

The Activity Monitor In SQL 2008 will show you the most expensive queries.

Cheers

No normal master database entries are added to aid recovery but when I run

backup database thedatabase to disk='c:\thedatabase.bak' with copy_only

I still get a up to date last backup date in...

Are you calulating fields in your CLR stored procedure? If all you are doing is calling stored procedures from a stored procedure then TSQL should be enough if you configure...

Hi ,

I have not heard of the term

I think they are talking about clustering. Not Active Passive but Active Active with more than two nodes requiring SQL 2005...