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

- with sql2005 you would use ddl-triggers saving everything you would want to.

- with sql2000 you could try to use this trace but would not have that much detail as...

you could use smtpmail in stead of sqlmail.

have a look at SQLDev.Net

- If it all started all of a sudden, I would begin with starting a sql trace for e.g. one hour. Then examine the results and search for big consumers....

- What do you want to monitor about the errorlog ? Size or content ?

- we use a scheduled (sqlagent) job to start new errorlogs at least every week using...