Why shrinking a DB won't help

http://www.sqlskills.com/blogs/paul/why-you-should-not-shrink-your-data-files/


http://thomaslarock.com/2009/03/when-to-use-auto-shrink/

Comments

Post a Comment

Popular posts from this blog

Get Row Count from SqlDataSource after Filtering

Select from the sqldatasource and convert the output to a dataview, then place the same filter you are using, and get the count.  Remember to place this code in the databound event.  protected void gvCurLookup_DataBound(Object sender, System.EventArgs e)     {         System.Data.DataView dv = (DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty);         dv.RowFilter = SqlDataSource1.FilterExpression;         int RowCount = dv.Count;         if (dv.Count > 0)         {             this.lblMsg.Text = dv.Count + " Books...";         } } ref http://www.c-sharpcorner.com/UploadFile/scottlysle/using-filter-expressions-with-an-sql-data-source-in-Asp-Net-C-Sharp/  
Read more

Winforms DataGridView Notes

It is not often when I have to go and create a DataGridView in Winforms so here are some notes.   Sadly we are stuck in .net 2.0. I find it easier to add the columns manually through the designer that the datagridview will hold.  Ids, text fields, buttons, etc.  I have a custom CalendarColumn as well.  The main fields of the columns in the dgv that are used are the HeaderText, Visible, DefaultCellStyle->Format, DataPropertyName, Name, AutoSizeMode, and Width.  In case of Button UseColumnTextForButtonValue (remember to have the FlatStyle = Standard). When accessing data, the values could be nothing or DBNull.value, depending if it is a new row or not.  So will need a lot of testing for DBNull or Nothing. Adding data to dgv could be done inside the dgv, but having fields outside to add to the grid is feasible as well. Modifing inside or outside grid can work. Deleting seems to work well inside.   Rebinding works well after a changing...
Read more

Telerik - Custom Group Footers In RadGrid

As anyone that has dealt with this knows Telerik only supports a single Group or Header Template.  So what happens when you want to change them?  You really only have two options from what I have seen.  The first option is to have something in the data that is brought back that you can use in the designer code in the form of a conditional.  Too bad I do not see a way to check the data based on level like some sort of ParentID like some people have done.  If the ParentID is null  It would look something like below where you check it in the designer: < asp : Label runat = "server" ID = "Label2" Text = '<%# "Number of items in group: "+ (((GridGroupHeaderItem)Container).AggregatesValues["AvailableUnits"]) %>' Visible = '<%# ((((GridGroupHeaderItem)Container).AggregatesValues["AvailableUnits"]) != null)%>' > Or you can use the code behind to really get at the groupIDs like this per...
Read more