These scenarios don't sound like disasters to me. They sound like challenges that would be fun at best and interesting at worst.

Games have a goal (or multiple goals), barriers,...

Where you have "[VALUE]" in your Select statement, put "round([VALUE], 3) as RoundedValue". Change the rounding digit as needed (I picked 3 arbitrarily), and change the column alias to...

By "IT SHOULD HAVE A HEADER", do you mean a row at the top that just says, "IT" (or whatever)? Does it also get column headers?

There are easy ways...

The complexity will depend on the magnitude of the changes.

I did that in SQL 2000, so it's not new.

It's a performance killer, but it's not a new one.

This kind of thing is one of the valid reasons to use...

Copy-and-paste the When...Then statements into Management Studio.

Ctrl+H (Search-and-Replace) for "when", replace with "union all select".

Ctrl+H (Search-and-Replace) for "then", replace with ",".

Delete the first "union all", leaving the whole thing starting...

To add to SQL Bill's point, nobody is going to put "Junior DBA, 10 years" on their resume, even if that was their job title that whole time.

jaffrey (10/16/2010)

---

It is not about memorize the list of interview questions, Just i want to get some ideas from it.Its like what are the concepts to be asked in the...

Key/Value is how I've done that.

Using the SQLVariant datatype might help, or might not, but is worth looking at. But really, converting a few values from varchar to int...

As an addendum, don't use SSMS's GUI to redesign tables. It often has to create a temp table with the new structure, insert all the data into that, drop...

Nvarchar can go up to 4,000 explicitly, or to "max" (as long as you're on SQL 2005 or later), which allows for a LOT of characters.

So long as your varchar...

Sockets.

What's the purpose of the split? Can one "pre" have more than one "post" for a given "item", or vice versa?

Can you rename the existing column, create a new column of the type and size you want, populate from the old (renamed) column to the new column, and then validate...

You might be able to do something with a DDL trigger, but I'm not sure. Check that out as a possibility.

Why not just use password policies? That's the...