Maxdop really depends on your application and your server setup. usually maxdop is set to use all processors and can be left on that setting.

i have come acrosss instances where...

then i'll go with what allen says - what is the recovery mode of the database

you can find it out by runing

sp_helpdb or clicking on the properties option...

It should be

I'm not sure you can do it with "ALTER TABLE x ALTHR COLOUMN y NOT FOR REPLICATION

but you can do it through enterprise manager - go to...

does that database exist?

is it sent in offline mode?

is this a maintenance plan for all user databases, or for specifically named databases

Separate arrays is best

Raid 1+0 array for data and mirrored for your log files

try and avoid raid 5 arrays if you can (write overhead is costly)

also place your tempdb on...

i'd suggest looking at sql agent. are you doing t-log backups every 30 minutes? is the laptop a subscriber (or publisher) for replication?

backing up sheduled tasks is done by backing up the msdb database as allen suggested

moving these jobs is a nightmare!! it all depends on what the jobs are.

try and match your query criteria to the same order as your compound index order, as the qeuery optimiser should be more likely to pick it up and (for the...

i agree - post us a few lines of data with a creat table statement

but your code will look something like

create procedure USP_GETMYDATA as

declare @todayscount integer

set @todayscount=(select count(*)...

can you add an extra parameter for the database name?

then your sql could refernce the full name of the table. e.g

database.tableowner.tablename

or could you post your stored procedure so we can...

i generally use the following format

declare @strsql navarchar(2000)

set @strsql=' select abc,def,ghi,'''+chr(99)+''' from mytable

exec (@strsql)

i con't remember if its chr or char as i'm away from my BOL at the...

quite possibly - i know that msaccess has several similar issues - but i can't beleive they'd make the same mistakes on SQL2005

i think you'd better wait for service pack...

if you use WHERE (PublishOnIntra = 1 OR @READONLY=1) that should be SARG proof

as i'm sure this is passed as WHERE (PublishOnIntra = 1 OR 1=1)

not sure about the performance drop, but i might be able help you on the convert problem

the issue is convert(decimal(18,0),a.itemnumber - your where clause filters out alphas, but it...

can you post both queries? these may give you different results (sometimes)

you can see the difference in the exec plan by pasting in to sql query anlyser and choosing the...