SQL Server Wait Types are important factors to consider while analyzing performance problems of SQL Server databases. If you notice a particular wait type is occurring too often or for too long, it indicates a problem in most cases. There are several d...

I found this question in this SSC forum thread requesting help to shape the XML document. Here is the input XML document. Jhon Luka 1 2 The expected output is as follows. Jhon Luka 1 2 Th...

I found this question in this SSC forum thread requesting help to shape the XML document. Here is the input XML document. Jhon Luka 1 2 The expected output is as follows. Jhon Luka 1 2 Th...

Do you know how it feels like to hear an old song and have a whole lot of memories come flooding back to you? Well, something sort of similar happened to me today. I was doing my weekly reading and going through a brilliant post by Microsoft MVP - Greg ...

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solv...

Microsoft SQL Server comes with a whole range of system databases, which I visited in my post – How to programmatically identify system and user databases on a SQL Server instance. System databases are special, and there some very specific and peculiar ...

Let Us Learn Oracle - Part 3 of N [ InitCap function in Oracle ] Source table: tblPlayers Purpose:Capitalizes the first letter of the string Syntax : InitCap(Column Value) SQL> Select Initcap(Upper(BelongsTo)) InitCapExample From tblPlayer...

Indicates how the data is ordered within the partition. Before going to look into some examples of Lead we will first create the test environment Run the below script for doi......

A couple a weeks ago I blogged about a few of the enhancements in the OVER clause, and now I will show you guys a couple of new windowing functions, that goes along with the OVER clause. These new functions are FIRST_VALUE() and LAST_VALUE(). I’l...

I am back from vacation, and have spent a couple of weeks catching up my workload. Now I am ready to finish the SQL Server BI Quiz “Mass Mailing Your Report”. Here is my original blog, SSRS #55 – SQL Server BI Quiz “Mass Mailing...