SQL SERVER TIMEOUT PROBLEM
Date: Wed, 30 Jun 2004 11:13:22 +0300
Hi. I have a problem with sql server. I have thousands of record in a
database table. When i want to list all with SELECT * command in asp.net
page, an error message comes : SQL SERVER TIMEOUT.
But when i list with SELECT CITY command there is no error message but the
process is very slow.
Can you help me?
Relevant Pages
- Re: How to handle concurrency issue with better performance?
... Then for timestamp, it will be unique? ... Hitchhiker's Guide to Visual Studio and SQL Server ... We all work with relational database designs and more ... select command). ...
(microsoft.public.dotnet.framework.adonet) - Error: 18456, Severity: 14, State: 16
... to connect to SQL Server 2005 Express Edition from the command line. ... CreateDatabase.sql when run in Management Studio successfully creates ... the database that I require so I know the error doesn't lie there. ...
(microsoft.public.sqlserver.connect) - Error when Logging on - Error: 18456, Severity: 14, State: 16
... to connect to SQL Server 2005 Express Edition from the command line. ... CreateDatabase.sql when run in Management Studio successfully creates ... the database that I require so I know the error doesn't lie there. ...
(microsoft.public.sqlserver.security) - Re: How to handle concurrency issue with better performance?
... Hitchhiker's Guide to Visual Studio and SQL Server ... that have been modified since they were pulled from the database. ... select command). ... I create stored procedure for the update command and assign ...
(microsoft.public.dotnet.framework.adonet) - Re: How to handle concurrency issue with better performance?
... Keep in mind that a timestamp column does not store a date/time value. ... Hitchhiker's Guide to Visual Studio and SQL Server ... We all work with relational database designs and more ... select command). ...
(microsoft.public.dotnet.framework.adonet) |
|
