Jeff Moden (10/8/2011)

---

Lynn Pettis (10/7/2011)

---

For a test server (non production) you can purchase the Developer Edition for about $50.

If the testers are not changing anything in the database, just running...

I tell them what I want to make. The job should pay what the job's worth for the most part. Some wiggle room for experience, but I wouldn't hire a...

Licensing is a bit of a train wreck. I think Lynn's idea of developer edition makes sense. If you have licenses for it, and you might if you have MSDN,...

That makes sense, sorry. Wasn't aware you were looking beyond tables.

Have you looked at Dependecy Tracker? If you have SQL Doc, you might have a license for that and it...

Poll on Dan Patrick this morning: Who gets back in the groove first? A-Rod or Tiger?

I was thinking Tiger, but Rich Eisen thought that Tiger might never win again....

Ray K (10/7/2011)

---

I had the game on in the background. There were too...

jay holovacs (10/7/2011)

---

We have run the plant on generators. We experience several power failures a year. The data center and emergency lighting, data center cooling etc. is the top priority...

You're looking at this the wrong way. You can tune a SQL statement to use less records, usually with indexing or rewriting.

This use of TOP doesn't make sense.

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.