Store Db Objects In .ndf Vs. .mdf??

Sep 25, 2006

I am new to SS2005, and I've just started working on a small test/dev
database.

I recently read that one should store things like tables, views,
constraints, etc. in the *.ndf file rather than in the *.mdf file.

Does this make it any easier to transfer/copy files or databases or
other items from test/dev to production??

If I have a database already with items in the *.mdf file, how do I
transfer things like tables, constraints, views, etc. to an *.ndf file
in another database??

I also read that one can make it the default in SS2005 to store things
in the *.ndf file, how is this done??

Thank you,
Tom

View 5 Replies

Need To Cache Or Store These SqlDataSource Objects

May 2, 2008

I have the following:omegalove.comIf you go to the search portion u will notice that there are three dropdownlist that are populate using sqldatasource object.I do not want these two post back. Is there a way we can cache this so it is faster.I would like to learn. I appreciate any help. Please don't give me links. I much rather learn from someone who has hands on.Thank you
I will have to separate the code from the ui?---------------------------------------------------------------------
Country:<asp:Image ID="FlagImg" runat="server" Height="12px" Width="20px" />

<asp:DropDownList ID="ddlCountry" runat="server" DataSourceID="SqlDSCountry" DataTextField="Country"

DataValueField="CountryID" AutoPostBack="True" OnDataBound="ddlCountry_DataBound" OnSelectedIndexChanged="ddlCountry_SelectedIndexChanged">

</asp:DropDownList>

<asp:SqlDataSource ID="SqlDSCountry" runat="server" ConnectionString="<%$ ConnectionStrings:omegaloveConnectionString %>"

SelectCommand="SELECT [CountryID], [Country] FROM [CountryCodes] ORDER BY [Country]">

</asp:SqlDataSource>

----------------------------------------------------------
State/Province:<br />

<asp:DropDownList ID="ddlRegion" runat="server" AutoPostBack="True"

DataSourceID="SqlDSRegion" DataTextField="Region" DataValueField="RegionID" OnDataBound="ddlRegion_OnDataBound" OnSelectedIndexChanged="ddlRegion_SelectedIndexChanged">

</asp:DropDownList><asp:SqlDataSource ID="SqlDSRegion" runat="server" ConnectionString="<%$ ConnectionStrings:omegaloveConnectionString %>"

SelectCommand="SELECT [RegionID], [Region] FROM [SubCountryCode] WHERE ([CountryID] = @CountryID)">

<SelectParameters>

<asp:ControlParameter ControlID="ddlCountry" Name="CountryID" PropertyName="SelectedValue"

Type="String" />

</SelectParameters>

</asp:SqlDataSource>
---------------------------------------------------------------
City :<br />

<asp:DropDownList ID="ddlCity" runat="server" AutoPostBack="True" OnSelectedIndexChanged="ddlCity_SelectedIndexChanged" DataSourceID="DSCity" DataTextField="City" DataValueField="City">

</asp:DropDownList>

<asp:SqlDataSource ID="DSCity" runat="server" ConnectionString="<%$ ConnectionStrings:omegaloveConnectionString %>"

SelectCommand="SELECT [City] FROM [WorldCities] WHERE (([CountryID] = @CountryID) AND ([RegionID] = @RegionID))">

<SelectParameters>

<asp:ControlParameter ControlID="ddlCountry" Name="CountryID" PropertyName="SelectedValue" Type="String" />

<asp:ControlParameter ControlID="ddlRegion" Name="RegionID" PropertyName="SelectedValue" Type="String" />

</SelectParameters>

</asp:SqlDataSource>

---------------------------------------------------------------------------------------------------------------------------------------------------------------
This is my behind code.
using System;using System.Data;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using OmegaLove;using OmegaLove.UI;namespace OmegaLove.UI.Controls{ public partial class Search : BaseWebPart { protected void Page_Load(object sender, EventArgs e) { } protected void ddlCountry_SelectedIndexChanged(object sender, EventArgs e) { FlagImg.ImageUrl = "../images/flags/" + ddlCountry.SelectedValue + ".gif"; ResetRegion(); ResetCity(); } protected void ddlRegion_SelectedIndexChanged(object sender, EventArgs e) { ResetCity(); } protected void ddlCountry_DataBound(object sender, EventArgs e) { ddlCountry.SelectedIndex = 39; FlagImg.ImageUrl = "../images/flags/" + ddlCountry.SelectedValue + ".gif"; } protected void ddlRegion_OnDataBound(object sender, EventArgs e) { ResetCity(); } private void ResetRegion() { ddlRegion.Items.Clear(); // ddlRegion.DataBind(); if (ddlRegion.Items.Count == 0) { ListItem item = new ListItem("Not Available"); ddlRegion.Items.Add(item); } } private void ResetCity() { ddlCity.Items.Clear(); // ddlCity.DataBind(); if (ddlCity.Items.Count == 0) { ListItem item = new ListItem("Not Available"); ddlCity.Items.Add(item); } } protected void ddlCity_SelectedIndexChanged(object sender, EventArgs e) { }}}

View 6 Replies View Related

Store Objects In Sql Server 2000

Oct 25, 2004

How can we store native .NET objects like arraylists, hashtables in Sql Server? Is this possible? If so, can anybody provide some insight on how to do this?

Thanks

View 4 Replies View Related

Cross Referance DB Objects Accross Store Procs

Sep 25, 2006

We are in the midst of cleaning up database01. There are objects in database01 that are widely used in store procedures that reside in database02.

Problem is: I need to know which tables and view from database01 are in use by store procedures in database02. This is important because if I accidently decommission tables that are currently in use by production class s-procedures, it will not be pretty. A sample output could look like:

StoreProc UsingObject
sp001 ctblCodeName
sp002 tblUnitSales
so003 tblSalesTrans
.......... .................

I am not a programmer and none of our programmers here claim that there is any solution to this problem without spending thousands on s/w licenses. Any simple solution + code snippet that will help me resolve this problem by myself would be incredibly valuable.

In disstress and frustration . . . .

JJOSHI

View 4 Replies View Related

Good Practice When Working With Objects Using SQLServer As A Secure Store.

Oct 11, 2006

I'm sure this has been asked plenty of times before, so I'm after a link to a good answer.

I have tens of thousands of milk crates, holding dozens of different types of milk in hundreds of locations. I am used to working with objects but not databases. For this situation however I want the security of SQLServer transactions to track, for example, when a robot moves a crate from one location to another.

I am thinking of using SQLServer as a store. On startup I want to get my ecosystem of objects out of the store. While I am running, I'll just use objects. When I change an object property I want it to securely persist. I don't want to snapshot the whole menagerie of object states, just update the values that changed. Which will sometimes include the addition or deletion of objects. How do I do this? Is there an example somewhere that does this (or approximately this)?

I use VB and have Visual Studio 2005. (Which, by the way, is stunning. I thought all that "you will use less time and code more and better" talk was just hype. But its for real. Amazing product.)

tia

John

Store Db Objects In *.ndf Vs. *.mdf??

Store Db Objects In .ndf Vs. .mdf??