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,754 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,431 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,956 reads
Blogs
The trade-offs associated with low-code solutions
Low-code solutions often accelerate development and make tasks accessible to people who can’t or...
Monday Monitor Tips: Looking Back in Time
By Steve Jones
Often we find out about a problem reported by a customer after the incident...
Can You Tell Why a Plan Didn’t Go Parallel?
Let’s face it, most of the time, you probably don’t want your SQL Server...
Forums
Is there a way to determine an Azure Data Factory Trigger's "next run time"?
Many job schedulers (e.g., SQL Agent, Airflow, Azure Logic Apps) can report when a...
The Table Backup
Comments posted to this topic are about the item The Table Backup
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Question of the Day
The Table Backup
I run this code in SQL Server 2022. What happens?
BACKUP TABLE beercount TO DISK = 'beercount.bak'See possible answers