bogus question...waste of time

should specify the service pack if your answer is going to be service pack specific.

Should be filed under the "SQL Hacks" category 😀

It would be nice to see performance impact on a production DB while running this during business hours. Though I wouldn't run this during business hours, many unsuspecting people would...

Oh nice! Thanks for the link.

Bad question.

You were trying to be tricky in your question. It could have been straight-forward and simple that to SAVE SPACE... which column should I prefer to make NULL over...

Thanks, I think this is the first index article genuinely written with a n00b in mind.

I'm waiting for your next StairWay. Any idea when we should expect that?

Have you looked into CDC? SQL Server 2008 offers Change Data Capture (basically transactional replication in a way) where you can write your changes to your reporting server.

Might be one...

It was just a question. I've seen that error before, I'll typically check the open trans and if/when the log was backed up.

It's most annoying when you see that...

Great article, great reading.

Now.. how can I manually activate/deactivate VLF's within a transaction log?

Thanks,

S

Mike,

Once the tables(rows) were compressed on your tables, how much space were you able to conserve? Do you have any estimates? Numbers would help on the usability of this functionality.

Thanks,

S

Excellent article.

Thanks for writing about this. And the alternative solutions help in making sense out of all of this.

-

Slick

Langston,

Thank you for the input!!

Does this work everytime and with any XML file? Is this like a generic fix? LOL.. Pretty cool if you say yes.

Thanks,

Slicky.

Scott,

I think the incorrectly named parameters confused me.

You used @TableParamExample and @ProcTableParamExample.

Anyhow, thanks.

Regards,

S

Scott,

Did you decide to skip the section where you populated the Table Valued Parameter? In the script you create it, but I dont see where its populated? Please let us...

I would be happy with if I was getting the same amount of pay and benefits doing other things. I can think of a million other trades that would be...