You can use the is_member('AD GROUP NAME') function to determine AD group membership.

Thanks Lori,

I had the need for this functionality recently. I tried using AUDIT as well as sql TRACE, but I was being too selective in my choice of the...

In my opinion, filtered indexes are one of the unsung heroes of 2008+. They can significantly reduce IO when the column is part of an oft-used predicate.

As previously mentioned,...

One of my team members hit this today will updating statistics. He got around it by creating a new table and loading the data in it (SELECT/INTO).

A DBCC checktable...

Clearly written article. You just saved me a bunch of testing.

I'm deleting a M records from a table that is a FK to other tables that are equally large....