Cool - love it 🙂

Although - it still suffers from the problem of deleting potentially valuable data 😉

this solves it:

with Dups as

(SELECT *,row_number()

OVER

(partition by id,col1 order by id,col1)...

I'm not sure I'd use this script on a table with 10 million rows in it due to the potential for the cursor to become unwieldy if there are a...

The only absolute should be that there are no absolutes.... 😉

There should only be guidelines, validation, discussion and feedback.

After a long time in I.T. doing various jobs from Mainframe operations...

I think you're right - It will defintely be quicker if queries are hitting alternate covering indexes on different physical drives but that would be a hefty compromise in my...

I think it would be a waste of time and resources to port Windows to other chipsets but, more importantly, it would probably lead to a "dumbing down" of the...

You might want to take a look at this otherwise your database might get broken by simply restoring and setting the compat level to 90:

http://www.innovartis.co.uk/topical/migratingto2005.aspx

In terms of power consumption the power would be saved every time a backup runs - hopefully restores, and therefore index rebuilds, are a less frequent activity! 😉

Sounds like an awesome idea to me however the Connect proposal's status is "Closed (Won't Fix)" - does that mean MS have reviewed the suggestion and rejected it?

That's an interesting idea - replicating out all your lookup data to reduce the load on the "authoritative" server - basically this would need the same approach as implemented in...

I think it's because most of us are basically optimists and when we estimate something we always subconsciously think of everything going right. If we really made ourselves think...

Trying to cost out how much poor coding will cost you in terms of hardware is pointless because you can't possibly say what extra resources a poor piece of code...

That's good overview of the schema compare facilities of DBPro but the example process you have chosen is fundamentally flawed as database changes should NEVER be reviewed at deployment time.  The time...

Hi Terry,

Don't get me wrong - your process isn't bad (sorry if I came across badly back there) - it's just not as optimal as it could be and, in fact,...

Hi Andy - I mentioned cross continent as an example to illustrate my point about a source control system being necessary as it doesn't care about time or distance boundaries.

Terry...

The requirement for devs to communicate with each other before checking in diffs scripts is the fundamental problem in the process and what makes it resource intensive and prone to...