Guys,

As usual - the amount of difficulty never disappears...

Surrogate keys are excellent for Referential Integrity - small PK / FK.

The default of having PK as a clustering one is a...

Guys,

The subject in discussion is not practical in an application development domain for obvious reasons.

From the perspective of DBA/Consultant I can imagine (HARDLY) that sometimes it would be interesting /...

My tests do not show any _WA_ :w00t:

Stats? I think it would be a good practice to update stats every so often. This is outside the scope of moving indexes... Mmmm?

The complete version for SQL2005/2008 is below. It includes schema... plenty of monkeys use multiple schemas..

Enjoy.

SET NOCOUNT ON

DECLARE

@table_schema_name nvarchar(128),

@table_name nvarchar(128),

@index_name nvarchar(128),

@key_ordinal smallint,

@column_name nvarchar(128),

@sort_order varchar(50),

@is_included_column int,

@index_type_desc varchar(50),

@unique_type varchar(50),

@ignore_dup_key varchar(50),

@fill_factor tinyint,

@is_padded varchar(50),

@allow_row_locks...

Guys,

BI implies presense of both - business AND intelligence...

Decision Support Systems - BI in new speak - is as old a concept as computerised data itself. There are plenty of...

Conceptually, databases are to store and retrieve data - that what they do best.

Having "ability" doesn't mean you have to use it. As a DBA and developer, I strongly discourage...