It's a normal view, just of one table. So for the customers table it's

create view PassThroughCustomers

as

select * from Customers

Note that I wouldn't present every tech decision to business people, but there are times where I think giving them a little insight into the costs for different solutions that...

Those are good suggestions. We are getting some people up there, so I ought to add more.

It could be a bug in zenoss, or potentially some issue on the machine. It's an issue for sure, and just because zenoss worked well for 100 people, does not...

Amit,

Please write down what you are doing. Type "I execute this in SSMS 2008 and get an error" or "I run this through .NET" and don't have people guessing about...

I think SSAS needs it's own exam, actually 2. An admin an an MDX/Designer/developer one.

Probably only 7-8 CDs. Still, 7-8 CDs for an install? I remember that being a large complicated install with 5.25" floppies.

However 250 might be overkill. I think dropping 50 on...

I would like to see it broken down, even further than just 3 general areas. I think there is value in proving T-SQL skills alone. Probably value in overall administration...

WayneS (4/5/2010)

---

I don't know. But, there is a SQL Saturday this weekend in Richmond, VA that I'll be attending. If we can have something ready by then, I'll do what...

I like the idea of carrying my environment on a flash drive. I just think I want to wait for USB 4.0 before I really do it and get some...

If you can, it would be great for you to capture a workload and then some CPU/mem/disk stats before and after compression. That would make a great article on a...

If that's the case, you might be surprised what compression does for you.

So data compression can help because it substantially lowers I/O. It sounds crazy since it will use more CPU to do the compression, but you end up saving resources if...

Why are you doing this? Is it for reporting or are you considering storing the data in this format?

We used to do something similar for sending email here on the site. we had multiple machines that sent, and needed to read a database table to get their list...