Database Discussion Boards

First Prev Next

Re: Book recommendations

Rob Graham15-Jul-05 4:21

Rob Graham

15-Jul-05 4:21

MSDE is Sql server. SQL Books On line can be downloaded here.[^]

Absolute faith corrupts as absolutely as absolute power
Eric Hoffer
The opposite of the religious fanatic is not the fanatical atheist but the gentle cynic who cares not whether there is a god or not.
Eric Hoffer

Re: Book recommendations

PJ Arends15-Jul-05 6:20

PJ Arends

15-Jul-05 6:20

Thanks for the link Rob, I am downloading right now Smile | :)

"You're obviously a superstar." - Christian Graus about me - 12 Feb '03

"Obviously ??? You're definitely a superstar!!!" - mYkel - 21 Jun '04

"There's not enough blatant self-congratulatory backslapping in the world today..." - HumblePie - 21 Jun '05

Within you lies the power for good - Use it!

Database redesign

Mincy George14-Jul-05 4:53

Mincy George

14-Jul-05 4:53

I have an sql table with many varchar columns and the row size exceeds 8000 max.
If I redesign the table to make the lengthy columns to text data type, what are the implications on the data?
any other issues?
TIA.

Re: Database redesign

Michael Potter15-Jul-05 5:31

Michael Potter

15-Jul-05 5:31

If the rows that are changed to text are rarely used - you may see a speed increase. If they are heavily used, then you may see a speed decrease. Client code won't need to change that much. There are more restrictions in Stored Procs on the manipulation of Text Fields.

Text fields are stored in a seperate place from rest of the table data. Therefore, it takes a minimum of 2 IOs for the SQL Server build a query result that contains a text field.

Re: Database redesign

Rob Graham16-Jul-05 7:55

Rob Graham

16-Jul-05 7:55

A better approach would be to take a hard look at the table design, and see if you can split the table into several smaller ones.
Text (or NText) columns can't be used in 'Like' queries (you would have to use ful text search) and they will introduce a performance hit, since the data is stored in a binary tree rather than in the table (the table will only contain a pointer to the root of the tree). this results in at least one additional disk IO for each field returned (possibly more if the field was large, and had to span several allocation nodes on the storage tree).

Certainly you have more data per row than can easily be displayed, so I would think multiple tables with a common foreign key would work.

Absolute faith corrupts as absolutely as absolute power
Eric Hoffer
The opposite of the religious fanatic is not the fanatical atheist but the gentle cynic who cares not whether there is a god or not.
Eric Hoffer

Re: Database redesign

Anonymous18-Jul-05 6:20

Anonymous

18-Jul-05 6:20

Thanks all.
I agree to the idea of spliting the table with foreign Key relations
than changing to text fields.
thanks again.

Import data to SQL server

cberam14-Jul-05 1:06

cberam

14-Jul-05 1:06

Hi,

I have a foxpro dbf file and I want to copy the data from mdf to sql server,
how can I ? I have tried through the sql server Import wizard but failed to
do this....Pls help

Thanks
Ram

Re: Import data to SQL server

phokojoe14-Jul-05 2:35

phokojoe

14-Jul-05 2:35

Try the Data Transformation Services import/Export wizard of the sql server and choose the correct data source.

Does it work! Smile | :)

phokojoe

Re: Import data to SQL server

Vasudevan Deepak Kumar15-Jul-05 3:03

Vasudevan Deepak Kumar

15-Jul-05 3:03

Hi Ram:

By 'Import Wizard', did you mean DTSWiz (Data Transformation Services Wizard) with SQLServer.

What is the error that you are encountering along?

Deepak Kumar Vasudevan
Personal Web: http://vdeepakkumar.netfirms.com/
I Blog At: http://deepak.blogdrive.com/

Change SQL Server startup account to SA

Toms Edison14-Jul-05 0:40

Toms Edison

14-Jul-05 0:40

Hi,
Anyone got source code to change SQl Server startup account to SA.
I need this to be run in my installation.

VB script, java script or installscript will be very helpful.

Thanks
Toms

Re: Change SQL Server startup account to SA

Colin Angus Mackay14-Jul-05 2:35

Colin Angus Mackay

14-Jul-05 2:35

Toms Edison wrote:
change SQl Server startup account to SA

This doesn't make sense. When you make a connection to SQL Server you specify the account that you want to use. There is no "startup account".

My: Blog | Photos
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

<help me>Access

vtalau13-Jul-05 23:43

vtalau

13-Jul-05 23:43

Help me
I have a trouble again with M.Access. I have a combo-box on a form, and this combo-box has the responsibility on showing the Query which creates the 4-column table, including Company,Name,Address and ClientID.

My purpose is that I want to show this Query in the combo-box in the order A-Z, before the blank company items.
My solution:
I create a query like below:
select .........
from nhanvien
where company is null
union
select .........
from nhanvien
where company is not null
However, the result isn't right like my hope. I think that the reason is because of the order of the ClientID which is the primary key...As a result, the destination query automatically sorts on the ClientID order.
Thinking of the solution :
I don't know how to do to archieve that result. I think so much about the SQL sentence of the above query. I believe that there's another SQL sentence helping me to solve this problem. I'm very happy whether you give me a SQL sentence to do that or another solution to obtain the same result ....

Thanks so much <vtalau>

Re: <help me>Access

Rob Graham16-Jul-05 8:33

Rob Graham

16-Jul-05 8:33

<br />
Select Company,... from nhanvien where company is NOT NULL<br />
 Union<br />
Select Company,... from nhanvien where company is NULL<br />
order by Company ASC<br />
<br />

This wont quite accomplish what you wan, the null values will sort to the top, not the bottom, but at least the non-null values will be sorted a-z for you.

an alternative would be to do this in two steps:
selecting all the not-null records first:

<br />
Select Company,... from nhanvien where company is NOT NULL order by company ASC<br />

and add the records to the combo box
then add the remaining values with a second query not sorted

<br />
Select Company,... from nhanvien where company is NULL <br />

and add the results to the combo (don't clear the first set of results)

Absolute faith corrupts as absolutely as absolute power
Eric Hoffer
The opposite of the religious fanatic is not the fanatical atheist but the gentle cynic who cares not whether there is a god or not.
Eric Hoffer

Database access error

neoms2113-Jul-05 20:19

neoms21

13-Jul-05 20:19

hi all,

i am facing a prob lem in accessing database over network.
i should elaborate the problem bit more
look if use the connection string as below then it works fine,

"PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=C:\xyz\abc.mdb;"

but when i try to use it as
"PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=\\webbdv\jkl\mmm.mdb;"

where webbdv is computer name which is residing on network and not my local machine then application gives error
'Disk or Network Error'

hopefully you are having answer for this question waiting for your reply
thnking in anticipation
neoms21

Re: Database access error

Christian Graus14-Jul-05 11:32

Christian Graus

14-Jul-05 11:32

The most obvious question is, can you see that folder on your network from that machine, without having to log in to it ?

Christian Graus - Microsoft MVP - C++

Re: Database access error

neoms2114-Jul-05 17:49

neoms21

14-Jul-05 17:49

yes i can see that folder even access them and edit i am having all security privilleges.
but when ran in application it doesn't get access.

Re: Database access error

Christian Graus14-Jul-05 17:53

Christian Graus

14-Jul-05 17:53

The user that your site runs under needs access. When you're browsing, you're not doing it as that user. How is the site written ( asp/asp.net/etc ? ). Do you know the user your site runs as ? Does IIS allow anonymous access ( if so, you're probably running as an anonymous user ).

Christian Graus - Microsoft MVP - C++

Re: Database access error

neoms2115-Jul-05 1:29

neoms21

15-Jul-05 1:29

yes IIS allows anonymous access.
and my site http://webbdv/firstpage.aspx

bulk import of data through C#

PSI@work13-Jul-05 8:33

PSI@work

13-Jul-05 8:33

i have data in bulk in Txtfile delimited by commas and row by CR, I want to iport this data into my msSQL server "PS101" , Database = "RAW_MSG", Table name = "RAW_MESSAGE".

how can i do it please help....i am new to C#....i have to do it through console programming...can anyone give a lead by how to connect to server and bulk import a data and fill the database.

thanks for anyhelp
in advance

Bose

Re: bulk import of data through C#

Christian Graus14-Jul-05 11:34

Christian Graus

14-Jul-05 11:34

The SqlConnection[^]class is your starting point, you should find all the example code you need for the database connection stuff from that link.

Here[^] is a quick link to how to read text files in C#.

Christian Graus - Microsoft MVP - C++

help me...Access

vtalau12-Jul-05 23:47

vtalau

12-Jul-05 23:47

help me...
I have some troubles with M.Access. I want to create the calendar control on a form of my Access database like the calendar control of vb.net or C#. However, I can't find the way to do that .Thus, I'm very happy if you help me...

Re: help me...Access

Marc Soleda19-Jul-05 20:58

Marc Soleda

19-Jul-05 20:58

You have insert the "Microsoft Date And Time Picker Control". Usuary it's at the tools floating window, if it isn't, you'll have to search for it in "ActiveX Controls" in the Tools menu. Usually, it's available, but it depends on your Access installation.

Marc Soleda.

... she said you are the perfect stranger she said baby let's keep it like this... Tunnel of Love, Dire Straits.

call dts package

hakanaktan12-Jul-05 20:35

hakanaktan

12-Jul-05 20:35