Viewing 15 posts - 1 through 15 (of 57 total)
Cool - love it 🙂
Although - it still suffers from the problem of deleting potentially valuable data 😉
this solves it:
with Dups as
( SELECT *,row_number()
(partition by id,col1 order by id,col1)...
January 6, 2009 at 10:16 am
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...
January 6, 2009 at 4:01 am
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...
October 24, 2008 at 3:38 am
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...
April 25, 2008 at 5:14 am
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...
April 4, 2008 at 2:39 am
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:
March 20, 2008 at 2:49 am
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! 😉
March 18, 2008 at 4:47 am
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?
March 18, 2008 at 2:36 am
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...
March 17, 2008 at 2:55 am
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...
October 5, 2007 at 12:52 am
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...
August 17, 2007 at 2:42 am
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...
July 25, 2007 at 2:26 am
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,...
June 29, 2007 at 9:36 am
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.
June 29, 2007 at 8:23 am
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...
June 29, 2007 at 7:45 am