Add A Second Databse - Benefits?

Jul 20, 2005

Hi, there is an existing application running on a SQL Server database.

Now I have to built a different app, which will have two common tables
with the existing database (Customers, sales)

Is there any benefit (performance mainly) creating the tables for the
new app in a new database? (On the same machine and the same instance)




*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

View 3 Replies


ADVERTISEMENT

Benefits Of Using SQL Over XML

Jan 22, 2007

Hi,

I have a question relating to XML and SQL. My company currently runs a website which allows its clients to log in, view their accounts and transaction history online. The website is totally read only with the exception of changing passwords.

The data is taken from our back office system overnight which runs an oracle 8i database (we cannot like our website to the database due to the agreement we have in place with our software supplier). The data is written to a CSV file which is then converted into XML. The XML file is saved to the webserver and is referenced by the website.

The structure of the website has a relationship where the Client has a Manager who can see their clients accounts, a Branch level that can see all of their Managers and the underlying clients and then finally a company level that sees everything.

We are finding that using XML is causing a real issue in performance and I was wondering if migrating the website to SQL server would improve the performance of the queries etc .

Any advice would be gratefully recieved



Lee

View 4 Replies View Related

SQL Vs Access. Benefits Between The Two?

Apr 8, 2005

I was just wondering what if someone can summurize the benefits between using Access and SQL for an ASP.NET 2.0 website? Can you use an Access database that doesn't have SQL installed on it with ASP.NET?

View 3 Replies View Related

Benefits To Using Identity

Jul 23, 2007

I'm designing a database and was researching common conventions and standards. I found that some people don't use the identity column for a primary key because they prefer to create their own unique id number for the column. Whats your opinion?

Ryan

View 1 Replies View Related

Any Benefits To Using A Db That's Placed Under A Data Connection?

Jan 16, 2008

I find that in Database Exporer in Visual Web Developer, I can specify a DB in two ways, as exemplified here:
Data Connetctions  + ke_test_db.mdf  + ssftec023-lsqlexpress.master.dbo     + ke_test_db2.mdf
Experimentation shows that mdf files that can be put under the "sqlexpress" item (ke_test_db2.mdf in the example) are those that SQL Server Configuration Manager Express knows about, whereas files that I create via adding an item in Solution Exporer appear at the top level (ke_test_db.mdf). My question is, is there any advantage or disadvantage to either architecture? I.e., Is there any advantage to being sure that one's DB files appear under the sqlexpress connection item?
 Thanks!
-Kurt Euler
 
 
 
 

View 2 Replies View Related

SQLDatasource Benefits/drawbacks - When To Use?

Apr 14, 2008

Hi,
I've never really used the SQLDatasource, I usually fill a dataset & use that. When would you use an SQLDatasource? I notice it doesn't return dataviews but I also noticed that you don't need to open the conenction. Any ideas on best practice?
Many thanks

View 5 Replies View Related

Benefits Of SQL Server 2000

Jan 13, 2004

Could someone hit the high points of the benefits of using SQL Server (vs. other databases) with Visual Studio .NET and the .NET Framework.

Thanks

View 5 Replies View Related

Simple Function Benefits

May 18, 2007

Hey all,

Very simple question from a real n00b: In many of my stored procedures I am repeating a CASE statement where I'm replacing null values with zero, like this:

(CASE WHEN @Field IS NULL THEN 0 ELSE @Field END)

I have many SPs where I have that code repeated literally dozens of times. Is there any performance benefit to creating a function to perform this task and using that instead of the repeated CASE statements? Or am I trying to be too clever?

Thanks!
Ron Moses
ConEst Software Systems

View 5 Replies View Related

SQL Log Files - Benefits And Need For Multiple

Oct 12, 2006

Hi,

When do we need to have multiple log files for one Database.
What performance counters should I measure before deciding to go for multiple log files.

Any comments / suggestions are welcome.

Thanks,
Loonysan

View 1 Replies View Related

Benefits/drawbacks With NVarChar(max)

Feb 15, 2006

Hi,

I wonder if there are any drawbacks with NVarChar(max) contra e.g. NVarChar(40) when it comes to performance and amount of storage used?

Are there other arguments to use e.g. NVarChar(40) than that you have more control of how long the strings are when you set the upper limit?

I'm using Sql Server 2005.

Tomsi

View 1 Replies View Related

Identify Edition Of SQL Server And Benefits

Mar 31, 1999

Hi

How can I find out which edition of SQL Server is running on my server ?

Also what would be the difference in terms of features between standard edition and enterprise edition ?

Thanks

Vijay

View 1 Replies View Related

Benefits Of SQL Server On Windows Server 2008

Feb 12, 2008

I have read over the feature set and I really don't see a huge reasons to jump on the bus. There are a few niceties like IP enhancements, cluster enhancements and maybe bitlocker for the backup drive. Am I missing something?

View 3 Replies View Related

Searching A Databse

Aug 31, 2006

i'm making a web page for a clinic.it needs to be able to search for patients by first name, surname, date of birth and patient number.i'm using visual web developer and i have my database, my data source and GridView grid.i want  4 text boxes for my first name, surname etc. when u click enter on any of them i want to retrieve all their data and display it in the gridview.at the moment i have  one text box on the web page and through the "Configure data source" option on the grid view i can retrieve the specified data but for only this one item, e.g. SELECT * FROM [Patients] WHERE ([DOB] = @DOB). if i add another text box to my web page, and don't do anything to it, the query wont run. if i add and "AND" statement to the query, e.g. SELECT * FROM [Patients] WHERE (([DOB] = @DOB) AND ([FirstName] = @FirstName)), again it won'r run or return and data. any ideas on what i can do or where i'm going wrong. thanks 

View 1 Replies View Related

New Databse - Notification

May 18, 2000

Does anyone know how I can receive some type of notification (an alert) that fires when a new database is created (or an old one deleted) on a server?

Thanks.

View 1 Replies View Related

Databse Replication

Sep 10, 2007

Dear All I've made transactional replication between two SQL 2005 servers.Everything looks fine, synchronization working fine, no errors, however size of replicated database file = 97 Mb,on Publications server the database file size = 184 Mb. What is wrong :S ? Best RegardsPiotr

View 5 Replies View Related

How Can I Create Databse?

Apr 6, 2008

Hi,
I had downloded MS SQL express from Microsoft. But i did not find any place from where i can create databse, table etc..

please help me regarding this.

thanks
Sabbir

View 3 Replies View Related

Connection To Databse

Jun 29, 2006

hi, im totally new to this sql thing.
i have a set of classes here and my objective is to show that they can connect to the database. how am i supposed to do this?

can i post my classes here? theres a lot..

View 8 Replies View Related

How To Clear The Whole Databse?

Apr 7, 2007

Hi, my database i am working on is full of crab, who do I clear all the tables info?

View 3 Replies View Related

Databse Creation

Aug 2, 2007

How to create a database in MS SQLserver 2005 express edition.
Pleae help me to get started.I have learned some SQL commands.
But i want to execute those in SQLserver 2005.But i don't know the procedure for creating a database.please help me on this.

View 5 Replies View Related

Designing Databse

Sep 21, 2007

Im creating a sample database for purposes of keeping track of employee's jobs + billing codes for that job. currently they just use an excel spreadsheet to keep track of billing.

Question 1:

What would be the easiest way for the manager to enter billing codes? Billing codes are numbers like 956, 958, 805 and they co-relate to prices for each billing code.

1. I want the manager to enter the billing code and have the sql database find out how much that code is and add them up daily. This would prevent the manager from having to input prices and billing codes, and extra step.

Any links on the above topic would be helpful. I'm not looking for anyone to spoon feed me code just point me in the right direction. Im relatively new to sql having only a class of sql @ ITT.

Heres the way I have the db tables laid out currently.

employee table
employee_id
technumber
fname
lname
address
workphone
homephone
trucknumber
officelocation

employeejobs table
employee_id
jobs_id

jobs table
jobs_id
codes
date
timeframe
city

hours table
hours_id
employee_id
hoursworked
month


Any info would be much appreciated, Im going to go find a sql book now ;).

View 1 Replies View Related

Databse Offline

Jul 20, 2005

hi everyoneCould someone please help me in following:One of my database in SQL 2000 going Offline automatically. When ibring it back Online its Ok for 20/30 minutes and then again appear asOffline. I had similar problem when one of the database keep going to'Single user' automatically.Any idea what happening.Thank you*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!

View 1 Replies View Related

Lost Databse

Jun 21, 2007

I went and detached a database. It is no longer showing in EM. I try to attach the database and I do not have any MDF files anywhere on my PC. Where did my database go when I detached it? How can I get it back. Please help.



Thank you

View 6 Replies View Related

How To Transfer Databse ..

May 7, 2007

Hi,

I am doing one E-commerce Application , throgh C#. & sql server express editon. Both my Local & Web Hosting servers are in sql server express 2005. I designed Databse Throghly, to my local server. Now I want to Transfer tables to my web server. I have already Sql server mangement studio Express. I can not do.. I spent, more than 5 yrs time..

Please help asasp..

Thanks

Partha

View 1 Replies View Related

Restoring A Databse

Oct 4, 2006

I have a system running on SQL Sever and i am trying to create a second file on a diffrent computer so that I can teach people how to use sql sever (express) without risking losing any data that I have on my proper database.

I have created a backup of my database which is in a dmp file and I would like to import this into SQL Server Management Studio Express so that I can make changes to the databse without affecting the one that is running on my website.



Cheers for any help

View 10 Replies View Related

How Do I Create A Databse Link?

Nov 6, 2006

I would like to run some queries  on two tables that reside in two different database (located on the same server). The databases are both MS SQL 2000.How do I create a database link (or a table link??) so that I can create the queries from the Enterprise Manager or the Query Analyzer? Thanks a lot, Christian 

View 1 Replies View Related

2 Connections To The Same Databse Is Not Allowed?

Dec 1, 2006

I am using the SQLEXPRESS database, and connect from to locations:

Windows Service
ASP.NET web application.
 
whenever I start the windows service I get the error: Cannot open user default database. Login failed.
so I am going to visual studio and close the connection. then I close the web browser, and the windows service succeed connect to database.
but then, after windows service is connected, I open the web browser application and fails to login because the login system using the same database of windows service, and since the connection is being used by windows service, login is impossible.
 
Do you know how I can allow 2 connections at the same time for the same database?
what are the risks to do that? and how do I handle this risks.
thanks alot 
 
 
 

View 3 Replies View Related

Unable To Access SQL Databse

Mar 2, 2007

Hi,
I have a SQL Server 2005 Express database dbase.mdf which I cannot access. It works fine in VWD and the development server using the following connection string: String connectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\dbase.mdf;Integrated Security=True;User Instance=True"But when the site is not on the development server but on IIS, I get a SqlException saying "User does not have permission to perform this action." when I execute the connection.Open() command. I find it extremely frustrating that something which works in the development server fails on the real server. Can anyone help me with this? Do I have to change my connection string, or perhaps set some permissions...I have already given the IUSR_MACHINENAME account and the ASPNET account full access to dbase.mdf. Surely this must be an issue that lots of people deal with... How do other people manage to log to access databases? Any help would be much appreciated.  Thanks,P1000

View 4 Replies View Related

Updating Databse Thru Datadapter .................

Dec 27, 2007

can any body tell me how to update the database thru dataadpater ???????
and another imp thing.........
if there r 2000 rows in database ..........and updation of 2 rows takes place
i want that whole of the database should not be updated ......only those two rows are updated
 
Can any one help me please??????
thanks in advance

View 1 Replies View Related

Simple Databse Connection

Jan 5, 2008

hello all
the problem with me,im for the first time using SQL Server and ASP,so i have little knowledge baout these two progs.i want to know how pages in ASP are connected to databse.
second, i installed SQL Server2005 along with asp from the same CD(option of instalation of both was available). There is also a way use SQL Server within the ASP Environment(addnew itmes>sqldatabase>).
Question: if i create a databse through above method. then how i will use it in asp.net.Although i can do it by draging "SQL Data sourcr" from "Data" category in the "toolbox"however, i want to manually connect the application to Db.Something like this
Page_load(0
{
//db connection code goes here.//sqlcommand goes here.
con.open()
}
 i want some controls like txtboxes and label to manualy connect to databse tables.
plz someone forward the code,
 

View 1 Replies View Related

How To Know Existence Of The Data In The Databse

Jun 9, 2008

Hi Friends,I have one table in the databse,i.e userTable with one field userNameIn my form I have one Label ,textbox for entering the userName and One button for submit,So I am entering the data into the table(userTable) after clicking on the submit buttonBut my problem is before entering the data into the table I want to find wheather the given data exits or notif its not exists the data has to insert into the table otherwise its has to display the message"the user is already existed"for this I wrote the code like this in C# public Boolean isUserExists()    {        SqlCommand cmduserName = new SqlCommand("select count(*) from userTable where userName= " + txtuserName.Text + ")", conn);        SqlDataReader rdr = null;        rdr = cmduserName.ExecuteReader();                 conn.Open();               int count = 0;        while (rdr.NextResult())        {            count = rdr.GetInt32(1);        }        conn.Close();        if (count == 0)        {            return false;        }        else        {            return true;        }              protected void Button1_Click(object sender, EventArgs e)    {        if(isUserExists())            {                Response.Write("Opps ! User already Exists");                                       }                SqlCommand adapInsert = new SqlCommand("insert into userName values('" + txtuserName.Text + "')",conn);        conn.Open();        adapInsert.ExecuteNonQuery();        conn.Close();        Response.Write("data inserted");       }   is it write or not because I am not getting the output .please tell me any one where I have to change the code ThanksGeeta 

View 3 Replies View Related

Active Databse Copy

Feb 23, 2004

Hey guys,

I have to copy a databse from one server to another(both sql servers). Now the copy databse wizard wont work as the database is active( ie its open all the time), is there any other way to copy it to a different server while its in active session.

AM

View 2 Replies View Related

Copy Databse To Another Server

Nov 4, 2005

Hello,,
I backed up my database and it created a BAK file. Now I move this file to other server and trying to restore from it. It is giving me error: Device activation error. Do I have to create database before restoring. I do not have this database available in other server and I need to copy database with all constrains and tables.
Thanks,

View 2 Replies View Related

Creating A Databse With Parameters

May 31, 2000

when i was trying to create a database like
CREATE DATABASE @dbname
i am getting the message
Incorrect syntax near '@dbname'.

is it possible to create a database like this
if yes how

Thanks alot on advance.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved