capture their data in temp-tables (#tmpprocx, #tmpprocy, #tmpprocz) and join these 3 tables.

what virsion and sp of SQLServer are you running ?

to keep them available, but avoid the actual resourceoverhead (ram-wize) just have the databases closed.

alter database xyz set AUTO_CLOSE ON .

Check BOL and remove it from db that get opened frequently !

did you remove the /3GB parameter in boot.ini ?

Only /PAE should be active.

keep in mind you have to use windows perfmon to see if it uses awe and uses more than 4Gb

Taskmanager shows wrong data.

- are you logged in being member of the sysadmins group ? Otherwize you cannot see them.

- Expecialy concurency for processor time, memory

- you should avoid SQLServer being paged out because then the slowdown is drastic !

Express edition is limited to 1Gb RAM, 1CPU and 4Gb...

- Indeed SQLExpress is a valid option.

- you can run it on a non-dedicated server/pc suffering concurrency issues

- pc ? Consider fault tollerence of the hardware (disk & raid1) ?

-...

thanks for the feedback.

A transactionlog records all insert/update/delete activity on a transaction basis to be able to keep the database consistent e.g. in case of servercrach,...

If the recovery model is set to...

- You need an extra install of the client components on the second node.

You're just installing a client, so there's no need to failover the sqlserver-server instance to the node of...

-If you want to be sure about the hypothesis that another user is faster than your connect with QA, change the auditlevel to ALL connections (serverproperties\security).  This way all login...

http://support.microsoft.com/kb/307487

You'll need 3 statements to perform this action

- one way to speed it up might be to put your indexes on another disk as the rest of your data.

-...

- Think of te consequences of auditing this way (data volume)

- Check "create trigger" in BOL

e.g.

create

trigger trg_D_yourtable on yourowner