What they said didn't hurt, and I don't dissagree with any of it. I was just specifically interested in Files, Filegroups, log files and tempdb file strategy related to the...

I don't dissagree with you at all about optimizing code. Perhaps I should have narrrowed my question to begin with so that I could have been clear that I already...

Performance Point is Microsoft's evolution from Proclarity and Microsoft scorecards. I have not actually worked with Performance Point, but I have worked with Proclarity.

I am actually trying to push...

Good job - glad you figured it out.

P.S. I don't envy you having to work with Oracle

The benefit to using a stored procedure is that the execution plan might be stored in the procedure cache so at run time the SQL Engine won't have to compile...

"SELECT * FROM schema.table

PARTITION(name_rest01" + right((DT_WSTR,20)month(dateadd("mm",-1,getdate())),2) +

right((DT_WSTR,50)Year(dateadd("mm",-1,getdate())),2)

Should work for your expression. I think the only thing wrong with your expression is that it has an extra parenthesis at...

My initial recommendation to this client was to use two file groups each having one physical file. Make the Secondary file group the default and send clustered indexes to the...

Thank you for your reply, but it really didn't have anything to do with my question. I really just want information related to my question about splitting files within the...

Using separate file groups is the only way I would do it if I were the DBA and had authority over the system. The situation I face is that this...

Thank you for your feedback. The idea of splitting the clustered indexes from the indexes and placing them on separate file groups which would then be on separate disk arrays...

About raid 5 - I know raid 0 (striped) and raid 10 (striped + mirror) will give better performance, but is there a white paper or some other resource you...

Actually I don't have access to a SQL 2005 disk, so if there is another useful resource (I could get to online) that you think might be relevant to my...

I have 8 spindles on one array and 5 spindles each on the other two. Please do send me your thoughts even if you are not sure they would be...

The server and storage array is in fact HP, and they are iLO is in fact enabled. I was surprised to find this out from my operations team since I...

The server and storage array is in fact HP, and they are iLO is in fact enabled. I was surprised to find this out from my operations team since I...