My best gift is another year with my wife of 40 years whom twice doctors gave up for lost, but who has survived and overcome bilateral below-knee amputation to...

Unfortunately, I've seen that and more.  I've even seen people add trailing spaces to all of their object names to make it more difficult to use what they've built.  Crazy...

That's very true.  And, sorry...

Frederico, do you have any test case to support your speculations?

I (and I guess Jeff Moden too) would be particularly interested in a test script which demonstrates advantages...

I've not executed the code but it looks to me like they're trying to reject rows where the name has any spaces.

@smattiko83,

Do you also want the dates to be validated as "real" dates?

I have to import a text file to build a table and all of the date fields currently are in integer form. It comes in three different ways. The...

Good lord!!!  A SQL forum that doesn't allow you to upload .SQL or TXT files!  This is just silly.

Here's sp_ShowWorst... I've got to figure out how to do the other...

Max Memory capping is applied on the instance.

Total Available Memory : 32 GB

Max Memory configured : 26 GB

As far as I know, nothing additional running on the instance,...

Man... I'm sorry. I lost track of this thread and didn't answer your additional questions.

I guess my biggest question would be, did you stop using REORGANIZE or not?

I just had a sudden flashback to the two threads on "bankers rounding". 😀  I'll get the popcorn. 😀

p.s.  even that later definition (the one inferred by the supposed correct answer) may be incorrect.  We would also need to know if a partridge in a pear tree would...

This is where a good analyst would ask for a more explicit meaning of what constitutes a "gift" or "present" and how they can be taken as some as being...

Merry Christmas to you, as well.  I thought I'd be about the only one in the world to be posting today. 😀

Thanks for the feedback on the name-splitter function.  I...

You've just described the very nature of history/audit tables.  They are...