>> In 99.9% of all cases, all most people need is an automatically assigned value incremented by 1. <<

No, I would say that in the majority of cases people...

What percentage of the rows of each table are less than 12 months ago?

Obviously, it's time for you to move this all to the cloud where you can easily add a bazillion CPU's to scale out for this horribly complex problem.  After all,...

It sounds to me like it's all the fault of the query and the person that wrote it... not an absence of indexes.

Why can a person not understand that when you write a query against dev that has 6 rows per table, and the query does 3 table scans, it will...

I'm working with a company that's at the beginning of a migration to the cloud and have been in close contact with the DBA at another company that's completed the...

I vote that this conversation end now.  Unsubscribing. 😀

I can't remember most days which day it is. Mostly because I think it doesn't matter and then I don't pay attention. I check the display in my...

I don't understand what a sequence has to do with an identity property. They are two very different things. Just look at all the optional clauses that you get...

When you set something to zero like this, you're changing the data,you're destroying the fact which Chris Date and I think most other RDBMS experts feel is a really...

Hi Jeff,

This process was originally written in VBA, in an MS Access Application.  We have moved our back end to Azure SQL Server, so it was easiest for me...

Just a personal habit of mine... I don't update such data because, if someone adds interceding data, you might not be able to determine what should happen to it because...

Heh... you've been at this for 30 years and you still can't meet your own demands. 😉  Drop the tough guy troll act and post...

2 way street here... please post your solution!

I know how to get data between just startdate and enddate, but I need to select it between just month and year, start month is previous July and...