You might have heard about people looking for concatenating more than one rows into a csv string. Previously i found out difficult enough. I used coaelesce to do that . But coaelesce usually asks for a varibale to be declared and updates the values i...

Working on any SSAS project, might require a Time Dimension everytime. Recently, I had to create a Time Dimension with various datetime calculated columns in it. This calculations might help to create various user defined hierarchies in the dimension. ...

DateTime is a very useful yet complex datatype in SQL. I have heard many people saying they are not comfortable when it comes dealing with Date calculations. Let us take a closer look at various functions used for date calculations. DAY Returns...

Submit A Solution Th...

Every SQL Server developer have a basic knowledge of Backup commands. Well, this command come with a huge number of different options which can be highly useful in various ways. You can refer the complete list of Backup commands with all the options o...

Well, let me share this time something related to SSIS. Many of you might be using this feature provided by SQL Server for importing or exporting data to and from different sources. Let me share you something about the “Data Flow Task”. &ldq...

In my previous post I have shown you how to deal with Key Lookup. Going more into the depth of Lookups, there is another Lookup called RID LookUp. Both of these LookUp’s are categorized under Bookmark LookUp. Bookmark Lookup occurs when a non-clus...

I have been looking onto how Query Execution Plan works on internet. It shows the execution plan SQL Server Query Engine used to achieve the output. There are numerous operators used when the query is complex enough to show the plan. Well, i am assuming...

I was just surfing net and came across a very good function "local-name". When i searched for its defination in Books Online I found it as a function which "Returns the local part of the name of $arg as an xs:string". It means that whatever the paramete...

Thanks for the feedback.. data() part is a new thing for me...