Webinar – What’s New for Business Intelligence in SQL Server 2016

I’ll be giving a webinar for MSSQLTips.com on Thursday 29th October 2015.

The title is What’s New for Business Intelligence in SQL Server...

Performance and using of VARCHAR boxes as filters in SSRS reports

Very few people have thought about this performance killer. It is all about report parameter of text type. The initial situation There was a table with about 45 million...

Performance and using of VARCHAR boxes as filters in SSRS reports

Very few people have thought about this performance killer. It is all about report parameter of text type. The initial situation There was a table with about 45 million...

Performance and using of VARCHAR boxes as filters in SSRS reports

Very few people have thought about this performance killer. It is all about report parameter of text type.
The initial situation
There...

Git Push in SQL Source Control

I’m excited. Git support is growing in SQL Source Control and the release recently contains Git push/pull support. If you...

Git Push in SQL Source Control

I’m excited. Git support is growing in SQL Source Control and the release recently contains Git push/pull support. If you...

ZOOMIT!

Guilty.
I’m at least one of the people who yelled Zoomit during a keynote at PASS Summit.
I want to take a moment...

Histograms and Events

In this article I show how to use and configure the histogram target. In addition, I explain how to get to the data trapped into this target. Lastly, I...

Histograms and Events

The last few articles covered the pair_matching target and some uses and details that go along with it. For a...

Consequences of Timeout/Error on a Delete statement

Hello Guys,
Lately, one of my friend asked me a Question, “If Delete is in progress and query get erred out or...