DBCC TRACEON

It claims it does, but seems to work only under certain conditions.

Not a lot to go on, but I'll take a shot:

SELECT col1, col2

FROM dbo.tablename

GROUP BY col1, col2

HAVING COUNT(DISTINCT col1) = (SELECT COUNT(DISTINCT col1) FROM dbo.tablename)

I would think that object name clashes would be a potential concern. If they occurred, resolving those could theoretically involve a LOT of work.

Tables with fewer than eight pages can see increased fragmentation when rebuilt, because SQL may spread the table across more extents.

Personally I don't like SQL's mixed extents, but I can't...

I can't see the attachment (security issues).

But in general you want to avoid using functions on columns, because it keeps SQL from using indexes (and likely stats) on that column.

For...

Sorry, I mis-worded my response.

I didn't see the need for the DealType in the Deals table, since it had its own table. Indeed, since its many-to-one, I don't how...

Table 1: Deals (PK DealId)

DealId int

DealTypeId int

Table 2: DealEvents (PK DealId)

DealId int

DealFamilyId (computed persisted '1')

Table 3: DealTypes (PK DealTypeId)

DealTypeId int

DealFamilyId int

I want to create a relationship between Table1 and...

Interesting. Thanks for the update.

A little confusing though, not sure what's going on there then. Thought originally it might have just been a mismatched name because of the...

On my SQL 2005 version and my SQL 2008 versions, it accepts sp_rename for that index name:

USE tempdb

CREATE TABLE dbo.nasty_index_name_test ( c1 int )

GO

CREATE NONCLUSTERED INDEX [<Name of Missing Index,...

What do you mean "doesn't work"? It won't even initiate the rename process?

If the tables have identity columns, you can use $IDENTITY as the column name.

If not, you might have to dynamically generate the code based on unique indexes on the table...

You can rename an index through SSMS; just backspace over the old name, and type in the new one.

No, not CPU (except perhaps a tiny amount periodically to check it for activity).

Connections themselves have some RAM overhead.

But since creating/destroying connections is...

User dbs will definitely work ok to a later SP.

Master will definitely NOT work; master MUST be exactly the same version.

Not sure about msdb, but apparently same rules apply as...