Here's a page that will help if you're getting the line length exception mentioned throughout this thread.

https://hashcat.net/wiki/doku.php?id=example_hashes

As noted by others, SQL 2005 and SQL 2008 require the -m parameter to...

Le poisson d'avril. And that it's a time-based joke is so apropos.

Here's a complete test suite, Jeff. Steps 1 and 2 only need to be performed once. Step 3 you can tweak and run over and over to suit your needs....

Agreed, Jeff, about the mindset. Simpler syntax does not equal better performance. But in this case, I believe that I'm on the right track. Look at the test results I...

OK Jeff, I took the challenge. I loaded 1,000,000 employees into the table with your script. Then I saved Chuck's procedures using his original names and my own (with a...

@tmarkham1 - I taught programming languages in college for 11 years and loved every minute of it. It was hard work but I found that I learned as...

Great points, Miika. In my experience with terabytes of hierarchical data in my system, recursive CTEs are faster, especially when going down the tree. Going up creates a single "thread"...

Jeff, the while loop-based approach works well if you have a few thousand records or less. And for employee data, that design is likely to provide sufficient performance. If you...

The recursive CTE of these procedures is much faster on large data sets. Easier to grok, too, IMO:

CREATE PROCEDURE [dbo].[usp_Employee_Select_Down_Param_EmpID]

@selectEmpID INT = NULL, -- NULL = all

@maxSupLevel INT = 10...

I read somewhere that nearly half of French men carry a second mobile phone to hide their other life from their families. I'm not dissing French people but if that...