Click here to Skip to main content
15,741,083 members
Home / Discussions / Database
   

Database

 
GeneralRe: SQL: finding out if a column is NULL /without/ downloading all the content Pin
Scott.Chappel27-Oct-03 1:54
Scott.Chappel27-Oct-03 1:54 
GeneralRe: SQL: finding out if a column is NULL /without/ downloading all the content Pin
moredip29-Oct-03 1:20
moredip29-Oct-03 1:20 
Generalduplication !! Pin
bora3ee26-Oct-03 11:31
bora3ee26-Oct-03 11:31 
GeneralRe: duplication !! Pin
Edbert P26-Oct-03 13:31
Edbert P26-Oct-03 13:31 
QuestionADO.NET: Is it possible to create a dataset out of a view? Pin
Rakesh Rajan26-Oct-03 1:15
Rakesh Rajan26-Oct-03 1:15 
QuestionHow to return a boolean value from a Stored Procedure? Pin
sacoskun25-Oct-03 3:38
sacoskun25-Oct-03 3:38 
AnswerRe: How to return a boolean value from a Stored Procedure? Pin
Paul Watson25-Oct-03 4:28
sitebuilderPaul Watson25-Oct-03 4:28 
QuestionWhy the connection is so slow? Pin
yyf24-Oct-03 8:46
yyf24-Oct-03 8:46 
I run an application in my computer with the sqlserve installed in my computer too.

But when my code goes to :

SqlConnection conn = new SqlConnection("...");
conn.Open();

It's very strange that sometime it took so long to open the connection, about 4 seconds. But sometime it's fast, it took no more than 1s to finish.

I tried it many times. All the tests are done after restarting the computer, so the environment should be very clean.

Any one know why? Please kindly tell me.

Thanks in advance!


AnswerRe: Why the connection is so slow? Pin
Paul Watson25-Oct-03 4:31
sitebuilderPaul Watson25-Oct-03 4:31 
AnswerRe: Why the connection is so slow? Pin
Rob Graham25-Oct-03 5:36
Rob Graham25-Oct-03 5:36 
AnswerRe: Why the connection is so slow? Pin
Mike Dimmick28-Oct-03 3:12
Mike Dimmick28-Oct-03 3:12 
GeneralQuery Pin
Anonymous24-Oct-03 3:08
Anonymous24-Oct-03 3:08 
GeneralRe: Query Pin
Rocky Moore25-Oct-03 4:34
Rocky Moore25-Oct-03 4:34 
GeneralRestore Pin
Anonymous22-Oct-03 9:32
Anonymous22-Oct-03 9:32 
GeneralRe: Restore Pin
Terry O'Nolley25-Oct-03 15:02
Terry O'Nolley25-Oct-03 15:02 
GeneralCreate an text field in Access from SQL Pin
Jerome Conus22-Oct-03 3:55
Jerome Conus22-Oct-03 3:55 
GeneralRe: Create an text field in Access from SQL Pin
cyphermox22-Oct-03 12:34
cyphermox22-Oct-03 12:34 
GeneralRe: Create an text field in Access from SQL Pin
Jerome Conus22-Oct-03 19:22
Jerome Conus22-Oct-03 19:22 
GeneralRe: Create an text field in Access from SQL Pin
Chris Meech23-Oct-03 6:18
Chris Meech23-Oct-03 6:18 
GeneralRe: Create an text field in Access from SQL Pin
Jerome Conus23-Oct-03 19:51
Jerome Conus23-Oct-03 19:51 
GeneralRe: Create an text field in Access from SQL Pin
Chris Meech24-Oct-03 2:02
Chris Meech24-Oct-03 2:02 
GeneralRe: Create an text field in Access from SQL Pin
Rob Graham25-Oct-03 5:40
Rob Graham25-Oct-03 5:40 
QuestionSQL 2000: EXECUTE statement context??? Pin
mittalpa21-Oct-03 7:47
mittalpa21-Oct-03 7:47 
AnswerRe: SQL 2000: EXECUTE statement context??? Pin
Rob Graham25-Oct-03 5:43
Rob Graham25-Oct-03 5:43 
GeneralServer Explorer Error Pin
nevhile.net21-Oct-03 6:13
nevhile.net21-Oct-03 6:13 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.