It can be tricky to get linked servers working this way, I usually don't bother and use a defined login, this way I can lock down the object permissions and...

i recommend a good T sql book or training course, or even a read through BOL on joins and nulls.

In general terms a #table will outperform a permanent table defined for the sp. This is generally down to how sql server optimses #tables ( stats and such like )...

A few years a ago I used an online recovery, based in the US, when someone deleted a set of sub cirectories on a server. It worked very well -...

First thing I'd do, if you really want to do this in sql server, is upgrade to 2005 where you can define a user defined data type as an array...

#tables will tend to force procedure recompiles whilst table variables don't tend to optimise well for anything other than small(ish) data sets, the exact size depends. A largish table variable may...

I doubt it was memory. There can be problems using mapi mail if the exchange server restarts and you don't then stop and restart the sql server. It's not always...

you'd need unicode, check out BOL, and most importantly you ideally want to figure this one out before installing sql server

here's mine

EXEC master.dbo.xp_execresultset N'select  ''dbcc dbreindex (''+name+'')'' from dbo.sysobjects where xtype=''U''','bracknell'

where bracknell is the name of the database to run the command in.

• turn auto grow back on - why on earth would you think turning this off would help?
• get a dba
• go on a training course
• buy sql 2000 performance tuning guide.
• Rebuild indexes
• update stats...

I'd suggest you don't - the sql2k wizard is essentially rubbish. If you really must use one of these tools run it aginst the sql 2005 tuning advisor.

that sounds like a crm app I sadly have encountered a couple of times that insists in having objects owned by non dbo.

To be honest dbs owned by sa (...

you say you don't want to return space back to o/s - is this correct? So is what you're asking how you can shrink the physical data storage part of...

http://sqlblogcasts.com/blogs/grumpyolddba/archive/tags/Trending+and+Statistics/default.aspx

The quickest way is to check the clustered box in EM , index properties and save.

However, this isn't good in a controlled environment, it may also take a while.

other than...