I'll shoot something back to you! I actually just moved files to a new volume. I've updated Analysis Server Properties and moved all the files, even updated the...

I used "Querying Microsoft SQL Server 2012 by Itzik Ben-gan; Dejan Sarka; Ron Talmage". It's pretty compreshensive, has exercises, a cd with practice tests and exam simulation etc. ...

This is the single most helfpul series I've read on this site. It came along just at the right time and had just the level of detail I needed....

Where was this article 2 years ago when I was beating my head against MDX? Probably the most helpful I've come across on the site. When I rated...

Sorry guys. Answered my own question. Using "Transfer SQL Server Objects" in SSIS will bring over schema, indexes if specified. If the table of origin is compressed,...

Thanks you just saved me tons of time!