I can't believe anyone would let a system go so bad, it just flies in the face of every tenet of good databasing; and the previous DBA heart of gold,...

That's one of the phases in the improvement cycle, this entire exercise so far has been the first of those phases, to dig the DB out of the grinded, mashed-gear halt it's been...

I've just found out, SP_SPACEUSED, without any tablenames, yields the total data size and the available space within a database.

I've just discovered 50Gb of space I didn't know about before, which...

Any code that'll tell me tablesizes?

And that's barking UP the wrong tree...

JB

I may need to do it regardless of time, if an insert MUST take place - and I would imagine that would be sooner rather than later.  I've got 11Mb...

To keep you posted,

The row delete worked - nice end to a nice weekend - down from 118 million to 60 million, but the database size hasn't changed, methinks this...

Cheers guys, the delete is running as we speak, launched it this morning, the speed is about 28,000 rows per minute and seemingly accelerating, should be done by Saturday morning (CET)

I'm not...

Is this one safe to run overnight? 

Got some syntax issues...and discovered that I have about 21Kb left...

Server: Msg 156, Level 15, State 1, Line 15

Incorrect syntax near the keyword 'WITH'.

Server:...

Well, I made a lot of insertions, processor usage (on both nodes in our cluster) went up to or near 100% for about 45 minutes, and then finally I pumped...

Morning/Afternoon/Evening fellow SQL Illuminati..

The last DBA set up some scheduled jobs to pipe out data and then delete.

Anyway, some help with that rowcount syntax would be very welcome!

JB

Table name and the relevant column are in the opening post...that script in two versions, "Run_this_test_first" and the second "Adjust_Rowcount_According_to-Result_and-Run" would be very handy...

Anyway, night all!!

JB

Not sure how shrinking the LOG file will help clear out the .mdf - I've been dumping it periodically today...as far as I remember it is about 300Gb in size,...

I thought a Clustered Key was just a teeeny object in one of the Sys tables that stipulates the re-sorting of the heap into the order of one of the columns?  I...

Sounds like a plan so far mate...I'd better ask, would the time taken to re-sort the rows exceed the time that the usage of a clustered index would save?

Tried doing...