Speed concern - SQL Server Management Studio Express SELECT statement & also filling of VB.ET dataaset
Posted on 2006-11-20
SQL Server 2005 Express, VB.NET 2005
Computer is a P4 3.2, 1gb DDR400 ram
I am questioning the efficiency of a database I am working with and have several pertinent questions I would like to ask.
Having never used SQL Server until about six months ago I'm not sure what's appropriate and what's not from a speed standpoint. I unfortunately have only MS Access to guage speed by.
I have created several indexes and unique keys in two tables and am attempting a simple select statement in the SQL Server Management Studio Express program.
1) When I open up my accounting table (24K records)....is it appropriate that it take 3-4 seconds to reach the end of the table while retrieving records?
2) Is it better to include individual field names in a SELECT instead of SELECT * ?
3) I read a posting just a few minutes ago regarding the differences between MSDE 2000 and SQL Express where including [DATABASENAME].[dbo]. to SELECT statements improves access time. Is there validity to this?
4) I have the same table in an Access 2003 database. When I open this table in Access there is no delay, with SQL Express there is...as stated in #1. I thought SQL Server was suppose to be lightning fast. What gives?