I can't see why you would drop the clustered index and then recreate it, since that forces SQL Server to rebuild the table as a heap and then rebuild it...

You will have to delete the maintenance plans and redo them.

Are you completely reloading the table each time, or just adding new rows to existing data?

Lowell (3/16/2009)

---

i just slapped this together.

i'm using sp_revokeaccess instead of sp_dropuser, because the users might be orphaned and not tied to a login;

this yanks them out the way i expected:

[font="Courier...

I think it would be hard to justify any effort to develop a flat file database, since there are fairly mature free open source databases available, and free versions of...

I worked at a place where an expensive outside consultant did a study of our data environment and actually proposed something like this.

The CIO just said that was the stupidest...

You might turn the question around and ask "Why not use 64-bit?"

One thing that may be a cost consideration is that 32-bit Windows Server 2003 requires Enterprise Edition to support...

I think the guy's a troll, trying to start trouble.

Nothing to see there, just move along.

They are not logically equivalent tests. Notice the different...

foxjazz (3/13/2009)

---

ok example sort of (my computer is sick so I can't give you something already done)

select name from mynametable where changedate > @yesterday

fetch from @sel into @name

while (@@fetch_status =...

Is depends on the meaning of downtime. If you look at if from the user point of view of not people not being able to do their jobs and...

You must enclose the date in single quotes to cast it correctly to a date time.

when createddate > 2009-06-01

is the same as

when createddate > '1905-06-26'

because 2009-06-01 becomes...

Thanks for a chance to pad my posts some more.

I'm currently holding the 61st spot on the all time posts lists, so maybe this will put me over the top...

frankivey (3/12/2009)

---

I just had an interview for a DBA position in CT, the IT Director asked me how do I backup a filegroup. I started to answer "with a...

I made that last post to try to see why my prior post was not showing on my Recent Posts display.

Neither showed up, so I am not sure what was...