patient clinical data can't make the change void the warranty , worse thing is an upgrade could blow up with any of these modification

sorry but that is the real world, that's why I referenced 3rd party app, which rhymes with 3rd party c&#*#rap. Cant change

windows 2008, gets better just sent link to steps to add drive to resource, looks like resource needs to come off line, 1 minute later cluster went down, not sure...

yes new job just did not set this one up, however it is a prod server so treading lightly, been a year since I built my last one kind of...

little scary but went into cluster admin and noticed no dependencies on any of the drives

CTE's and table variables have their place but beware of performance, too many people fall in love with this stuff without understanding how destructive they can be with large data...

The new box is proc licensed, the one I am moving from is CA licensed and with Sharepoint hitting the reporting server on that box MS says have to...

the intention was to remove the reporting server from the sharepoint box entirely and have this on the second instance. I get sharepoint integrated is better, but not my...

may be a mute point has the vendor or have you done any index analysis? If you look at brent ozars blitzindex one of the best tools yuou can...

been a sqk dba for 20 years your response was fairly condescending, I completely realize disk IO is a big factor, current db less than a terabyte and this is...

we let them use access but only with sp's that way i can limit the damage in their queries, otherwise you get some one who thinks 3 outer joins is...

been a sql dba since 4.2, used to teach and access class, the change from excel to access is a complete mind set change. I used to spend 4...

but in this statement

select * from sys.sysfiles

I get all the logical/physical filenames, wanted to link this back to the objects to see what objects are at this level

PS looking for objects on the logical file groups. I have a file group name called NIndex_1 but it has 18 logical files. Looking for what is on...

got play with the hand I am dealt, it at least keeps me on my toes