[Note from Pinal]: In this episode of the Notes from the Field series database expert Mike Lawell explains about Live Query Statistics in SQL Server 2016. Statistics are heart of SQL Server. They play a very powerful role when SQL Server Engine needs help to build a new execution plan for a query. In earlier version of SQL Server we had the only privilege to see statistics after the query is executed. However, with the advancement of SQL Server 2016, the scenario has been changed. Here is a very interesting new feature of SQL Server 2016 which can help every performance tuning expert. Read the experience of Mike in his own words.
SQL SERVER – Working with Event Viewer and PowerShell
Sometimes I go into these simple explorations that make me learn something new that gets me off the routine. SQL Server is always on the agenda and that passion will never die. This exploration was based on the fact when I was talking to someone about some of the super…
Read MoreInterview Question of the Week #053 – What is the Difference Between Deterministic Functions and Nondeterministic Functions?
Some questions are so theoretical that I believe they really do not add too much value if users know that question or not. Here is one such question I am very confident that you agree with my point of view. Questions: What is the Difference Between Deterministic Functions and Nondeterministic Functions?…
Read MoreIt’s a New Year, Take Advantage of It – Notes from the Field #110
[Note from Pinal]: This is the first episode of Notes from the Field series in the year 2016 and 110th overall. There is one place where I see the maximum crowd in the new year – fitness center (gym). It is indeed a good thing that we all want to…
Read More