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,756 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,432 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
631 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,018 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,409 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
975 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
684 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,650 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
776 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,961 reads
Blogs
Teaching at the SC Statewide Audit Conference
By Brian Kelley
Instead of teaching the CISA exam prep course, I'm teaching in the IT track....
Upgrading SQL Server in a Container
By Steve Jones
I decided to update software on my laptop recently during a trip. I’m loathe...
SQL Server Editions: What’s the Difference and Why It Matters
By Kevin3NF
Understanding the Limits Before You Hit Them If you’re responsible for a SQL Server...
Forums
is there a reorg available in sql server?
hi i have a 67 million row fact table that needs about 30 million...
The Technical Debt Anchor
Comments posted to this topic are about the item The Technical Debt Anchor
Getting the Updated Column List
Comments posted to this topic are about the item Getting the Updated Column List
Question of the Day
Getting the Updated Column List
What happens when I run this code in SQL Server 2022?
UPDATE dbo.CustomerLarge SET CustomerContactFirstName = 'Andy' WHERE CustomerID = 1 SELECT COLUMNS_UPDATED()See possible answers