SQL Noob;

As for your bug where everything gets rebuild... check your selection in your on-line & off-line scripts. You are selecting anything that is > 10% fragmented,...

SQL Noob;

Again thanks for sharing your procedures. I have taken the liberty to modify the process to allow it to run from a separate database I call...

Chris;

I will give you an example of what I need to do and why it is so important to have a process like the ones described in this...

Greetings all;

I have been on the same project here at my new position. I have a 2005 database that has over 400 tables, who knows how many...

Good point Peter....

If I understand the data correctly then I think David's on the right track.

Kurt

SELECT docid

FROM table a

where exists (select * from table b where a.docid + 1 = b.docid and...

I'd be interested in similar information as well.

Kurt

G Bryant McClellan;

In a sense you are 100% correct on your assessment with a DW. None the less there are many organizations that don't have something like...

I remember when I introduced the concept to a corporate finance company I was working at in 2000. It was the first time the company was able to make...

Robert;

Actually that link provided me great help. However, I still had some issues with the HTML.

Here is the process: I produced an...

I'm wondering if I can't find my answer on this Forum, is there another Forum I can post my question?

Thanks.

Funny you should mention that... well, now that you mention it I've lived in the NYC metro area, mostly in northern NJ. May 2005 I moved to northern Westchester...