Mike Levan (3/17/2009)

---

Each of our database in the environment ranges from 800GB to 1.5 TB, we back them up once in a month as we update them only once in...

If both schedules start at the same time of day, then the job will run only one time.

steve dassin (3/16/2009)

---

Gift Peddie (3/15/2009)

---

Science is a b****, expediency is a w*****. It's not easy to sleep with science. But sql sells itself to even the lowest bidder. It's been...

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...