Very useful script. It would be nice if it didn't consider users created from certificates as orphaned.

Does anyone have a query to extract the contents of from the blocked process report? I have thousands of blocked process report rows; I need to analyze...

Which are the "3 days dedicated to only SQL Server information"? Tuesday - Thursday or Wednesday - Friday? I would want to leave Thursday evening for personal reasons...

Thanks gentlemen! I appreciate the insights.

To clarify my question consider the following index. In this following example, let's say ClientID is unique. (the table is clustered on a different column).

CREATE NONCLUSTERED INDEX [IX_TableX_ClientID] ON...

Would you please comment on the following? Let's say the first column or columns of a nonclustered index is unique. Might there be reasons to add additional columns...

Well, I got recklessly bold and replaced all the indexes that started with the primary key column with a single index that included all the columns in those indexes. ...

I just noticed something. Although as I noted earlier...

SELECT * FROM UploadedFiles

WHERE Deleted is null

For this query the estimated plan shows a plan based (accurately) on many rows...

I was inclined to agree that the statistics do not include null values, but I checked a couple query plans.

1)

SELECT * FROM UploadedFiles

WHERE Deleted = '10/1/2007'

For the above...