If you want just the month name, SELECT FORMAT(getdate(), 'MMMM')

But ideally you would return the date as is and format it at display time.

Yes you can create a non clustered index on a heap, and yes(depending on the query/indexed and included columns) it will help.

What I'm amazed about is the attitude surrounding software projects especially from large companies like MicroSoft.  What ever happened to the idea of "Putting your best foot forward" instead...

At a certain point it becomes a question of effort vs reward.  How many things is it worth trying to parameterize that will almost certainly never be used?  Does it...

When we got our WFH authorization the expectation was made pretty clear.  Work from wherever you want and in whatever conditions you want as long as you can meet goals. ...

Perhaps, but I'm not sure that's the case. A lot of things we thought were private in the past, actually weren't private. What happened was the data was too...

Well what is the mechanism you're using to do the inserts?  That would give us a better idea of what options you have.

Load your list of customer no's you want to look up into a table and do something like WHERE cus_no IN (SELECT  cus_no FROM cus_no_stg)

Just yesterday, I had to troubleshoot an issue where CPU was pegged at 99%, and I determined the bottleneck to be a high volume query executed by the...

Does anyone else find the questions you just plug into SSMS boring?

Babylon 5 and Deep Space 9 were the sci fi I grew up with, I guess I preferred the more politic/relationship/broad arcing stories over other shows like TNG.

Really hoping they...

The proper order of precedence if that comes up in a code review is a slap to the face then you rewriting it.

I don't - I stated there is a time zone *offset* requirement.  If you don't have the...

I'm still not sure why you think there is a timezone requirement.

I'm saying that there's a number of ways to get timezone without using a datetimeoffset and for that matter without even storing timezone itself because that information can often be...