This help? http://msdn.microsoft.com/en-us/library/ms187743%28v=SQL.100%29.aspx

Which ports do you mean? The ports the server is listening on? Configuration manager or the error log list these. Or are you looking for which ports a particular connection...

It would help if you explained how you are getting this data, show some code, and then explain what will happen. As Wayne mentioned, there are ways to do this,...

So Blandry, I'm confused, you're not an MVP because you don't know everything about a product? Or everything in some area? Or all technologies?

The award is a community award. It's...

I like Jeffrey's scheme. I do that as well, one maint plan for each "maint scheme". So one for system dbs (no t-log backup), one for user dbs that need...

Do they not have a unique index on tables? If so, adding a primary key would merely be changing that unique one to double duty as a PK. Not sure...

Probably should have one at 662, any ideas? Maybe "The Say Hey Kid"

The next level is 714, Right There with Babe.

Happy to elaborate:

I have an object/entity with 20 fields, perhaps some larger, varchar(max) or large char fields, that exits in one table. I build a clustered index, which is the...

Joe, thanks for the response, but I think you'd find many more people upset over a separate email than a short note.

We'll likely continue to do this, but I do...

Football? I know minicamps [/url]are going on, but we're over a month away from football 😛

Joe Howard (6/8/2010)

---

Good question, and I really appreciate the detailed explanation. I wish all the QoDs were so well explained.

What I don't appreciate is the sales pitch...

think widely. I have had cases where we do store data in a table that is relevent to that entity, but is rarely queried. Keeping it in the same table,...

Thanks for the suggestions. Had a quiet dinner on Iberville last night and then a few hours in Harrahs' with a friend. Not sure what I'll do tonight.

The BI sessions...

Thanks for the note. I won't make it this time, but Andy Warren went and enjoyed it. I'll try to go when I come back in August.

In a source control session at SQL Saturday #22. Surprising that quite a few people don't use an VSC for their SQL Code.

What do you guys use? Manual versioning?