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%%
Hi I am working with SQL Server Database and BI (SSAS, SSRS,SSIS) since last 8 years with some of worlds large databases. Cheers Amish Shah
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
Lets see how to install it.
First go to help -> Manage Help Setting
Subscribe to:
Posts (Atom)
Popular Posts
-
sp_addlinkedsrvlogin To modify or add new login for linked server
-
Recently we had hardware and performance issues on SQL Server,with our client , so while monitoring the system we also looked at error ... -
Recently I got a problem where Builtin\Administrators Account was deleted . How can we recreate it? Here is a solution for this Run th... -
As we all are aware with the variables in SSIS, which is used for holding custom values and assign to various properties of objects at run...
-
Recently I got a mail for following problem While the client tries to open registered server window in Mbanagement Studio he gets follow... -
Various way to calculate running total from All period to currentmember As MDX is a very vast and dynamic language we can write same quer...
-
Many time we need to do runing sum of value. In SQL 2oo5 we can do it with use of CTE -
sp_purge_jobhistory We can use this procedure to delete old history for jobs.
-
For every Developer and DBA index maintenance is very important task. Since the changing ...
-
Index are very important part for any database. We need to regularly monitor index and maintain index for better performance of the system...