I've got an Access 2003 database linked to a SQL Server 2000 database. <BR><BR>In SQL Server (Enterprise Manager) - the field is listed as:<BR>Data Type: text, Length: 16, Allow Nulls = Yes<BR><BR>In ...
The indexes on a the tables of a large database make a huge difference in its performance and utility. Without an index, locating a single record in a large table can take several seconds; with the ...
I've said it before and I'll say it again: If you want to speed up your application, don't look at your code, look at your data access. The two slowest things you can do in application development are ...