Hi and welcome aboard, Robert.

Understand that your reply looks like a "prelude to spam" that spammers regularly use to see if they successfully got a working...

A bit of a sidebar... I almost always avoid both EOMonth and anything else that is used to calculate the last day of the month because so many people forget...

Sorry... not enough coffee yet.  Misread some code and removed the post.

And I totally agree with Johan... avoid Scalar UDFs at all costs.  They even prevent parallelism if you do...

Thanks for the reply.

Weird that this is somehow not more public knowledge since the problem seems to be pretty impactful and somehow mentioned "no where" in most (popular) google...

Referring to the following page, search for the number 128.  It turns out that's a threshold and its 128 extents.  Since an extent is 8 pages and there 128 of...

Great "Decoder" post.  Thanks for taking the time to put it together, Steve.  You're the best!

Joining in the "Decoder" fun, decode this. 😀  Folks like Lynn Pettis will have no...

Hello Johan.

I have a couple of Scalar Functions that are sub-second.

1 that I use every day passes an IP Address/Subnet in and returns a human friendly site name by...

Thanks for the feedback, Thom.  I appreciate it.

Also, if you need something "right away", they do have a previous presentation of mine on the subject.  I have a couple of "mis-speaks" that I made during the "heat...

So, just to be sure, "Component N" and "Region" can actually be anything, correct?  And the goal is to assign the "N" of "Group N"?  Do the requirements of "Group...

1.  Always ( indeed ) start with Data Migration Assistant
2. Fresh Hardware / fresh OS / Latest SQL Server version and CU over in-place upgrades. Hands down. It...

Thanks, Thom.  It sounds like you've had some good experiences with SSIS.

A little bit off topic, if you good folks don't mind... I am curious about good experiences in SSIS...

I'm thinking that I'm not understanding much either. 😀

You probably don't actually mean "Hierarchical"... you just mean you have some relational tables, correct?  If that's the case, and ERD might...

Let me give more context on this. I am trying to identify if multiple components have been purchased by customers (Sales>0) in Last 4 quarters and then on basis...

Table looks right but I don't know why you resist providing the information I asked for.  You didn't include the BULK INSERT I asked for. 🙁

No matter though.  I made...