Dinesh's Blog :::: Being Compiled ::::

Here is another post on a demo did at Aug meet-up. This post speaks about Indexed Views. As the name says, views can be made as Indexed Vi...

Indexes are added mostly based on WHERE conditions used with queries execute frequently. Once the index is added, it speeds up the search on...

GUIDs are commonly used in distributed applications which require “uniqueness” across the entire world. Unfortunately I have seen the usage ...

Index fragmentation is something we need to monitor frequently specifically on databases that are heavily indexed. If indexes added are frag...

DBCC IND command is one of the important commands used when indexes are analyzed. Specifically this can be used for seeing the linkage betwe...

These posters have been published few months back, if you have not downloaded them yet, here are the links; SQL Server...

It is too early, but this is how Microsoft SQL Server team works, yes SQL 2014, CTP1 is available for downloading . Here is the path: ht...

Everybody says that they all have business intelligence applications. Everybody says that they develop business intelligence applications, i...

Have you ever thought to use bookmarks in Management Studio when working with lengthy codes? If yes, you are smart, but what I have seen is,...

The cumulative update #3 for SQL Server 2012 is available for downloading now at: http://support.microsoft.com/kb/2723749 . Make sure you ap...

As I get many offline questions regarding the presentation “Reducing RoundTrips” I did, thought to summarize the content we discussed as a p...

The @@IDENTITY is a system function that returns last generated identity value. But the question is, is it the last identity generated by my...

There are some instances we have to create parameters with multiple items, including an item representing all items in the list, mostly call...

As you all know, Pivoting and Unpivoting are supported with SSIS but the implementation of PIVOTing is bit difficult when compared with UNPI...