Viewing 9 posts - 31 through 39 (of 39 total)
Very useful script. It would be nice if it didn't consider users created from certificates as orphaned.
September 24, 2008 at 10:31 am
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...
June 17, 2008 at 8:00 am
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...
May 15, 2008 at 4:00 pm
Thanks gentlemen! I appreciate the insights.
December 3, 2007 at 11:49 am
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...
December 3, 2007 at 11:00 am
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...
December 3, 2007 at 10:42 am
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. ...
December 3, 2007 at 10:14 am
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...
October 30, 2007 at 9:57 am
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...
October 30, 2007 at 8:31 am
Viewing 9 posts - 31 through 39 (of 39 total)