What does an Index mean to a Query

This post is about the importance of a right index to a query. The following simple query was considered.

SELECT
[GroupBy1].[A1] AS...

Why we need a PASS Sponsor Portal

Major sponsors in our space get hundreds of emails from us each year, all asking for money. Those are all...

How to deploy your SQL Server database to a remote server

CASE 1: you have direct access to both the SQL Server where the source database is and the SQL Server where the target database is.

First time deployment

Backup / restore...

How to deploy your SQL Server database to a remote server

CASE 1: you have direct access to both the SQL Server where the source database is and the SQL Server...

SSIS Catalog Project Versioning

If you’ve spent much time working with the SSIS catalog, you likely already know that the catalog is where all...

Special Index - XML Index

I will be writing this series of articles for the Special Indexes in SQL Server. In this series we will...

What does an Index mean to a Query

This post is about the importance of a right index to a query. The following simple query was considered.<?query --SELECT    [GroupBy1].[A1]...

Friday Reading 2016-11-11

It’s Friday so no releases to Production today (ha!) which means in-between my code reviews, server audits and other tasks...

Linked Server Security

Problem

When creating Linked Servers, security often gets overlooked.  This can lead to accounts on one instance having access, sometimes with...

SQL Server 2016–Live Query Statistics

WOW!!! The next great update to Execution Plans is a way to watch the processing of rows through iterators while...