The query store gives us a novel way of identifying those queries that are causing performance problems when they are parameterized by SQL Server for reuse. Although it is relatively simple to ensure that certain troublesome queries avoid the problem, it is laborious to identify these queries. Additionally, Query Store gives us the means to fix the problem for groups of queries by means of plan guides without changing the DDL at all. Dennes Torres explains the details

A Summit Just North of The Big Easy

by Steve Jones

SQLServerCentral.com

Editorial

Steve Jones travels back to one of the largest free events in the country, SQL Saturday Baton Rouge.

SQLCMD and Batch File magic

by Manu Mohanan

SQLServerCentral.com

SQLCMD

Execute scripts in a folder with a single click using SQLCMD and a batch file.

Getting Started with SQL Server 2012 Express LocalDB

by Additional Articles

MSSQLTips.com

SQL Server 2012

Developers using SQL Server Express face a few challenges in their day to day work. One is that setting up and maintaining Express can be a daunting task.

Advanced Analytics with R and SQL Part II - Data Science Scenarios

by Frank A. Banin

SQLServerCentral.com

Data Science

Build and Operationalize scalable Predictive models and intelligent applications using SQL and R.

Statistics in SQL: The Kruskal–Wallis Test

by Additional Articles

SimpleTalk

T-SQL

Before you report your conclusions about your data, have you checked whether your 'actionable' figures occurred by chance? The Kruskal-Wallis test is a safe way of determining whether samples come from the same population, because it is simple and doesn't rely on a normal distribution in the population. This allows you a measure of confidence that your results are 'significant'. Phil Factor explains how to do it.

SQL Crossword #1

by Kenneth Fisher

SQLServerCentral.com

Editorial

Today we start a new puzzle series, with a crossword puzzle from MVP Kenneth Fisher.

How to Read the Transaction Log File

by Additional Articles

Database Journal

Transaction Log

Have you ever wanted to be able to see the actual transactions that are contained in the transaction log file? Greg Larsen shows you how to browse the transaction log using an undocumented function.