DotNetKick.com is an open-source project. Please report any bugs and let us know your great suggestions. Currently running svn revision 620 (rss)

Kick Spy!, Kick Zeitgeist and Kick Widgets

3
kicks
Using sp_MSforeachtable and DBCC CLEANTABLE to reclaim space
submitted by kprernn 8 months, 11 days ago

weblogs.sqlteam.com — In this post, Joe demonstrates how the undocumented sp_MSforeachtable stored procedure and the DBCC CLEANTABLE command can be used to reclaim space once use by columns that have since been dropped in a Microsoft SQL Server database.

Add a comment add a comment | category: | Views: 4 | Get KickIt image code
tags: | tag it

new Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

  • "Kick It" text
  • "Kick It" background
  • kick count text
  • kick count background
  • border

Simply copy and paste this HTML into your blog post.


Users who kicked this story:
kprernn - spirit1 - rg443

Comments:

No comments so far




information Login or create an account to comment on this story
 

Sponsored Link: www.carlist.ie

Search:

Ads via The Lounge

You are the editor:
View upcoming stories
Submit a story
How else can I help?
Earn money
Tags: all tags - your tags