The SQL Professor

Blogs

Sic Transit Gloria Community

By

When Covid took out the PASS organization, I had someone say to me, “Well,...

DATEADD Truncates the Number Parameter: #SQLNewBlogger

By

This was an interesting thing I saw in a Question of the Day submission....

Our SQL Server is Slow! What Do I Do First?

By

Don’t Panic! It’s a vague but common complaint, frequently with no additional details. Before...

Read the latest Blogs

Forums

Dynamic T-SQL Script Parameterization Using Python

By omu

Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...

ExecutionLog3 table in Reportserver Database

By cooldude001

I have a SSRS report for which users are complaining to be slow, but...

SQL Server Maintenance Plan Feedback

By water490

Hi I set this up today.  I wanted to get some feedback.  I have...

Visit the forum

Question of the Day

Counting Bits IV

What do these two selects return?

SELECT BIT_COUNT (CAST (-1 as smallint))
     , BIT_COUNT (CAST (-1 as bigint))

See possible answers