We've been using Teams for a lot of communication, but sometimes it's nice to get up and walk over to someones' desk, or turn the chair to chat with...

I guess I'm an odd ol' duck.  I don't need or even want F2F interaction with humans unless it's on a pool table in my favorite bar and...

Having a bit of a tough time yesterday and today remembering a good long distance friend and SQL heavy hitter.  It's hard to believe that it's been 5 years...

Just add your logic to a character column using 0 and 1 😉

😎

The ANSI/ISO standards specify an extra clause that goes after the order of the sort (ASC | DESC) which will let you decide the order of the nulls...

Start with Glenn Berry's scripts

😎

Why go for the...

Hi  all,

need your help on conversion of excel formula into case statement. i tried but missing only one case. below is excel formula:

=IF(AND(Q141="EndOfDay", AD141="EndOfDay",V141=""),8, MIN(8, IF(OR(Q141="EndOfDay"), 0, IF( AND(...

JC makes a good point, the ANSI/ISO has the extra clause of (NULL FIRST | NULL LAST), unfortunately, omitted by many vendors including MS.

😎

In SQL Server, NULL FIRST is implied,...

I'm trying to develop a formula to convert minutes (my raw data) to hh:mm:ss format. E.g.: 526.30 minutes = 31,578 seconds which should read 08 hrs. 47 minutes and...

There...

My next question is if Instant File Initialization is enabled on the databases?

😎

The next thing we will then look into are the running processes and memory usage.

Actually, in Assembler comparison of 2 values is implemented via deducting of one value from another.

So, if you intuitively replace comparison with deduction then it means that you have...

Regarding the accidental DBA, has no one seriously running into the anti-virus scanning issue? The more he posts, the more I'm convinced one of his servers is scanning the...

Accidental is indeed a gentle description. Looks like the OS is the same, and the file being loaded, and everything else differs.

Finish your coffee before taking a peek. Or...