I have also something similar, a complex job that is running in about 1.5 hours (every two hours, every day) that from time to time (may be once every two...

I don't want to say that sql Turbo is a bad product, we are very happy with the speed, but found some issues with it:

- Memory management issues, as with...

Dear Mr. Jones,

Yes I have one warning for the SP1, may be it is somewhere in the release note or readme but I very seldom read them (I know it's...

??? No idea how they get this answer ??? I tried on my test server (W2k and SQL2k sp3a) and the recovery model of msdb does not change after a...

No. If you have to store scripts or monitoring results you create a dedicated db. Never keep standard samples on your production servers. It takes places, open security holes and...

Not a cool one. Northwind and Pubs should not be present on a production server and there is no real point doing logs backup on a test or dev system....

Correct Answer:

Restore the database using the named transaction restore feature.

????????????????????

Can someone tell me where to find this feature in EM or the TSQL syntax to achieve this?

Like the other: the so called correct answer is a key that does not even exist, under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server just just have 8.00.000 and 80, nothing like mssqlserver. 

The real correct...

Could someone explain me the "sometimes" ? For me when a db is autogrowing it takes cpu cycles and disk access. So performance is always affected whatever the query...

Hi,

For me NULL means unknown and not "no value". If a name (for example) is unknow you put a NULL value and deal with it in the code. If there...

I think that SQLServerCentral should be more carefull when writting their questions. When there is a typo, it is difficult to know if we have to answer that there is...