Btw, yes, PRINT is exceedingly slow. Use it only when absolutely necessary.

ChrisM@Work (9/14/2012)

It's quite common for a product to "evolve" over time without its' stock code changing - it's rampant in the fashion world. Clients, agents, reps all know an item...

stanlyn (9/13/2012)

---

Hi Scott,

Running your script, it returns:

Which begs the question on why the Page table has 3 PK_Page_Identity indexes, as it should have only one. That's the only thing...

Is the PK also a clustered index?

Is the identity column used in any another index?

Please post the DDL for the filtered index.

Perhaps, perhaps not. But is that a good way to do it, regardless of how common it...

You can use this to check for files that still exist in a given filegroup(s):

SELECT

FILEGROUP_NAME(a.data_space_id) AS File_Group,

OBJECT_NAME(p.object_id) AS Table_Name,

...

SELECT

Item,

MAX(CASE WHEN [Group ID] = @group1 THEN Permission ELSE '' END) AS Group1_Permission,

MAX(CASE WHEN [Group ID] =...

Lynn Pettis (9/13/2012)

---

ScottPletcher (9/13/2012)

---

but if you are creating a table of product groups (<'BK','Books'>,<'SH','Shoes'>,<'BG','Bags'>) etc.. I would put an ID field on that and use that instead, otherwise if someone...

but if you are creating a table of product groups (<'BK','Books'>,<'SH','Shoes'>,<'BG','Bags'>) etc.. I would put an ID field on that and use that instead, otherwise if someone decides they need...

A company I worked for produces clothing catalogues. Each catalogue has a 2 character reference. They produce about 130 catalogues/adverts a year, but not all letters get used...

Eugene Elutin (9/12/2012)

---

Greg Snidow (9/12/2012)

---

Jeff Moden (9/12/2012)

---

It's even more annoying when you need it and it's...

Sean Lange (9/13/2012)

---

ChrisM@Work (9/13/2012)

---

ScottPletcher (9/12/2012)

---

There is NO case where I would ever want to use a GUID as a clustered key column.

It would have to be THE ONLY WAY POSSIBLE...

I think maybe you can save a little overhead by checking for the known difference expected in the result, naturally including the next-higher value as well to allow for "borrowing"....

GroupID as classified by the Resource Governor for the current session.

There is NO case where I would ever want to use a GUID as a clustered key column.

It would have to be THE ONLY WAY POSSIBLE for me to consider...