we always put client tools on the server because our datacenter is 20 miles and two routers away. if we have to run a big query for some reason we...

how big are these tables? small tables will almost always stay fragmented. i have tables with tens of millions of rows and alter index along with the system view works...

do not do /3gb or PAE on 64 bit since it's not needed

check your paging file settings. i found that on windows 2003 x64 the default is 2GB - 4GB...

we had a server we upgraded with 4 320GB HD's because they needed the space. RAID5. At first it was OK, but we bought a company and suddenly amount of...

in a smaller environment frequent upgrades are easier. in larger ones there are enough bugs in sql 2005 with backward compatibility to make it a challenge. then there are application...

looks like the MS hype machine is in full swing. few years ago they were hyping sql 2005 as the next best thing, now it's don't buy 2005 since 2008...

thanks, i set up RAID 10 on a new server we just bought and so far it's pretty fast reading and writing at the same time

db mail is in 64 bit, i'm using it on enterprise

sql mail will not work and will give you an error message

there is a MS article giving step by step instructions. if you do it wrong you will need to rebuild the entire cluster from scratch

dbcc showcontig is a piece of junk and the system view is a lot better and a lot more accurate

we run maintenance every night where only the indexes needing to...

thx, i'll try that if need be

for now we just changed it to varchar(10) and told our devs and billing people to check it and make sure it's OK. will...

from what i remember in the NT4 and 2000 MCSE you have to avoid reading too much in the question and think in Microsoft centric terms

i just did this

set up new machine

restore db's

transfer logins and sp_change_users_login

set up a temp server with empty databases prior to the move and transfer all jobs. then transfer all jobs...

one thing i learned in the last few weeks

we bought a bunch of HP DL 380 G5 servers and they all run Windows 2003 R2 x64. Two are clustered in...

this depends on your local environment

i try to run it every night since sometimes things happen and you miss a few days. this way it gives you some overhead