How to create and call scalar function in a store procedure for SQL Server 2012

SQL Server;s functions are a valuable addition to TSQL when used wisely. I will show you a basic example how to use scalar functions. Let’s start with a definition: https://technet.microsoft.com/en-us/library/ms177499(v=sql.105).aspx     Scalar Functions User-defined scalar functions return a single data value of the type defined in the RETURNS clause. For an inline scalar function, there […]

Read More »

Best Practices Memory on SQL Server on VM

When achieving adequate performance is the primary goal, It is recommended to set the memory reservation 75% to the provisioned memory. You are wondering where I got the 75% Please read this wonderful blog post from my SuperHero Breant Ozar.  This will eliminate the possibility of ballooning or swapping from happening and will guarantee that the […]

Read More »