50K is not a big record set. What sort of queries are you going to be doing? I can't imagine that you want to do much analytics on...

I believe that all the standard components in ssis are .NET classes so you could always write your own c# or vb.net to generate packages but it would be a...

You have three basic choices, none of which are particularly great 🙂

1) the option you have outlined with a different child table for each 'type' of advert. Maintenance is...

Fully Agree with Jeff, get a consultant in to set this up if this is the standard they are giving you to work with. That said - aint never...

Normally running totals should be delegated to the reporting application; they infer a sequence which goes against Set Theory.

@Jampandu

I am still not clear WHY you want a unique number that is not the Identity column but fulfils the same purpose. By putting the values in...

Luis Cazares (11/28/2014)

---

Jampandu,

I've never understood the advantage of sequences. I feel that it's only included to be "compatible" with Oracle.

The first option that you mention seems to me as...

@Erickur,

Excellent explanation of how, but some of us were questioning why?

Why would you create a unique key that had no relevance to the business. There are only reason that...

Gail said don't use SELECT *

the * tells the parser to get all columns, but to do this it has to go to the table schema and work out what...

Glad to be of help.

If you go with this option, understand that it is NOT ANSI standard SQL so you will be commmitted to the MSSQL solution or need some...

Primary and Unique are not necessarily the same thing 🙂

Where the unique key is a compound key (e.g. if it were a flight booking system then Flight#,date,seat#) then I would...

As Gail said, normal behaviour.

Even worse is if you drop a column being used in a view or modify it's data type!

This is one of the main benefits...

You have posted thin on the SQL2008 board, but there is another solution if you are on SQL2012. There is a new option of SEQUENCE where you can define...

This looks like a presentation requirement rather than a data requirement.

You could pull the whole of the table into Excel and use Pivot tables.

If you need to show details about...

The easiest way to do that is with Dynamic SQL.

Basically create a varchar variable which holds the SQL statement and build the statement up manually then call execute on the...