In sysindexes there's a GROUPID, which is hte filegroup ID, you can join that to sysfilegroups to get the name of the filegroup. Not sure you can get to the...

I'd use an int identity column and then a computed column or a view that concatenates them.

You can't do a varchar auto-incrementing field.

It is the same precision, but can you get

7:00:00.000

7:00:00.000

7:00:00.003

7:00:00.003

7:00:00.007

7:00:00.007

On my desktop (dual core, 2GHz), I get:

.200 (repeated over 100 times)

.310 (repeated, difference of 110ms)

.373 (repeated, difference of 63ms)

.467...

Maybe ascii(substring(field, 1,1))

Very nice, Denis. I like the waterfall and beach pictures.

OK, I've confirmed it's a login thing. So if you have a login, you can leave a comment.

When we put this up, the synch wasn't there and since then, we've...

Just an FYI, this wasn't me. Ted Pin wrote this one and I thought it would be a nice editorial.

I hope I'm a better DBA and writer than musician....

I'll have to check Too tired to dig in tonight, but I thought comments were enabled.

Those are the only kinds of questions we can do without an interview.

That's why the interview is important.

The QOD can't cover every condition. It's designed in this case to see if you understand SUBSTRING rather than picking the best way to do things.

I enjoyed this when David sent it in and hoped it would be received well.

Perhaps all this attention will get Mr Poole writing a bit more. He's good at it...

I don't think partitioning requires much other than thinking about how you're partition later (dates, numbers, etc).

Replication is more granular and you have to be sure to replicate every table...

Every user that connects can execute the applicaiton role. As AJ mentioned, the password is the only thing you need. Users aren't added to this role.

Use a subselect

select distinct (location)

from (select a, b, c from table) a

Also you shouldn't grant permissions to users. You should make roles, even if it's 20 roles, and add the users to the role. Then grant permissions to the roles.