I vote for NULL. We  really don't know that are the last 4 digits and unknown is NULL. We should not assume that the numbers will be 3333. As a...

I guess you have  to read that in English:  ! is Not,  <  is Less, so !<  is Not Less than

Great Question!

3 alternative ways for your mind entertainment

1. Use sp_send_dbmail  to send an email  with the size question to your Windows administrator 🙂
2. 2. Use DriveInfo class class to create a...

Great question, Steve!

I have tested a few things and theoretically your expression should have worked as it is a combination of the following 2 expressions that work

SELECT CAST(0x7e AS Int) ...

Just tried that in Python, in Jupyter Notebooks

print(-100.0/-100.0*10.0)

The output is 10.0

Also tried in Excel entering in the Formula bar

=-100.0/-100.0*10.0

The cell contain the value of 10. Excel is a Microsoft product...

Without minus signs the expression would evaluate to 10 as division and multiplication are equal in the order of execution.  Plus and minus are to follow.

I do understand the explanation...

Steve, wonderful question!

Funny story: Years ago when I created a ticket with a vendor of one of the industry leader CRMs that one view in the UI did not have...

Shannonry, I don't have a BOL link, but in Management Studio do:

View - Registered Servers

Right-click on local server groups and select New Server Group, give it a name

Right-click on the...

Shanonry,

You can define  a multi server query  (registered servers) and run the query only once.

The article is awesome!

This feature is like an online version of the linked server minus updates.

Excellent article!

Disk quotas can work! I like this idea.

I also read about File Screening, that can limit the file types that can be saved on disk. For example we can specify...

Hi,

I suggest another approach in SQL Server 2008.

Please try using Audits. They are under Security in SQL Serfver Management Studio. It takes just a few minutes to create. Then you...

Check a few things;

- If your SQL Server is set up to audit failed logins, check SQL Server logs what was the error message. If not, run profiler to capture...

I don't know what the particular warnings come up for your package, you have to evaluate the warnings and determine if they are relevant or not.

My advice is to take...