SQL – Split delimited columns using XML Or UDF function

The requirement is to convert the delimited column into rows
Input data and required output details are given below
EnoEnameEslocEDept1ABCNJ10,20,30,40,50Output:-
EnoEnameEslocEDept1ABCNJ101ABCNJ201ABCNJ301ABCNJ401ABCNJ50Download the Script Split...

The mysterious permission issue

As you might have realized, this is not the title of an Agatha Christie book, but rather about some nasty...

I Am Grateful For

A while back I wrote about saying “Thank you” to people. Last night I was listening to NPR on my...

On Failure

The first rule of blogging is that you should write about topics you know a lot about. And I know...

Friday Followup For January 9, 2015

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...

T-SQL script to find the growth size of database files

Below query can be used to see the growth size of database files.

DECLARE @filename NVARCHAR(1000);
DECLARE @bc INT;
DECLARE @ec INT;
DECLARE @bfn...

T-SQL script to find the highly populated tables in database

Sometimes we need to check which tables of our database is highly populated. Below is the T-SQL Script which we...

How to resolve connection errors when loading data in SSAS Tabular project

This post actually applies to both multidimensional (cube) projects and Tabular projects which manage data source connectivity in a similar...

Building Connection Strings

I ran across a great article on Connection Strings from my good friend, Allen White (b, t, c), recently. Quite...

Better late than never…

Just like last year, I’m a bit late with the obligatory “how was last year and what is this year...