John

I don't advise putting a clustered index on a varchar column, especially if it means inserts will be made in the middle of the index - this will cause page...

Papillon

Come on, you must be able to work out the answers to at least some of those!  Let us know what you think the answers might be, and we'll comment. ...

John

Depending on why you want to remove the records, another thing that might work for you is this.  Create a flag column in your table called IsActive, with a default...

Carl

If I'm understanding you correctly, this is what you do:

(1) Create a stored procedure in the master database called sp_MyWork (the sp_ prefix is important).

(2) Run the stored procedure against...

If you can "see" one server from the other, the easiest way to move a DTS job is to open it, go to Save As and choose the new server...

Charbel

I'm not sure what you mean by the first three characters of the key, since in your sample data, all Key values are three characters long.  If the following doesn't...

Gail

I don't know whether this works in SQL Server 2005, but in 2000 you can insert the result of xp_errorlog into a temp table, then query to find the earliest...

PM

You should be able to attach the database.  You have to specify a name - I would guess HA_Raw_38 was probably the original name.  You can find the syntax for...

I think I agree that bitmasks are to be avoided in most instances.  But what happens when the number of bit columns is not known at design time, for example...

Denise

I imagine you'll find plenty of white papers and the like on Microsoft's website.

John

David

The WITH MOVE and WITH REPLACE options are used if you are restoring using T-SQL, for example in Query Analyzer.  Their respective Enterprise Manager equivalents are changing the file names...

Dan

I'm afraid this still doesn't make sense.  You can't have a foreign key constraint in TEAMS referencing the TEAM_NAME column in TEAM_PROFILE since that column does not have a unique...

Ian

There are scripts you can search for on this site for estimating table and database size.

As for log space, this depends less on the size of the database than on...

Dan

This DDL doesn't make sense, for the following reasons:

(1) The syntax for the foreign key constraint in the first table is wrong

(2) You're missing a comma from the second table...

Jo

Just an idea, this...

You have a stored procedure called TEST5 in a database called Statistiek, right?  I've a feeling that EXEC Statistiek.dbo.TEST5 will execute that proc against Statistiek rather than...