It sounds like this is a new implementation. I've found that with new Sharepoint installations users madly add their old documents and the database grows very quickly initially, but once...

To answer your original question: Should you upgrade to 2008 for the MERGE statement?

I'd have to say if that is the only reason you have for upgrading then probably not....

Also what version of Sharepoint are you using?

Leo

As Jason says 11GB isn't very large.

Could you give a bit more detail here? Like what is the growth rate? Are there any specific tables that are unusually large? Are...

Be careful about buying SQL 2008 vs SQL 2008 R2.

In R2 Standard Edition Microsoft have limited the memory usage. In 2008 it was OS Maximum, but with 2008 R2 this...

After much research that lead no where, I came across an unrelated article that mentioned the DCOM component MSDtsServer100 and configuring it's end points, so I did a bit of...

Further to my original post, I've now been able to link an error in the application event log on the server I'm trying to connect to:

Date ...

Scripting restores for 130 odd databases isn't that much trouble since all the information is in tables you can create a single script that generates the restore scripts for all...

Further to my previous e-mail I hve picked up that there are 2 installations of SSIS 2008R2 on different servers in the domain, both running under the NT Authority\NETWORKSERVICE account.

When...

You can try using BCP and define the -t and -r switch both as |.

C:\Users\leo>bcp scratch.dbo.TestTable out C:\temp\pipeOut.txt -S MyTestServer\SQL2008 -T -t"|" -r"|" -n

I tried the above and it accepted...

Much lower risk is to backup the database, then log on with the sa account, then restore it from the backup you just created. The database will be owned by...

If you could expand on the actual issue there may be a solution out there. I don't see that using temp tables should cause locking, and TempDB growing isn't in...

What about chached query plans? These are cleared on startup, could the cached plan no longer be effective? Have you tried doing a DBCC FREEPROCCACHE and seeing how things perform?

Also...

As has been mentione the answer to the first question...

If you are really concerend you can do a DBCC DropCleanBuffers, but remember this will also affect performance as it flushes all currently "clean" buffers from the buffer pool, where...