- also with that kind of size, consider using filegroups !(check BOL)

Especialy if you are planning on migrating to sql2005 where you can perform piecemeal restores so you actualy get...

you will need helper objects (#temptb) to solve this tree in sqlserver2000.

With sql2005 you would use a CTE.

Search SSC for "tree" and you'll find some options.

in adition to Aaron's reply ..

New with sql2005 is the "execute as .." for sp's.

check out "Using EXECUTE AS to Create Custom...

just script the full database. Create a new database and run the script.

You can use enterprise manager Rightclick the databasename \generate script. Be sure to select all things you want...

regarding the /3Gb setting I use the guidelines published at http://www.sql-server-performance.com/awe_memory.asp

I think you can find some at SSC.

indeed

If you use management studio, you can modify a table, change an indexed column's collation and have SSMS generate the script it would execute. (cancel the modification!)

Have a look at the...

DECLARE @command1 nvarchar(2000)

-- Set parameter values

Select @command1 = 'if not exists (select * from master.dbo.syslogins where loginname = N''yourdomain\youruser'')

 exec sp_grantlogin N''yourdomain\youruser''

 exec sp_defaultdb N''yourdomain\youruser'', N''XLANG''

 exec sp_defaultlanguage N''yourdomain\youruser'', N''us_english''

GO

if not exists (select...

- if you're using ssms to execute the query, you can see it's elaps time on the bottom of the ssms-window

- if you want more info, check "Displaying Execution...

- did you provide the same mail-profile (exact !) at the nodes ?

- when paging occurs, your server will slow down horribly !

- find out why it is paging because you should avoid it !

- If your db are to the optimum,...

yes.

compare it to one tree or two trees

an index has a key-part an one leaf-level containing one row for each row in the...

- keep in mind OUTLOOK is not cluster aware.

- if you ensist on using outlook, you'll have to perform a second exact ! installation at the node where you didn't...

like the message says, you're trying to convert a varchar to a numeric datatype. The content of the varchar is not a number !

This can also occur with implicit conversions