Analytic Functions – PERCENTILE_CONT / PERCENTILE_DISC
This post is part of the series discussing the new Analytic functions in SQL Server “Denali”, CTP3.
Analytic Functions in SQL...
2011-09-22
11,772 reads
A Discussion of SQL Server-Related Topics
Analytic Functions – CUME_DIST / PERCENT_RANK
This post is part of the series discussing the new Analytic functions in SQL Server “Denali”, CTP3.
Analytic Functions in SQL...
2011-09-20
5,441 reads
Presenting Banish RBAR! to Hampton Roads UG
On Wednesday, Sept 21, 2011 at 6:30pm EST, I’ll be presenting Banish RBAR! to the Hampton Roads SQL Server User...
2011-09-19
638 reads
Analytic Functions – FIRST_VALUE / LAST_VALUE
This post is part of the series discussing the new Analytic functions in SQL Server “Denali”, CTP3.
Analytic Functions in SQL...
2011-09-15
4,026 reads
Analytic Functions – LAG / LEAD
This post is part of the series discussing the new Analytic functions in SQL Server “Denali”, CTP3.
Analytic Functions in SQL...
2011-09-13
3,415 reads
Analytic Functions – Overview
?This post is the first post in a series discussing the new Analytic functions in SQL Server “Denali”, CTP3, and...
2011-09-13
983 reads
Presenting Banish RBAR! at Richmond SQL UG
On Thursday, Sept 8, 2011 at 6:30pm EST, I’ll be presenting Banish RBAR! to the Richmond SQL Server User Group....
2011-09-07
687 reads
Presenting at Curacao SQL UG
On Thursday, Sept 1, 2011 at 7:15pm EST, I’ll be presenting via LiveMeeting to the Curacao SQL Server User Group....
2011-08-31
1,655 reads
Running totals in “Denali” CTP3
One of the things that I’m the most excited about in “Denali” CTP3 is the enhancements to the OVER clause....
2011-08-23
780 reads
ORDER BY Clause with clustered index
One thing that I have seen repeatedly is that (too) many people believe that if you have a clustered index...
2011-08-20
1,967 reads
Blogs
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
4 CPE Opportunity (Virtual) for Charity
By Brian Kelley
Every year, the South Carolina State Internal Auditors Association and the South Carolina Midlands...
Data Céilí 2026 Call for Speakers!
Data Céilí 2026 Call for Speakers is now live! Data Céilí (pronounced kay-lee), is...
Forums
Deadlock graph anomaly
I've come across what appears to be a strange deadlock anomaly. As seen in...
Stairway to Azure SQL Hyperscale Level 6: Backup and Restore Internals
Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...
The Challenge of AI
Comments posted to this topic are about the item The Challenge of AI, which...
Question of the Day
Deprecated Feature Tracking
From T-SQL, without requiring an XEvent session, can I tell which deprecated features are being used on my instance?
See possible answers