How get physical location of row.


Its undocumented command and gives physical location of the row.
This helps while doing advanced trouble shooting.
Its fun to get internals of MSSQL Server doing regular tasks.

First we will look at %%physloc%%

Table Valued Parameters


Table Valued parameters are user defined table types and used to pass multiple rows  of data  as input to procedure or function.  

Benefits 

* we dont need many parameters
* we dont need temporary tables
* We dont need XML to pass multiple values
* pass multiple values of different data types
* Enable client to specify sort order and unique keys
* SQL 2012 onwards table valued parameters are cached for all queries.

Books online for SQL Server 2014

Books online for SQL 2014 is now available
Lets see how to install it.

First go to help -> Manage Help Setting






Popular Posts