@arunleoprakash, our queries are looking for different things. The ScanCount column in my query...

Agreed, sequelgarrett. It seems as though with that point, the author is assuming you will use

SELECT *

FROM [viewWithTooManyColumns]

...but if you instead use

SELECT SomeColumnIReallyNeed, SomeOtherColumnIReallyNeed

FROM [viewWithTooManyColumns]

...then the generated...

Very useful for finding the most recent transaction per Account (or customer, facility, etc., etc...)

;WITH [transxRows] AS (

SELECT *,

ROW_NUMBER() OVER(

PARTITION BY [AccountID]

ORDER BY [TransxTimestamp] DESC ) AS [RowRank]

FROM [Transx]

)

SELECT *

FROM...

I know this thread has been quiet for a while, but I came across it while trying to do a similar thing myself. If sys.dm_db_index_usage_stats tells you that an...

My two pro-schema arguments are the standard ones, but hopefully my explanations are helpful to somebody...

1. Organization

Before schemas, the database was the only container for objects (unless you used owners...