In SQL Server there are 4 different ranking functions: RANK, DENSE_RANK, NTILE, and ROW_NUMBER. These ranking functions were introduced in SQL Server 2005. In this stairway level I will be reviewing each of these different ranking functions, and will show you how to use them by providing a few examples.
Microsoft announced Azure Synapse Link for SQL. In this article, MVP Dennes Torres explains the new feature.
Headquartered in Louisville, Kentucky, Republic Bank is one of the most innovative and forward-looking banks in the US, with 42 full-service banking centers across five states and assets of $6.2 billion. Find out why they chose Redgate SQL Monitor.
Learn a little basic graph theory in this article that replaces a GROUP BY clause.
SQL Server Central Editor, Steve Jones is joined by a panel of industry experts from around the globe to discuss their experiences with digital transformation, and the impact it had on themselves, their teams and the wider organization.
In this article we look at how to import and export connection information for servers in SQL Server Management Studio for backup and to move to another installation of SSMS.
Tagging is important to keep track of resources in the cloud. Today Steve asks how you approach this topic.
By Steve Jones
I was renewed this week as a Microsoft MVP. This is my 15th award...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Comments posted to this topic are about the item Establishing a Connection to PostgreSQL...
I have files in Blob Storage that I'd like to copy over to a...
Meta data in Log shipping tables are not updated in msdb when i checked...