The /3GB switch alone would do this, but I guess you are saying that it is not set here?

Well don't quote me on it, but I think they are called row constructors in the ANSI-SQL standard. I can check it to confirm when I get home, unless someone...

Are you using 64-bit? How much memory do you have and recognise?

Jeff, yes that is exactly what I meant with being surprised to find an author more or less recommending people to use NOLOCK in all reads. I hope to cover...

How about there is simply a lot more data in production? But yes, it is of course possible that production is not optimized, but that is always a problem you...

The simple answer is no, this is not possible. You might try implementing some more or less badly working home-built solution for it, but I would not think it is...

You should still call BOL for BOL.

An .msi is installed by double-clicking it.

You could try downloading AdventureWorks from MSDN This download is for Express Edition, but I assume it is the same database and it...

A correlated subquery is a subquery that refers to the outer query. For instance:

SELECT *

FROM FOO<

WHERE EXISTS (

SELECT *

FROM BAR

WHERE BAR.x = FOO.y )

No, unfortunately SQL Server does not have row constructors. It is one of my top wished for items.

1. No, the latest version is September CTP, which will probably also be the final pre-RTM version.

2. Nov 7, 2005.

3. Dec 31, 2007.

2. For historical logging of perfmon data you should save the file to a drive on the SQL Server.

In addition to that, remember that in XP and Server 2003 it...

Remi is correct, and it is all in BOL. Start at http://msdn2.microsoft.com/en-us/library/ms245878

Please do not crosspost. Continue this discussion in the other thread.

What is the recovery interval set to?

EXEC sp_configure 'recovery interval'