Ok... my previous post with the code and some example code on how to use it are done.  Read the comments in the demo code near the end.

I hit submit by accident.  I left a message at the top of the previous post.  Please have a...

Ok, first you need to follow the link to the "fnTally" function in my signature lines below this post.  It's a high performance iTVF (inline Table Valued Fuction) that we...

First of all, using a loop in a stored procedure is one of the slowest things you can do.  Only an rCTE (recursive CTE) would make it slower.

My suggestion is...

Remember that it's a script and not an article.  It's not designed to teach either how it works or potential usage.  It's simply a script in a repository for people...

A Microsoft certification may be worth more if that's what you want to cut your teeth on.  Combine that with an internship to get some "experience" documented on your resume...

I've never had to do such a thing before and so I have to admit that I had to look this one up.  Learned something new.  Thanks for the great...

IMHO, you are on the right path.  I'm currently doing exactly what you described.  Importing flat, delimited files to a 'staging' table where all fields are defined as...

No.  No duplicate login names or account numbers and, in many cases, no reuse of such things either because that would actually entail a dupe even if all but one...

Thanks for the feedback, Michael.

My fnTally script was published.  I have a link for it in my signature line below.

Heh... technically, the question answer is still incorrect because you CAN add dates and times... if the answer was that you cannot add DATETIME2s, then the answer would have been...

Agreed that login name isn't...

IMHO, you are on the right path.  I'm currently doing exactly what you described.  Importing flat, delimited files to a 'staging' table where all fields are defined as VARCHAR(500),...

Hi Alex,

Its is a full backup. Don't know the reason why , when backup is in progress , it was showing the backup file size as 822 GB...

You would be so much better served listening to Jeff and skipping the rebuilding of indexes. Maintaining statistics on indexes is vital, but defragmenting indexes is an idea that...