if you want to clean up tempdb u can schedule this script. it will remove temp tables that are older than 12 hrs. u can schedule it hourly. test it...

make sure you change path for binaries and data file when you setup parameter during installation. it might be coming from there. make sure u click advance and for all...

There are DMV available in sql 2005. use that and query memory, cpu disk queue length. also sql 2005 give you reports . utilize that it very detailed info init.

cluster cannot be geographical different location. Nodes should be next to each other. Yes after that you can implement Logshipping or mirroriing for geographical failover.

ok . is this for sql 2005? if its active / active cluster then install secondinstance from second node. make sur eyou can see all drived and info in...

Guys,

you cannot install 2 different version with default instance. Please check BOL. SQL would not let you do that. So fo you. You have to uninstall both sql and then...

you need to check BOL first. here is the answer with example.

SET DATEFORMAT { format | @format_var }

Arguments

format | @format_var

Is the order of the dateparts. Can be...

Hi Mike,

I agree with you. I think new dba are not reading book at all. They are not googling it on internet. There are lots of site to find basic...

Yes thats is true no role change stored proc available in 2005 and it sucks. i dont know why MS wold do that. if you faile over and wna to...

Hi there,

Thanks. I will try that and let you know.

Hi Info_s,

Moving database is not problem . but in 2005 64 bit cluster it give error. please read the initial thread

Thanks Tracey and Nary,

Ok this is just did . Just to make sure its not disk thing issue. I tried moving it from one directory to another directory in the...

Thanks Tracey,

yes thats exactly what I am doing . yes both drives are in dependecy and I can see them. I am changing the master data and log file location...

Hi Tracey,

I am not sure if that was for me or not. But I am not restoring I am moving files. thats what I want to do to move files....

Thanks Scot.

I read the article. Information is good. but the only question i have is will it work for cluster environment. These step seems to work fine for stand...