I should clarify one other thing. You could have the UCP on every machine separately. In this case, the UCP, Managed Instance, Data Collectors would all reside on the same...

It is somewhat more complex [C'mon this is Msft we are talking about - when was the last time they made something simple?]. The UCP is the data warehouse. The...

Hey, Ant.

I am still working through the details of The Utility and Utility Control Point / Managed Instance architecture, but have a few things to point out.

The Data...

Hi, Marios. Did you ever get additional information on this? Do you have a sample of the code before and after in c#?

I am currently conducting some tests that look at the result of uncompressed vs. page vs. row. The results are not final yet, but only a handful of tables compressed...

If an index is available, it WILL use it [though not always the primary key].

Good article. It's good to see sp_spaceused in an article. It provides a lot of great information for one little proc.

I still can't believe that you can get a...

OK, the issue is simply one of coding style for the most part. The optimizer should handle "declarative" code [whatever that is] in much the same way that it would...

You may have been in diapers when I started in database work on DB2 V2. I am not surprised that lots of combinations means lots of code -- I...

Thanks for your thoughts on this. It seems like a fairly common problem without a really good solution. Although some of the suggestions herein work to reduce the number...

I can understand using the high-values in the "TO" part of the range to eliminate extra code. However, I am interested in a specific value when I provide one [as...

Care to elaborate?

Call me crazy, but I think I would do a global change on the column to eliminate the dash.

I liked the article.

Whe I am working on performance I am primarily concerned with physical I/O, not logical I/O when it comes to performance. [OK, someone tear me a...