SQL Server Management Studio in a Multi-Site Cluster
Originally posted on Clustering For Mere Mortals:
If you set up a multisite cluster (nodes in different subnets), you will...
2015-07-22
752 reads
Originally posted on Clustering For Mere Mortals:
If you set up a multisite cluster (nodes in different subnets), you will...
2015-07-22
752 reads
Originally posted on Blog Home for MSSQLDUDE:
Not really a new part to my multi-part series on System Center for...
2015-06-11
511 reads
Originally posted on Blog Home for MSSQLDUDE:
I’ll start part 1 of the Microsoft System Center series, focused on what...
2015-03-30
980 reads
Originally posted on Blog Home for MSSQLDUDE:
My original posting on System Center Operations Manager for SQL Server DBAs start...
2015-03-30
620 reads
2014-12-07
1,044 reads
Originally posted on - Microsoft technologies and what I do for fun -:
Last year, as part of launching my very first...
2014-11-29
1,136 reads
Originally posted on Peter's blog:
If a user is a member of Sysadmin server role of SQL Server 2005, the...
2014-10-11
1,279 reads
As a DBA, it is perfectly normal to forget your password from time to time. No need to hold your breath...
2014-09-25
536 reads
Problem : Surely you have scheduled jobs to run DBCC CHECKDB across your SQL Servers to check database integrity. But sometimes...
2014-06-01
935 reads
Problem: From my previous post, we learned how to set up Data Collection in SQL Server. This is most suitable...
2014-05-21
594 reads
By Steve Jones
I had to demo the Flyway Autopilot system recently and created a GitHub Actions...
This is more complicated than using the Azure Migration method, but because it’s maxed...
I’ve covered how to create Elastic Jobs in the portal (this one is important...
Comments posted to this topic are about the item The Rank Window
Comments posted to this topic are about the item The End of Azure Data...
Comments posted to this topic are about the item How to Develop Solutions with...
I have this table and data:
CREATE TABLE [dbo].[SalesTracking] ( [SalesDate] [datetime] NULL, [SalesPersonID] [int] NULL, [CustomerID] [int] NOT NULL, [PONumber] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [paid] [bit] NULL ) ON [PRIMARY] GO CREATE CLUSTERED INDEX [SalesTrackingCDX] ON [dbo].[SalesTracking] ([SalesDate]) ON [PRIMARY] GO INSERT dbo.SalesTracking (SalesDate, SalesPersonID, CustomerID, PONumber, paid, total) VALUES ('2024-03-15 10:45:55.067', 1, 1,'PO965' ,1, 100), ('2023-09-24 10:45:55.067', 1, 2,'PO627' ,1, 200), ('2022-07-02 10:45:55.067', 1, 3,'PO6' ,1, 300), ('2022-11-03 10:45:55.067', 1, 4,'PO283' ,1, 400), ('2022-11-26 10:45:55.067', 1, 5,'PO735' ,1, 500), ('2023-04-28 10:45:55.067', 1, 6,'PO407' ,1, 600), ('2022-09-09 10:45:55.067', 1, 7,'PO484' ,1, 700), ('2024-03-13 10:45:55.067', 1, 8,'PO344' ,1, 700), ('2024-04-24 10:45:55.067', 1, 9,'PO254' ,1, 800), ('2022-06-19 10:45:55.067', 1, 10,'PO344',1, 800) GOWhen I run this query, how many unique values are returned for the SaleRank column?
SELECT st.SalesDate , st.SalesPersonID , st.total , RANK () OVER (PARTITION BY st.SalesPersonID ORDER BY st.total desc) AS SaleRank FROM dbo.SalesTracking AS st;See possible answers