Well Andy, welcome to the club!

I believe everyone in your life is providing now valuable suggestions (at least they try 😉 ), so just one thing from me:

While the first...

Probably the easiest way to achieve this is to recreate the clustered index on this new filegroup. If you don't have a clustered index, you can still use this technique,...

Well Jeff, nothing I would recommend, but I was once confronted with this problem after using the Copy Database Wizard to migrate from 7.0 to 2000. I ended up reconfiguring...

Okay,

CREATE TABLE a_test

(

col1 INT IDENTITY

)

GO

INSERT INTO a_test DEFAULT VALUES

INSERT INTO a_test DEFAULT VALUES

INSERT INTO a_test DEFAULT VALUES

INSERT INTO a_test DEFAULT VALUES

SELECT * FROM a_test

DBCC CHECKIDENT(a_test,RESEED, 99)

INSERT INTO a_test DEFAULT VALUES

SELECT...

If you're looking for a way to explicitely insert values into such a column take a llok at SET IDENTITY_INSERT ON/OFF in BOL.

BTW, I would prefer using SCOPE_IDENTITY() rather than...

Yup, exactly there.

Sorry, couldn't get the formatting correct. Try it out and you will see what I mean

Okay, the remark about the Upsizing Wizard was more or less a joke.

IIRC the wizard converts all Access text fields to NVARCHAR columns.

As...

N' indicates Unicode.

People use it for international application with the needs to store *exotic* characters.

To be honest, I think most people use it because they never checked what the Access...

Hey, I won't tell you that directly. But a good start would be to google on those words.

Look at CREATE PROCEDURE in BOL

CREATE PROC [ EDURE ] [ owner. ] procedure_name [ ; number ]

[ { @parameter data_type }

...

Well, if we are only talking on how to track db growth, here are some techniques by Vyas Kondreddi.

There is no such thing as rownum in SQL Server. If you're after some sequential numbering this one might be interesting.

AFAIK, EM uses an undocumented DBCC command

DBCC SHOWFILESTATS

Ever so often the same question with the same answer. Read this

http://www.sommarskog.se/dynamic_sql.html

and

http://www.sommarskog.se/arrays-in-sql.html

and http://www.rac4sql.net/xp_execresultset.asp

HTH