Here's the query:

SELECT  [T].[name] AS 'TableName',
    .[name] AS 'IndexName',
    .[is_primary_key] AS 'IsPrimaryKey',
    .[is_unique_constraint] AS 'IsUniqueConstraint',
    .[is_unique] AS 'IsUnique',
    [DDIUS].[user_seeks] AS 'UserSeeks',
    [DDIUS].[user_scans] AS 'UserScans',
    [DDIUS].[user_lookups] AS...

Sometimes, 'the book' gives you the right to say no. However, the fourth or fifth time you say no, aren't people going to start to bypass you? If I were...

Yes it did, thanks for pointing this out.

I had to experiment a little bit to figure out what was going on. Two of the columns in the original table were...

Alan.B (2/17/2016)

---

Implicit conversion is treating your '' value as a zero and making the column a numeric column. When you query a numeric column:

WHERE Column3 = ''

is the...

Thanks to everyone who replied for your input. It helps to have a community like this as we battle the misunderstandings and misinformation around SQL Server.

This is very helpful. Thank you.

Yes, that's what...

This is something I have a question about....