Good story, sounds like you had fun...

Btw you say "though in SQL 2000 there is array processing."  Perhaps I am being a little daft - but could you explain? ...

N makes it unicode.  Why?  Well I don't think it matters with your example, but with some exciting unicode characters it makes all the difference!

thats the sqlserver:databases transactions/sec

Its broken down by database.

You could run a sysmon (or whatever its called these days)  server (not sql) trace and capture the av transactions per second.

you could do something like

Its probably good to have a clustered index anyway, otherwise you simply have a heap structure.  On that many records it would be good.

You need a primary key - and...

My understanding is that 090 is 90.  An int will convert it.

Your best bet is to use a varchar field with a constraint on it.

Unless anyone knows better?

Thanks John, an interesting idea. I am almost tempted to  go a step further and use a raw partition.  However its all complicated due to the 2 log shipped databases...

You could have a look and check what the collations are on the various char columns, if they are different on 1 table it _might_ make a difference?

Hi

I assume you are using convert to get to a round date rather than the full datetime.  I rather think that as you are looking to examine every record, indexing...

Does installing them on seperate servers require extra licensing?

I will research it myself, but if anyone already knows...

Its entirely possible I am talking about something else here, but you decide!

I have had fairly similar issues when using active directory security and the link to the ad server...

Thanks for the response.

fyi Blackbox trace basically stashes the last 10mb of trace data:

TRACE_PRODUCE_BLACKBOX Specifies that a record of the last 5 MB of trace information produced by the server...

I guess you could dump the contents of sp_helpfile into a table, strip the text out of the size field, and then run the alter database on that basis.

Probably an...

BOL:

USE master

GO

ALTER DATABASE Test1 

MODIFY FILE   (NAME =...