Very well put!

What I just don't get, is how something this catastrophic made it through any testing at all.

Does this only apply to SS 2017?

I use Express in several production environments. Some are mission critical. Like everything else in this world, it has it's place.

A couple of instances also include some clr assemblies...

Very nice article. I was especially pleased to see the mention of Entity Framework. I'm not a full-fledged DBA. I refer to myself as a database developer, handling both ends,...

I'm probably using the word contiguous very loosely. In any case, my modification of Luis' solution does just what I need with good performance.

All true, it just wouldn't be practical to post the whole picture. Performance is good. 2 seconds on nearly 500,000 rows and it typically would not be run on that...

Luis,

Thank you. You gave me the jumpstart that I needed. Here us what I ended up with:

SELECT

CLG.lot_OwnerID,

L2.lot_nbr AS lot_nbrFirst,

L2.lot_suffix AS lot_suffixFirst,

L3.lot_nbr AS lot_nbrLast,

L3.lot_suffix AS lot_suffixLast

FROM

(

SELECT...

sestell1,

Thanks for the quick response.

The only grouping is on lot_OwnerID, but they need to be contiguous groups. So there will be multiple groups for each lot_OwnerID. Or maybe we...

Question for Lee Forst:

You say the XML approach was slow over 1000 rows and you rewrite. What approach did you end up using, and how was the performance?

Great article. Fits in with a project that I am working on.

Just to try it out, I ran as script on my development machine (SQL Server 2005) without creating the...

I found the same problem. When the first of the month is the day in question, it returns the second week. I modified it to this.

DECLARE @DATE DATETIME,@GETDATE DATETIME,@MONTHSTDATE DATETIME,@STARTDATE...

Thanks for the response Dwayne, especially with the problems you had. I had trouble just getting to this forum today.

I had the host check and both reports and reportserver are...

Thanks for the reply Michael.

I had seen the first article and had the host apply it, which did not help.

That is what made me think to sign my http handler...