Yeah, wow. Everything, and I mean everything, is on DB_2 in this simulation. Our DB_1 is really a type of accessor DB. All it has are views. Every table referenced...

I know I've seen this article before but maybe didn't grasp the significance of it. The security context the linked server runs as cannot execute DBCC SHOW_STATISTICS. I may try...

Wayne, this is sweet :exclamation: It looks like it can even be extended for use if I want to track all ESN changes per customer, not just the 1st. If...

Just to get this effort started I'm going to be working a straight month at a time. For each situation that represents an ESN change for the customer/customer line combination...

For now, nothing 😀 My report will produce counts in a given month for before and after the 1st ESN change in that month.

Ken

As you say only the definitions are really needed. We're fortunate that our MOLAP cubes are on a drive that gets backed up by our network guys. I dunno, maybe...

I know we've having this type of fun trying to pull from Teradata which only has a 32 bit driver for our Itanium chipset. I don't know about Relativity but...

The reason I remembered these incidents is because we used to deal with huge stacks of paper as thick as the one shown in the image of the line printer...

You have to always keep your 'head' and whenever possible verify all aspects and compare them to your situation. More often than not things that might seem relevant are completely...

Our group got a new manager at the turn of 2010. He's was already a managing a group of developers in our company but none of us knew him.

So a...

Take out "and database_id < 2"; you still get the same result and looks like a harder question.

Ken

I thought today was the last day to save $200.

Are more companies or departments forgoing the need for a dedicated DBA?

I work for a large company and I'd say no. All our really big systems have dedicated DBAs....

That's nice. We often think about versioning our office documents and client program code this way but not our T-SQL procs. I comment in-line a lot but a version header...

Oh sure, we have that; though I can't take credit for it :-P.

Select [DateTime] from...