|
Hi,
You don't create sa user. sa is created byt the SQL Server when you choose mixed security mode during the installation or later via instance properties. So sa is a special user defined when SQL Server authentication is enabled, kind like administrator in windows.
[Added]
To change the authentication mode, for example: http://msdn.microsoft.com/en-us/library/ms188670.aspx[^]
The need to optimize rises from a bad design.My articles[^]
modified on Saturday, March 12, 2011 12:44 PM
|
|
|
|
|
overloaded Name wrote: There got to be something wrong with my user creation
I suppose that is possible if
1. Your wrote your program in C/C++
2. You have a bug (or several) in your code.
Supposing that the first is true then when you attempt to interact with the database you will get error information back (if your code doesn't have bugs.) So reporting that information is useful. And if that error is such that the app can no longer proceed then the application should gracefully exit.
|
|
|
|
|
In my company we are using a SQL Server 2005 Database to manage all our client and job records. However this database was originally designed by someone in the company who didn't know much about the database. We are reaching a point in our growth were this database needs to be converted to a relational database. So I copied the database locally to work with it. I used Access (2010) to analyze the database and set up the tables. When I go through the wizard I get to the last step where it shows all the data that seems to be similar so I can select what each record should be (correcting typographical errors step). This will eliminate duplicate client names, site names, etc. However there are over 10,000 records in the database, and to go through this manually would take a long time, as it seems there is no way to start it and finish it at a later time. Does anyone have an recommendation on how I can go about making this flat database into a relational database relatively easily? There is approximately between 16,000 and 17,000 records. Thanks in advanced for any help or suggestions.
modified on Friday, March 11, 2011 11:48 PM
|
|
|
|
|
Hi,
One possibility is to use 'temporary' tables and DISTINCT queries. For example if you have a table with column SiteName and you have duplicate site names, you could do something like:
SELECT DISTINCT SiteName INTO NewSites FROM Sites;
TRNCATE TABLE Sites;
INSERT INTO Sites SELECT * FROM NewSites;
DROP TABLE NewSites;
In the real situation you most likely have more coĺumns and possibly other conditions. This is why I chose this 'temporary' table approach since you can easily check if the result is fine before you delete the original data and possibly do the duplicate elimination in smaller parts if that's more suitable.
This can also be done in-place if you have some kind of mechanism to identify the row. If a table has an Id that's preferred and if it doesn't you could perhaps modify this http://www.codeproject.com/Tips/159984/How-to-remove-duplicate-rows-in-SQL-Server-2005-wh.aspx[^] to your needs.
|
|
|
|
|
DisIsHoody wrote: This will eliminate duplicate client names, site names, etc. However there are over 10,000 records in the database, and to go through this manually would take a long time, as it seems there is no way to start it and finish it at a later time. Does anyone have an recommendation on how I can go about making this flat database into a relational database relatively easily?
Second did not cause the first problem.
That same problem can occur in a relational database.
As per the other posting you can use distinct to eliminate duplicates but only on exact matches. Consider the following entries.
Mikes Auto 431 W. Main Street
Mike Auto 431 W. Main Street
Mikes Auto 431 West Main St.
Which of them are duplicates? Can one create code that eliminate duplicates from a list like this? Yes. Is it worth it for 10,000 records? Depends.
|
|
|
|
|
Watch using Access to SQL as Microsoft helps you by creating columns that are NOT what is wanted.
I have to live with postal code being a float because the person moving data from Access to SQL did not know what they were doing. As long as we only do work in the US it is not a major problem but comparison can be tricky.
|
|
|
|
|
Hello,
We are retiring our older server, not yet, in place going to have a new server. WE need to name the new database server as our current one. Can we have two such database servers at a given time? How can we migrate from one server to another with no lag time, since it is the production server constantly collecting data.
Thank you.
|
|
|
|
|
Hi,
vanikanc wrote: WE need to name the new database server as our current one
First let's separate two totally different things:
- the name of the database server is just an alias for the IP-address. So this means that you cannot have two different machines having the same name (thus the same IP-address) at the same time or you'll have enormous problems in you network
- the name of the SQL Server instance (the service) is used to distinguish separate SQL Server services on the same machine.
So basically your question is client-related. If you want to make the switch-over to the new (physical) server you have to be able to re-configure your clients to start using the new server. For example if your old SQL Server is ServerProduction1\Instance1 (meaning for example 10.1.123.1,1433\Instance1) you would change the client to connect to ServerProduction2\Instance1 (meaning for example 10.1.123.7,1433\Instance1). Of course the instance name can also be changed.
vanikanc wrote: Can we have two such database servers at a given time?
So the answer from the client side point of view is no. Which one would they connect to?
vanikanc wrote: How can we migrate from one server to another with no lag time, since it is the
production server constantly collecting data
You restrict the changes to the original database during the transfer, transfer all the data from server 1 to the server 2, re-configure the clients to connect to server 2 and off you go.
|
|
|
|
|
guys i have a table with a self-referencing relationship.
I want to get the child records listed just below their parent.
just like:
id parent value
--- ------ ------
1 null node 1
4 1 node 1/1
6 4 node 1/1/1
5 1 node 1/2
7 1 node 1/3
2 null node 2
3 null node 3
8 3 node 3/1
any help;
Help people,so poeple can help you.
|
|
|
|
|
Include the parent id and the child id in each record and then include them as the first two fields to sort by.
select p.id
,c.id
, .....
from some_table p
,some_table c
where p.id = c.parent_id_field
sort by p.id, c.id
Chris Meech
I am Canadian. [heard in a local bar]
In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]
posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]
|
|
|
|
|
but sir, what about multi-level threads?
Help people,so poeple can help you.
|
|
|
|
|
You will need to know how many levels deep you want to go and join the table for each level. You might also be able to use a view to help with that.
Chris Meech
I am Canadian. [heard in a local bar]
In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]
posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]
|
|
|
|
|
i can't tie a user hands.
is there "Recursion" in sql server.
Help people,so poeple can help you.
|
|
|
|
|
Ali Al Omairi(Abu AlHassan) wrote: i can't tie a user hands.
Sometimes, I wish I could do that.
Chris Meech
I am Canadian. [heard in a local bar]
In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]
posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]
|
|
|
|
|
|
Over my head, mika;
you are still the best.
100
Help people,so poeple can help you.
|
|
|
|
|
Thanks, but frankly I believe that this site has a bunch of real experts thus making CP so special. No other site I've come across has so positive and professional attitude at the same time as this.
|
|
|
|
|
CREATE TABLE #data
(
ID INT NOT NULL,
PID INT NULL,
VALUE VARCHAR(20) NOT NULL
);
INSERT INTO #data
(ID, PID, VALUE)
VALUES
(1, NULL, 'node 1'),
(4, 1, 'node 1/1'),
(6, 4, 'node 1/1/1'),
(5, 1, 'node 1/2'),
(7, 1, 'node 1/3'),
(2, NULL, 'node 2'),
(3, NULL, 'node 3'),
(8, 3, 'node 3/1');
WITH MyCTE AS
(
SELECT ID, PID, VALUE, 0 AS [LEVEL]
FROM #data
WHERE PID IS NULL
UNION ALL
SELECT D.ID, D.PID, D.VALUE, [LEVEL] + 1
FROM MyCTE M
JOIN #data D
ON D.PID = M.ID
)
SELECT ID, PID, VALUE, [LEVEL]
FROM MyCTE;
DROP TABLE #data;
|
|
|
|
|
thank you Russell.
100
|
|
|
|
|
About me adam763 aadams
CaringIn Action adam763 aadams
LocalBusiness adam763 aadams
From My Desk adam763 aadams
About me agga924 aaggarwal
From My Desk agga924 aaggarwal
LocalBusiness agga924 aaggarwal
About me aldr231 aaldridge
From My Desk aldr231 aaldridge
About me alkh290 aalkhazshvilly
LocalBusiness alkh290 aalkhazshvilly
From My Desk alkh290 aalkhazshvilly
About me alti800 aaltis
From My Desk alti800 aaltis
About me arev258 aarevalo
From My Desk arev258 aarevalo
About me arri922 aarriaga1
From My Desk arri922 aarriaga1
About me bakk607 abakken
bout me bart768 abarton
From My Desk bart768 abarton
i need the data to be present as
in the first column repeated text is there
for suppose Title TitleCount
About Me 23
after this i have to display
Title UserName Usersite
About Me barttt xxxxxx
About Me xxxx xxxxx
About Me xxxx xxxxx
|
|
|
|
|
I may or may not be responsible for my own actions
|
|
|
|
|
what are you trying to say
|
|
|
|
|
Your post makes very little sense. Can you try and better explain what you are trying to do as at the moment all you have is a list of poorly formatted values
I may or may not be responsible for my own actions
|
|
|
|
|
do you mean you want to group data?. if so, use <a href="http://www.w3schools.com/sql/sql_orderby.asp" target="_blank" >order by</a> .
Help people,so poeple can help you.
modified on Friday, March 11, 2011 2:16 PM
|
|
|
|
|
How can ORDER BY help in GROUPING data ? (I think you meant GROUP BY)
|
|
|
|