Sorry, I forgot to add.  Splitting the table into more than one by columns is vertical partitioning.

If your users tend to search for last months transactions then I would consider...

I had this problem where I had to get transactions from 15 countries on a monthly basis.

My solution, pre-analysis services was to create specific summary tables that pre-aggregated the data.

For...

Personally I couldn't give a damn about the "don't use capitals" issue.

For the pedants out there I do understand about case sensitivity.

What I care about is whether or not there...

It could have been nasty and obviously the exec wanted him skinned alive.

Fortunately IT manager took the view that he should be the one to discipline his own staff so...

SOUNDEX on SQL Server is too limiting.

You need an equivalent that takes into account more letters so that you can tune your dedupe process.

You also need to be able to...

In other words learn to be a development DBA.

One thing I have learnt in my career is that "in the land of the blind the one eyed man is king". ...

Really, this is a case of the road to hell being paved with good intentions.  You can see the spirit of what the IT Director wanted to do its just...

Yes, I know what MODEL is for, its just that it has been hammered into me since SQL6.5 that the MASTER is and always should be sacrosanct.

Robert did bring up...

Presumably you have an ordering sequence?

Without details of your table structure the only way that I can think of doing it is by using a cursor, however I would tend...

Has Scott Adams drawn a picture of your IT director by any chance?

I was told by an old sergeant that when officers gives a stupid order you follow that order...

There is an old SQL6.5 trick that still works.

sp_addalias <login>,'dbo'

If you run that in your database then your developer login will be the dbo and therefore all objects created in...

Let us suppose that your procedure inserts records into a customer table, and order table and an order item table.

You could have a single procedure to do this, but there...

You set @insertSql statement is trying to concatenate a string and a date, and therefore throws the error.

If you want to build the string then simply do the following

set @insertSql='Insert...

Surely, this is what the MODEL database is for?

I think the great thing about MIDI was that it was a standard when there weren't any standards.

To come up with a replacement for MIDI would be a major achievement, after...