Kamil Moscicki

High-Performance Transact-SQL with Window Functions

Window functions are more intuitive and simpler in many cases than alternative SQL methods.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(34)

You rated this post out of 5. Change rating

2013-12-02

8,783 reads

A fugitive cyber-criminal, a wingsuit, and 24 million flight records. Somewhere between Doha and...

Say you need outside help. You’ve exhausted all the things that you could do...

I’m honored to announce that I’ve been renewed as a Microsoft MVP for the...

Comments posted to this topic are about the item Implicit Conversions Cripple SQL Server

Comments posted to this topic are about the item BIT_COUNT() III

Comments posted to this topic are about the item The Mythical Bus Accident

In SQL Server 2025, I run this code:

select bit_count(-1)

What is returned?