Thanks Peter. I knew a simple solution was out there, I just couldn't visualize it how to pivot it appropriately. As to other tools, for a product I...

This definitely has a practical application.

Quite possible this is no longer relevant with Sql 2k5, but I used to do this extensively in a Sql2k environment with immediate transactional replication....

I strongly recommend you use more answers than just mine, because I've only done it one way and don't know the benefits of the others.

But in my company, we script...

I'd split up that 8 disk internal RAID 10 into a RAID 1 for the OS and a six disk RAID 10. The six disk RAID 10 I'd dedicate...

So...

Using management studio, right click on the dimension and choose "script dimension as" -> "create to" -> "file".

If you're using source control, you can check the XMLA file in.

Manual deployment...

And to answer your specific question, you do not need to do multiple file groups to get SQL to parallelize your IO. We run a DW on a single...

Hi Slawek,

I for one think you're going down a wrong path in trying to get more I/O throughput by splitting onto multiple file groups. In my limited experience, multiple...

I kept looking for checkboxes to select both correct answers. Lucky I guessed right which one you were looking for. Although I suppose you could argue that the...

Many thanks to Remus Rusanu and his wonderful service broker blog. Apparently even with execute as self, SQL Server doesn't really trust the stored procedure we're running. The...