Tags » Microsoft SQL Server

Difference between Stored Procedure and Function in SQL Server

Basic Difference

1.Function must return a value but in Stored Procedure it is optional( Procedure can return zero or n values).
2.Functions can have only input parameters for it whereas Procedures can have input/output parameters . 222 more words

Microsoft Sql Server.....

Feb 2016 Tip of the Month - New function in SQL 2016: sys.dm_exec_function_stats

SQL Server Performance Tuning:  New function in SQL 2016: sys.dm_exec_function_stats

Returns performance statistics for cached functions. Returns information about scalar functions, including in-memory functions and CLR scalar functions but not about table valued functions. 166 more words

SQL Server

Blogger questions: What if someone else wrote about the same subject?

I have a moderately popular blog. In part because I syndicate but largely (in my opinion) because I write a lot of posts (twice a week for > 3 years). 481 more words

Microsoft SQL Server

Update to my "Robust Posh Script to Delete Files" Script

I have made a modification to my “Robust Posh Script to Delete Files” scripts so that they will only delete actual files in the specified path, and not folders. 32 more words

Microsoft SQL Server

Running code on the startup of SQL Server

Every now and again you need to run code when your instance starts up. For example you might want to check if the SQL Agent is running. 339 more words

Microsoft SQL Server

SQL Server 2012/2014 Extended Events for Developers - Part 1

— By Jeffry Schwartz

Microsoft introduced Extended Events, a.k.a. XEvents, in SQL Server 2008 to aid in the analysis of performance problems. Both the capabilities and syntax were changed… 1,872 more words

SQL Server