Latest developer linksBookmark and Share
 
HomeThis WeekTop MonthTop AlltimeSearchRegisterFAQ
  
 
Submit Your Link
Please login to submit your Link
 

Does moving table partitions need changing in any of the sys tables storing partition information?

Posted: Jan/22/2011   By: nikhil   Points:15   Category: .NET  - ASP.Net    Views:81   Vote Up (0)   Vote Down (0)    

Hi All,

I am having a scenario in which I am having a table which is partitioned. Every week a new partition is added to the table and consequently a new ndf file is added to the DB(new filegroup) and sometimes existing partition is restated but now I'm having a disk space crunch on the drive where  I'm placing the partitions. So I've safely moved the new partition allocated file path to the new drive with ample amount of space.

But now I've to restate some of the existing partitions as well but unfortunately there's no enough space left on the drive accomodating those partitions. So, here's my question :- I'll be taking the DB offiline and will move the partition to be restated to another drive and alter the database and will map the that patition's filepath afterwards. Does it require any other changes in the system partition tables (partition, partition_scheme etc) or any where else?

Quick responses are highly appreciated.

Thanks in advance.

Kusum

View Complete Post


Comments:
Be the first to comment this post.
 
Post Comment
Please login to post your comment
More Related Resources

Displaying Memory Consumption Information Using ComputerInfo

  
The ComputerInfo class in the .NET Framework is a little hidden gem which represents the useful information about your computer. This class is defined in the Microsoft.VisualBasic assembly which might be the main reason C# developers are not aware of it. In this article we are going to learn how to use the Computerinfo class to display the memory utilization information on the page.

Changing Style Sheet of Controls Dynamically

  
CSS (Cascading Style Sheets) provides easy maintenance for the look and feel of the website. Sometimes we need to set the style of lot of controls dynamically using style sheet. In this article I will show how you can change the style sheet of the dynamically created label controls.

how to put jquery quicksearch in a table cell

  

I am learning ASP and C#, but as yet no nothing about java....I am utilising jquery quicksearch on a GridView, and have it working fine, but there are two things I would like to know :-

1 - I have a table with 1 row and 3 columns.  How can I put the quicksearch box in the first column ?

2 - How can I change the font or apply a CSS style to the text "Search" ?

Here is the code I am using...

<script type="text/javascript" >
       $(document).ready(
        function () {
            $('table#<%=gvContacts.ClientID %> tbody tr  ').quicksearch({
                position: 'before',
                attached: 'table#<%=gvContacts.ClientID %>',
                stripeRowClass: ['odd', 'even'],
                labelText: 'Search:',              
                delay: 100,
                loaderText: 'Loading...',
                
                }

            });
        });
        $(document).ready(
        function () {
            $("#<%=gvContacts.ClientID %>").tablesorter();
            $("#options").tablesorter({ sortList: [[0, 0]], headers: { 3: { sorter: false }, 4: { sorter: false}} });

        });

       
        </script>


Thank you in advance



changing value in gridview row

  

Hello All,

I have a question,  I have a gridview that shows a red balloon as imagebutton in one of the cells.

Now i want to be able to let a users press the button, write a value in a record in the database and then change the  red balloon to a yellow one.

When the user wants (at any given time) wants the undo the value again the record should be rewriten again and the yellow ballon should be red again.

Any tip is more than welcome :)

Thanks,

 

peter

 


cannot add a new column-Unable to modify table.Invalid object name 'MSED_Logs.DatabaseLog'

  

Dear All,

I cannot add a new column in existing table.

I have a two tables ['ev_event_how' & 'ev_events_event_how'] has relationship between these table.

Ex:
Table: 'ev_event_how'

UID - Event[PK]

 

Ex:
Table: 'ev_events_event_how'

UID - Event[FK] - Desc

I want to add a one more column[IsDelete] in both table. But Sql server is not allowing to add the new column, Showing various errors like

1.cannot add a new column-Unable to modify table.Invalid object name 'MSED_Logs.DatabaseLog'

2.TITLE: Microsoft SQL Server Management Studio
------------------------------

User canceled out of save dialog
 (MS Visual Database Tools)

 

How can I make it add a new column in existing table?

 

 

 

 

 

 

 


Cannot insert the value NULL into column 'COUNTY', table 'TPI.dbo.juror_tmp'; column does not allow nulls. UPDATE fails.

  

I am attempting to bind data from a dropdown list that was populated from another datasourceID. I've bolded what I believe is relevant to this issue in the code below. But basicly its binding the proper county on the pull down menu but when I hit form submit it dosnt postback that info instead its null.

<asp:FormView ID="FormView1" runat="server" DataSourceID="SqlDataSource1"
            style="margin-right: 59px"
           CellPadding="4"
            ForeColor="#333333" DefaultMode="Edit" DataKeyNames="UID">
            <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
            <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
            <EditItemTemplate>
                Edit Item Template<br /><asp:Label ID="uidlabel" runat="server" Text='<%# Bind("uid") %>' /><br />
                last_date ha:
                <asp:TextBox ID="last_dateTextBox" runat="server"
                    Text='<%# Bind("last_date", "{0:d}") %>' AutoPostBack="True"
                    CausesValidation="True" />
                <br />
                first_name:
                <asp:TextBox ID="first_nameTextBox" runat="server"
                Text='<%# Bind("first_name") %>'
                    CausesValidation="True" ontextchanged="first_nameTextBox_TextChanged1" />
                <br />
                last_name:
                <asp:TextBox ID="last_nameTextBox" runat="server"
                    Text='<%# Bind("last_name") %>'
                    AutoPostBack="True"
                    CausesValidation="True" />
                <br />
                mi:
                <asp:TextBox ID="miTextBox" runat="server" Text='<%# Bind("mi") %>'
                    AutoPostBack="True" CausesValidation="True" MaxLength="1" />
                <br />
                home_phone:
                <asp:TextBox ID="home_phoneTextBox" runat="server"
                    Text='<%# Bind("home_phone") %>' MaxLength="9&

Changing value in single cell

  

 Hi,

You have been very helpful and for that, I am very grateful.

I have a gridview which shows the contents of the shopping cart. The qty cell is a template control bound to the qty field in the datasource. My ideal scenario is to  have the user highlit the qty, write the new one and press 'enter' to update the sqldatasource but this may not be possible.

My second chose is an Update button to update the data but this erases the data from the other fields not listed as key.

I have tried the edit and update functions but then all fields are editable and I dont't want that, just the qty cell. If I change the read only atrribute to true on the ones that I don't want edited, then it erases the information from those fields.

Suggestions anyone?


MVC - how to have multiple users with their own information

  

Hi All,

I am new to MVC. I am trying to write a simple web app - for learning purposes only, that allows multiple users to log in and enter their top 10 favorite movies. Each user can only see and edit their own list. The can have no knowledge of the other users or their lists.

In regular ASP.Net I would do somthing like a session variable to store the user id so I could use it to test against the database and return that users information. I as I understand it that is not the way things are done in MVC. My question is how would I do this in MVC?

thanks for any tips or advice!

-Chris


i have a table this is contain Exp. Date how to sort it. using jquery

  

in a table  simple text is sort ,but Date, & number is not sort how to sort it using jquery  in below code how to sort ID, & M.Date

<table id="Gr_Document_Managment" cellspacing="0" rules="all" border="1" class="gv" style="height:200px;font-family:verdana;font-size:11px;border-collapse:collapse;">
				<thead>
					<tr>
						<th scope="col">ID</th><th scope="col">File.Name</th><th scope="col">Subject</th><th scope="col">Storage</th><th scope="col">Token</th><th scope="col">M.Date</th><th scope="col">L.Msg</th><th scope="col">DOCTYPE</th><th scope="col">Expiry</th><th scope="col">STATUS</th><th scope="col">MYDATE</th>

					</tr>
				</thead><tbody>
					<tr>
						<td>1688</td><td>index.html</td><td>hjhj</td><td>Desktop</td><td>1001.Ashok</td><td>12.Oct.10</td><td>12.Oct.10</td><td>Brochure</td><td>17.Nov.58</td><td>WIP</td><td> </td>

					</tr><tr>
						<td>1689</td><td>fade.gif</td><td>hjhjkh</td><td>Desktop</td><td>1001.Ashok</td><td>12.Oct.10</td><td>12.Oct.10</td><td>Letter</td><td>17.Nov.58</td><td>WIP</td><td> </td>
					</tr><tr>
						<td>1691</td><td style="background-color:#FF7575;">dl.sh</td><td>gjgjg</td><td>Desktop</td><td>1001.Ashok</td><td>27.Nov.10</td><td>27.Nov.10</td><td>Accounts</td><td>30.Nov.10</td><td>WIP</td><td>-10</td>

					</tr><tr>
						<td>1697</td><td style="background-color:#A5FF8A;">a</td><td>rthh</td><td>Desktop</td><td>1001.Ashok</td><td>04.Dec.10</td><td>04.Dec.10</td><td>MOU</td><td>28.Dec.10</td><td>WIP</td><td>18</td>
					</tr><tr>

						<td>1699</td><td style="background-color:#A5FF8A;">a</td><td>ioiuo</td><td>Desktop</td><td>1001.Ashok</td><td>04.Dec.10</td><td>04.Dec.10</td><td>MOU</td><td>27.Dec.10</td><td>WIP</td><td>17</td>
					</tr><tr>
						<td>1701</td><td style="background-color:#A5FF8A;">a</td><td>Ritu3</td><td>Desktop</td><td>1001.Ashok</td><td>04.Dec.10</td><td>04.Dec.10</td><td>MOU</td><td>28.Dec.10</td><td>WIP</td><td>18</td>

					</tr><tr>
						<td>1703</td><td style="background-color:#A5FF8A;">dl.sh</td><td>fhhghg</td><td>Desktop</td><td>1001.Ashok</td><td>04.Dec.10</td><td>04.Dec.10</td><td>Letter</td><td>27.Dec.10</td><td>WIP</td><td>17</td>
					</tr><tr>

						<td>1706</td><td style="background-color:#A5FF8A;">a</td><td>fhhRitu6dec</td><td>Desktop</td><td>1001.Ashok</td><td>06.Dec.10</td><td>06.Dec.10</td><td>Letter</td><td>28.Dec.10</td><td>WIP</td><td>18</td>
					</tr><tr>
						<td>1707</td><td style="background-color:#FFD062;">dl.sh</td><td>rtytytRitu7</td><td>Desktop</td><td>1001.Ashok</td><td>06.Dec.10</td><td>06.Dec.10</td><td>Agreement</td><td>20.Dec.10</td><td>WIP</td><td>10</td>

					</tr><tr>
						<td>1708</td><td style="background-color:#A5FF8A;">erp.userprefs</td><td>fhhabcd</td><td>Desktop</td><td>1001.Ashok</td><td>06.Dec.10</td><td>06.Dec.10</td><td>Letter</td><td>30.Dec.10</td><td>WIP</td><td>20</td>
					</tr><tr>

						<td>1709</td><td style="background-color:#A5FF8A;">erp.sln</td><td>hjhjh</td><td>Desktop</td><td>1001.Ashok</td><td>06.Dec.10</td> 

storing javascript code in a label

  

Hi,

 I recently came across some code where an asp:label was storing some javascript code. The code was being used to open another aspx page with window.open, and set the height, width, etc.  I have never seen this before. What is the reason for using this type of navigation (javascript) rather than using asp.net or vb code? Also, what is the purpose of putting the code in a label, rather than just in the <head> section?

thanks.



 
Categories:
.NET
Java
PHP
C/C++/VC++
HTML/XML
SAP
MainFrames
Data Warehousing
Testing
MySQL
SQL Server
Oracle
Javascript/VB Script
Others
Login
 
 
 
 
 Forgot password
 Contact Us   Terms Of use   Share your knowledge