A mentor of mine many years ago told me that to move up in an organization two things have to exist at the same time.  One is an open position...

Here is an sql function implementation of the Levenshtein Difference function.   I am posting it with the statement that it is not my original code, but I am certain that...

This is an example of why every developer and especially every project manager should be required to read "The Mythical Man-Month" by Fred Brooks, subtitled Essays On Software Engineering. ...

This function will silently fail (no error msg) if the object you are searching for is new and does not yet appear in the object tree. Refreshing the...

Thanks for the script

Here's a minor enhancement

-- split data into size and filename

SELECT ROW_NUMBER() OVER ( ORDER BY Files DESC ) AS Row

...

Thanks for letting me know it not something I'm doing wrong

Both processor affinity masks are Autoset and max worker threads is 0 (let server determine)

Max Degree of parallelism is 0 and cost threshold for parallelism is 5 ...

In management studio object explorer, there is an option to filter which objects are displayed. The limitations I'm trying to get past are in setting up that filter....

Not getting into the discussion of the specific querys mentioned, but rather the general topic of the editorial. This erronious line of thinking is not exactly new, please...

Lynn - yes the parallel plan is listed as having a lower cost, however it doesn't.

Gail said to run the query in grid mode so that's what...

Here is it first with the hint then without hint

I'd be interested to see what happens if you tell the optimizer to not use parallelism if perhaps it then uses the non-clustered index.

could try adding this to the end...

I am not an expert in this, but couldn't the Index fragmentation and the fact that the query is trying to retrieve all columns make the query engine to...

OK here's the text version of the plans. If anyone can tell me how I can get the graphical version into the forum, I try

(FYI the plan text has...

To include single quotation marks in the text of an insert statement, you need to replace the single quotation mark with two single quotation marks. (NOT a double quote...