AFAIK, the UCP collects data using Data Collector from other instances. This provides an overview, which seems to indicate that it might supercede DC, but it might just be a...

I think you can write a query that gets these values from the table.

You could so something like

select orderID, itemID

from Orders o

where ItemID > 'I3'

However if you could...

Sean is correct. Without an order by, the top 10 is semi-useless. You might get different sums each time.

This help? http://msdn.microsoft.com/en-us/library/bb675163.aspx

Explains the process and shows C# code.

There's a basic diagram in SSMS, though it doesn't to HTML. However you could take an image and HMTL map link it to docs.

I used to use ER/Studio for something...

Not asking that at all, just strange that everyone dropped off at once.

I'm sure a few of you are heading to PASS or SQL Saturday #92 in Portland today, but...

Send the encryption password separately from the drive. If the drive is lost, the key to get in shouldn't be in there.

amazing how this thread will explode or go dead in a cycle. Everyone watching Tigers/Yankees last night? Or the new Big Bang Theory?

Congrats to the Tigers.

Didn't see the game, but sounds like lots of drama in there.

Which event? The events are linked in the editorial.

First do this:

1. create a new role

2. Grant delete to this role.

3. create a new user/login, add them to the new role

4. see if they can delete.

That tests the...

Here are some scenarios: http://msdn.microsoft.com/en-us/library/ms152560.aspx

Basically there is an option REPLICATION_WITH_KEEP_REPLICATION option that you do not need. The checkbox includes this option.

If you haven't seen it, his 2005 Stanford Commencement. Excellent talk: http://www.youtube.com/watch?v=D1R-jKKp3NA&feature=player_embedded#!

A sad day, and a reminder that I'm getting older as well. People I admire, know, love, are slowly...

instance time v os time? Sheesh, is there a technical discussion taking place again?

The only thing we're guaranteed to win is the American Football championship. Mostly because we don't have any competition outside the US (yet)