Just noticed this when I was putting this on a new instance, but in the .sql file the WITH starts with a leading ;, which actually breaks the...

My ex-wife just started working from home the middle of last week.  I helped her set up her home office space. Her computer from work is a cute little Dell...

Looking at the table you are creating I have to agree, this is not a Hub table in the DataVault methodology. A HUB table will have the natural business key;...

Maximum length for a nonclustered index in SQL Server 2017 is 1700 bytes. Since you have not provided enough information it is hard to say what you problem may be. ...

• This reply was modified 5 years, 5 months ago by Lynn Pettis.

I am going to say that it depends.  To provide a better answer we would need to see the actual procedure, see the possible values being passed in to the...

We closed our office last week, everyone at home. Not a big change for some of us, but it is a change. Many things are less active...

Being divorced with grown children not living at home, I don't have that problem.

I started working from home last year and I like it to honest.  I do have the occasional distraction but it isn't hard to make up the time lost as...

Thanks for the links, and I agree.

Here is a new topic that we all should be thinking, learning, and discussing.

https://www.sqlservercentral.com/forums/topic/earn-it-act

Interesting, but I'd be wary of using it. In a multi-row update, the result is pretty much undefined, unless all the rows are updated to the same value. And...

as for the original topic of this forum. I've just wasted 30 minutes of oxygen to have to explain (after no details added) that emptystring is not the same...

Check this old blog: https://www.sqlservercentral.com/blogs/some-common-date-routines

To be honest, can't tell much from the picture of the execution plan.  Even though you can't fix the T-SQL (the best way to fix if possible), actually seeing the...

That's some bad code there Mike.  I've seen some similar, but add a couple UNION statements and all with in an SSRS report.  Talk about...