You're welcome... thank you for the feedback...

--Jeff Moden

I'm thinking you didn't read the original post and there's nothing wrong with shrinking Master when this type of mistake has been made.

If you really want a challenge in the best game of all... help some people out on posts in this forum.   Or, write...

Even more amazing is what folks think a DBA is supposed to do

On a slightly different subject, it saddens me to see yet another MCP/MCTS that doesn't know this type of stuff nor how to find the answers in Books Online.  What...

Surya,

You need to look at the file with a hex editor (maybe like TextPad in the Binary mode) and you need to know a bit about the ASCII character set.

0A...

No one mentioned the other important things...

1. UDF's are normally slower than direct code and the exceptions are fairly rare.  For example, a function to return a date sans time will...

Because it's 3/4 of a gig of disk space that will never ever be used again if things are done right.

Juanita,

You are correct in being nervous... As you know, if...

I don't know if Analysis Service will do it or not... but you can use a recursive CTE in 2005 to produce the result set you need.  I don't have...

Heh... I see what you're getting at and I agree...

I'd like to know why this particular method of "partioning" was selected...

...and with 11 tables, I'm thinking that an increment of only 8 is...

I don't know what "SP_Generate_Inserts" does... but there's a couple of things I see wrong here...

First, it's a very bad practice to name your procs starting with SP_... those should...

Pretty sure the OP said something to the effect of "without using a additional column levelno".

Vamshi,

Lookup "Expanding Hierarchies" in Books Online...

Uh... what happens when you have more than 1 year?  In other words, why are you storing the salary month and not a salary date/time so you can do multiple...