Best Practices for SQL Server Tempdb

I will take your tempdb’s peformance to new heights by making a few adjustments to the standard database settings.   What Happens in SQL Server’s TempDB? Temporary user objects that are explicitly created, such as: global or local temporary tables, temporary stored procedures, table variables, or cursors. Internal objects that are created by the SQL […]

Read More »

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 »