And also look for OS, emailing, etc. tasks - those must be either completed (success or fail - does not matter) or terminated before the process which initiated them could...

Thank you for your time to look into this question. I believe this part of the code is throwing an error.

SELECT DRIVE, SUM(CASE WHEN INFO LIKE 'TOTAL # OF...

Attempting to restart SQL Server instance is a quite common mistake so called...

Well THIS is annoying.

I have an SSIS solution / project saved that is set to DontSaveSensitive. All the packages under it are saved as the same. Last week, everything...

What is the data type and collation(s) used in existing table(s)?

Actually, Sergiy, for certain calcs -- such as computing interest on a house loan in some places -- it's illegal to use more than 4 digits of...

Second, you might use DATEDIFF (ss, ..) to find duration in seconds and then divide it by 60.0 to get duration in minutes with better precision.

or - you may use...

First of all, triagonal joins like you use in the query, are very ineffective and even quite dangerous, because they can produce huge result sets during execution and overwhelm the...

Actually, Sergiy, for certain calcs -- such as computing interest on a house loan in some places -- it's illegal to use more than 4 digits of accuracy.

So, if...

Yeah, I know, flat-earth believers keep to their views no matter what proof you put in front of them.

The main point is that others who read this thread could see...

No, not because of that.

It's because of the following factors:

1. Percentage is not a monetary value. It's what's they name a "ratio" in Latin. Therefore, it must be expressed in...

Phil is clearly wrong there.

Can you figure out his crucial mistake?

I don’t know anything about MONEY being an approximation.

can you give me a link to a source of such information, or a real life example?

as far as I know, and...

Steve, can you please elaborate on potential issues with converting VARCHAR to money, and what role float could play in it?

Looks like tempdb is mostly used for huge cache data sets of hash joins, Cartesian product joins, and sorting in tempdb.

Sorting usually happens in tempdb when there is no memory...