Imo the issue with assigning value(s) to variable(s) and then using variable(s) to resolve flow of control is it can create race conditions.  Then database serialization is attempted to hold...

Volumes are better, especially across time. Getting a consistent set of emails across time is good.

Your posts here (forwarded) did get a meeting set and some movement on upgrading...

It's tl;dr with the data.  The real questions are: 1) what is your data access pattern,  and 2) how are you handling identity and access management?

Maybe you're looking for rows WHERE the SkidStatus and the LEAD SkidStatus are unequal within a common row key partition.  In this case left(SKIDNUMBER, 10) effectively truncates the _NOTAPPLICABLE suffixes

The issue here is although there is an apparent pattern there are no constraints on uniqueness other than the surrogate key ID.   The query you're suggesting to write creates a...

Also a few other potential issues.  If there are any gaps in the depth measurements this method won't fill them in.  Also if there are equal thicknesses this method will...

To get the thickness calculation correct it needs to account for the boundary conditions.  Instead of expanding across the entire sequence and then joining (with inequalities) to the resultant intervals...

Thanks Phil.  Interesting maybe.  The real answer is don't use cursors 🙂

Why not store the user's default in the users table?

split the recipe into two parts in the CTE. Part 1 is all the ingredients, weights for everything except the starter UNION ALL (For each ingredient in the Starter,...

A data model to store the recursive relationships and to resolve them with a common table expression could include tables: ingredients, recipes, recipe_inputs, recipe_input_ingredients, recipe_input_recipes.  With recipe_input_recipes you could store...

Out of curiosity, our 2017 box shows a CPU cap of 25% with 4 CPUs which leads me to believe that it's not able to use all 4 CPUs...

Excellent query Jeff.  Thank you, thank you!  Multiplying by 'combo' within the TOP clause is very nice

Well maybe the allocation is unavoidable.  I was hoping for pixie dust or a magic trick 🙂

It's difficult to know much based on the explanation.  The SQL code provided isn't valid SQL Server syntax (afaik) and appears to be embedded strings for which the parameters are...

• This reply was modified 2 years, 5 months ago by Steve Collins.