Dynamic Sorting in SSRS

Introduction
Many times while developing any report we come across a situation where we need to SORT the TABLE columns or...

How many times the T-SQL inside the CTE is executed?

Introduction

Common Table Expression (CTE) has become very popular these days. However, many users of CTE still have a myth that...

Workarounds for SSRS 2008 Font rendering issue

 
Problem
A report developed using SSRS 2008 either through Visual Studio 2010 or BIDS 2008 does not renders properly when viewed...

Using OFFSET and FETCH

 
Introduction
Many times while developing our applications we feel the need of pagination, where our User Interface (UI) has to list...

How to find out which Table is not having rows in SQL Server?

Introduction
Many times while tuning our production databases we might try to find out the list of tables not having even...

How to find a string value in all the string columns of a table/view in SQL Server ?

 
Introduction
I am sure many times we all might have come across situations where we need to search/find a string value...

T-SQL to find Fragmented Indexes

Fragmentation of Indexes is one of the reason for low performing queries resulting in a poor application performance.
Today, I will...

Lookup functions in SSRS 2008 R2 - III

Introduction
This is the final post to discuss the last Lookup function Multilookup(). The other two – Lookup() and LookupSet() have already...

Lookup functions in SSRS 2008 R2 - II

 Introduction
In my last post on Lookup functions related to SSRS 2008 R2, I had explained Lookup(). It is used to...

Lookup functions in SSRS 2008 R2 - I

 
Introduction
Most of us who are regularly working with SSRS have always felt the need of some way through which multiple...