It doesn't make sense to move fact tables out. As mentioned above, compression works at the table level, and also at the index level. You can compress a table and...

You are correct, clustering should be a valid answer. I shall correct this.

That's a little scary, Lynn, and I have no idea.

Have you called PSS on this?

I've got a walkout, need to get pictures, and there are two full-sized, outside windows on that side of the house.

I should give it a try, and see if I...

And high school was ....

This determines how often EM checks the server to get its status.

And, perhaps more importantly, Jack, you keep the good people that fit your environment.

Here, here, rootman!

I definitely agree with blandry that the people make all the difference. I've been in similar situations and the people make or break the space. We built a bullpen one...

I know whatever edition was out in 78-82 time frame had a bunch of dice. We had 6, but also 8, 10, 20, maybe more.

More like a 660 point bailout today!

Hey, unlike some of the others who are getting "bailed out," I'll take responsibility for my mistakes.

jdshabat has a great point in that he devised the question to show the change.

Chris, you are tackling the questions correctly, use your memory and see if you know. However...

I'll correct the answers to show both as correct.

As usual, I started with a topic in BOL, in this case impersonation, which didn't mention the EXECUTE AS clause. Though I...

You need to monitor this as Nicholas suggested so that you have values. By having each server instant monitor itself, it means that there aren't external dependencies.

Be sure you include...

Adam,

Nice job and a good solution to the problem. There are lots of these, but it's good to be reminded of how this works as many people ask for all...