SQL Window Functions Series: RANK() and DENSE_RANK()
Welcome to the fascinating world of SQL window functions! Today, we'll explore in detail: RANK() and DENSE_RANK().
2023-11-20 (first published: 2023-11-15)
11,287 reads
sql commands
MSSQL Server AlwaysON: Get alerted for inconsistencies in logins, jobs and databases
This script will create the necessary login and linked servers on a given availability replica. Please ensure that the script is executed on all the replicas.
2022-02-22 (first published: 2022-01-25)
7,651 reads
Blogs
2 Tips to a Working Schedule
By Brian Kelley
When I watched the following video from Justin Sung, I realized that I am...
Monitoring SQL Server Performance with the Pure Storage FlashArray OpenMetrics Exporter
I’m excited to share a new open-source project I’ve been working on that combines...
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....
Forums
Why Clone Fails: Discovering the Hardware Beneath Azure SQL MI
Comments posted to this topic are about the item Why Clone Fails: Discovering the...
A Well Deserved Break
Comments posted to this topic are about the item A Well Deserved Break
Multiple Defaults
Comments posted to this topic are about the item Multiple Defaults
Question of the Day
Multiple Defaults
In my SQL Server 2022 database, I run this code:
ALTER TABLE dbo.OrderHeader ADD ModifiedStamp DATETIME CONSTRAINT df_Created_Getdate DEFAULT GETDATE() GOI decide I need to add auditing to another table and run this:
ALTER TABLE dbo.Tracker ADD Created DATETIME CONSTRAINT df_Created_Getdate DEFAULT GETDATE() GOWhat happens with these statements? See possible answers