Age is not persisted, so it is 312.

But there is the "+2" per variable length column.

So 316... but for the wrong reasons

...except on Windows 2003...

Isn't file initialisation immediate?

In BOL:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/1ad468f5-4f75-480b-aac6-0b01b048bd67.htm

"For a dedicated database server, the default memory settings for SQL Server should suffice."

Not sure I agree with this (the context is having AWE enabled)

This means a SQL 2000 instance...

You can't "strip off" time unless you store it as varchar.

The first post said it is a datetime column, ergo, it must store time but as 00:00:00.000

What about this: http://support.microsoft.com/kb/891311/en-us

Searching the MSKB for 17882 gives this:

http://search.support.microsoft.com/search/default.aspx?spid=global&query=17882+sql&catalog=LCID%3D2057&pwt=false&title=false&kt=ALL&mdt=0&comm=1&ast=1&ast=2&ast=3&mode=a

Looks like a patch is your only option

What is wrong with gaps in your ID sequence?

Excluding other peoples views on ID columns (Joe Celko etc), the fact that gaps are causing you problems means you have design...

Have you enabled AWE in MSSQL without setting max memory etc?

You could be generating a lot of swapping between RAM and page file...

For 4GB on the server:

Enable /3Gb and leave to settle at 2.8GB ish (see this KB http://support.microsoft.com/default.aspx?scid=kb;EN-US;316749, SQL leaves 384MB out of 2-3GB). Trying to increase beyond 3GB will...

You don't get this error if you use local system - it's to do with the domain user account not having rights to register SPNs in AD. It happens on...

There is a post SP3a hotfix to fix this. It may 818, but best really to install SP4...

This is nothing to do with DTC or builtin admins.

Check out "Security Account Delegation" in BOL - your linked srv is trying to pass through your NT credentials

Edit for 2 posts at...

I may be being simple:

MSSQL will cache data (as mentioned).

This means your database will be run out of memory if all the data can be cached.

If you write to the...

I'm also not sure what you are trying to do but if you have several records where RMSTRANCDE = '10' and you want to return 0 for zero records and...

SELECT a.KeyColumn

FROM @tablea As a

LEFT JOIN (SELECT * FROM @tableb WHERE b.SomeColumn = 'B') b

ON a.KeyColumn = b.KeyColumn OR b.KeyColumn IS NULL

Use this (I have no SQL box...

From personal experience, outer joins mostly give better performance.

I can't recall where it has been worse - the same, yes, but not worse.

Indexing, output columns (from one table or both),...