The select works for me, inside and outside of master.

Not sure what's wrong for you.

Nice job, Gail, and I didn't think you insulted Robert. I think sometimes they are asking to learn something (they don't know everything) and sometimes just giving you a hard...

I'll run the draft tomorrow, sending emails to everyone and asking for picks. You'll have to trust me to draw the numbers here for ordering.

If we don't get more, we'll...

Please show the query, table DDL and sample data

I also don't see the point in not offering downloads. Not like it couldn't require a login or a page view to get them.

The Windows Media streaming sucks. Never seems...

That's a stored procedure. The logic could be flawed.

No, the conclusion is that a narrow clustered index is good, and that other non-clustered indexes, even on the same column, might help. However you have to look at the...

First, just to be clear, the clustered index isn't on the filegroup. You create a clustered index on a table, and place that in a filegroup to move the table...

Doh!, yes, edited to to say what I meant.

Narrow clustered key, not necessarily narrow non-clustered key.

First, don't confuse clustered index with primary key. Not related in any way. By default the PK is clustered, but that's a setting. They have nothing to do with one...

As long as you are sure you don't need point in time recovery, you did the right thing.

I would argue that most people don't think they need point in time...

Here's what I'd do, especially as you might need this later.

Get a sproc for every table that updates a field based on the PK.

That's a lot of writing, but you...

First, why switch to simple? If you don't have a good reason and don't understand the implication, don't do it.

Second, no. Just switch to simple. However, you are then limited...

Just a reminder, 24 hours of PASS, the Women's edition, is going on today.

http://www.sqlpass.org/24hours/spring2011/SessionsbySchedule.aspx

The negotiations have been a problem and the deal for a party did not work. As other companies have started to look for similar deals, and do their own referrals,...