SQL Server database engine doesn't have a MEDIAN() aggregate function. This is probably because there are several types of median, such as statistical, financial or vector medians. Calculating Medians are essentially a row-positioning task, since medians are the middle value of an ordered result. Easy to do in SQL? Nope. Joe Celko explains why.
2009-05-06
2,024 reads
2009-05-05
4,788 reads
2009-05-04
4,503 reads
Reports all running requests along with the request's identifying information (SPID, login etc), current resource consumption, query batch text, statement text, and XML query plan.
2010-05-24 (first published: 2009-05-01)
5,302 reads
2009-05-01
4,496 reads
2009-04-30
4,062 reads
2009-04-29
4,506 reads
2023-07-18 (first published: 2009-04-28)
3,761 reads
2009-04-28
3,729 reads
This article discusses a common mistake while making date comparisons in T-SQL and its resolution. From new author Manish Sinha.
2009-04-28
16,068 reads
By Steve Jones
As a part of the Book of Redgate, we have a series of (red,...
I recently had a new pipeline fail. It was actually a copy of an...
By Chris Yates
Microsoft Fabric is transforming real-time analytics for financial institutions. It provides a unified data...
This is one of those things very hard (for me)to explain in words. See...
Comments posted to this topic are about the item Feeling your age? How would...
Hi, one of my server configured with Standard_D64ds_v4 what is next level of version...
Can I rollback a cumulative update and remove it from my SQL Server instance?
See possible answers