that is strange, but I was thinking something simpler:

DECLARE mycursor CURSOR FOR

SELECT

m.TPH_PNT,

m.TREE_COUNT

FROM dbo.LIVE_MASTER m

JOIN dbo.UDB_PNT p ON m.PNTID = p.PNTID

JOIN dbo.UDB_CC c ON p.CCID = c.CCID

JOIN dbo.UDB_FC f ON...

Lynn,

Glad she's OK. It's slippery around here right now. We were worried when my oldest drove to Breck last night, but he made it OK.

congrats, Gus. Looks like Karma is working for you.

You would have to track updates or data changes across tables to know which ones are used the most. You could add triggers to track this, or run a trace...

It's a lot of fun, and people throw all sorts of ways. A wide variety of talent, but I enjoy just going out there with a ball. In many ways...

Just got my email about the new season this morning for the old man's league. We report in 4.5 weeks!

It's definitely a data issue. As much as Jeff might not want to hear it, I think the quickest way to track down the data is to run a cursor,...

Not a bad idea, though I think SQL Azure needs it's own section. It isn't really tied to SQL Server 2008.

Bru is correct. Each registration is a connection to a separate server. They are not in any way related.

Mzak,

you are correct. However many jobs, many IT jobs, don't specify holiday requirements. I've never had that be stated when I was hired. You're expected to "do the job". Being...

Typically you would do this:

select *

from sales

where datesvc >= '9/1/2009'

and datesvc < '10/1/2009'

pssdiag gives you a bunch, but it has other stuff. Might be able to easily extract the metadata.

Links have been changed to remove the "?" from the links.

There are jobs, at least a few. I got offered 3 this past year. turned them down as...

Thanks, I'll clean up the links.