Business Analytics Day Jan 11, 2017 Chicago

I hope you can join me at the Chicago Microsoft Technology Center for the PASS Business Analytics Day, on Wednesday,...

Why would you never use SSIS Fast Load…?

We all know that if you want SQL Server to push data into a table then you want to batch the...

Test Post

When was my index created or at least last updated?

SQL Server stores a create date and a change date for each object in the sys.objects system view.

Unfortunately while...

Monday Coffee 2016-11-14

Communication in the workplace.
With the release of Microsoft Teams we now have a dazzlingly array of software designed to increase...

Enabling Cortana for dbareports PowerBi

Last week at the Birmingham user group I gave a presentation about PowerShell and SQL Server

It was a very packed...

Residual Predicate and "Number of Rows Read" in Execution Plans

What is Residual Predicate?

Lets say one gets a query to fine tune. While checking the execution plan, if there is...

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. [crayon-5e96566159ca8644006533/] Even simple, this query was causing troubles on our production...

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. [crayon-5e81b52eda1f0195410103/] Even simple, this query was causing troubles on our production...

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...