(Dallas Snider) How can I smooth the data in a column with a moving average in T-SQL? Can you please walk through an example in SQL Server with T-SQL code? How can we validate the results?

(Marcin Policht) As announced on June 1, 2016, SQL Server 2016 has reached its general availability. This means that you finally have the option to implement some of its new features in the production environment.

(Ajay Jagannathan) Configuration of TEMPDB is often critical to scalability and throughput of SQL Server applications. The following link (https://support.microsoft.com/en-us/kb/2964518) outlines how to configure SQL Server 2012 and SQL Server 2014 for optimal scalability and performance.

(Richard MacAskill) One of the difficulties of designing a completely different type of development tool such as SQL Clone is that you have to explain what it is for, but when its use is open-ended it can be exciting to see the novel uses that come out of the early-access program.

(Pinal Dave) There are so many settings in SQL Server Management Studio that it can sometimes make someone nervous. Once of my client sent me email telling that something is not right with their SQL Server 2016 installation.

(Daniel Mellor) I don’t often have to do string manipulation in T-SQL, but when I do, it’s rare enough that I don’t remember the syntax. I’ve done it in the past, so I keep a script handy with a working example though. I recently added to that example after wanting to know not only the file names, b

(Jack Vamvas) Question : I’m trying to change the database owner on a user database to sa, but I am receiving an error message:

(Sergey Gigoyan) There is a frequently asked question among many people who work with SQL Server: “Why does SQL Server use almost all of the memory on the server, even if there is essentially no activity on the databases?” This is a common and logical question if you are not familiar with SQL Server

(Pedro Lopes) Optimized Nested Loops (or Batch Sort) is effectively an optimization aimed at minimizing I/O during a nested loop when the inner side table is large, regardless of it being parallelized or not.

(Greg Larsen) In my last article (http://www.databasejournal.com/features/mssql/altering-an-existing-table-to-support-temporal-data.html) I showed you how to modify an existing table to take advantage of the new temporal data feature in SQL Server 2016.