1

In Oracle we have RowID, gives Physical address of a record. Likewise we have %%physloc%% in SQL Server. What is the keyword for fetching the Physical location of a record in Azure DB.

Community
  • 1
  • 1
Gdek
  • 81
  • 4
  • 11

1 Answers1

1

Since the Azure SQL Database service is a PaaS (Platform as a Service) service, it abstracts out the need to care or worry about the physical disks that store your data. The service managing scaling everything in your database according to the pricing tier and DTU's you select. As a result of this there are no queries that can be performed to tell where on disk you data is stored. Also, there are no queries to specify where in physical storage you want Azure SQL Database to put your database tables and data. Azure SQL Database just manages all this for you automatically.

Chris Pietschmann
  • 29,502
  • 35
  • 121
  • 166
  • Thanks Chris. Let's say I'm having a record duplicated in the table. Every column is similar. I want to remove the latest record among them. We can use the RowID in Oracle. In same scenario with Azure, how can we handle? – Gdek May 02 '17 at 15:12