Sergei,

Do you have any data that suggests that MSSS is bad for this purpose, or any data that Exchange or Lotus Notes are better in some way?  Or any...

In the ideal situation, I think you are better off changing it to decimal, change the scale to nano (x 10-9), and get rid of the exponential part. e.g. 1.23456E-8 Units ==> 12.3456 nanoUnits. ...

By the time you read this, you probably will have already figured it out.  It's the same as in an mdb.  Just set the width of the first column to...

OK, I submitted the script.  If it is accepted, it should be available within 48 hrs.

Have a look, if your interested.

Hi Scott,

I also was tempted to use RegExp, but I am afraid of the performance overhead from object instantiation in T-SQL.  It's also not clear to me how RegExp...

I use the same technique for processing rtf. 

It is much better to create a new column in your table to store the plain text, so that the client program...

Yes, I also use pattterns like '%[^0-9]%', but I had to add a lot more code to handle single decimals and multiple commas spaced 3 digits apart, and I...

This is complicated.  Here are some general guidelines: 

For simple crosstabs, you can use a pseudo-Pivot table.  Search for Pivot Tables and CASE functions in BOL for more info.  There is no...

A few comments about this wide-ranging topic:

1) About http://www.sql-server-performance.com/access.asp  This article is very old and has many very wrong statements about Access performance, and they are especially wrong as...

Do you mean that there are unique primary keys in all the tables?  Because, unique values alone or unique indexes alone may not be adequate for Access and ODBC.

OTOH, if you do...

Indexes are not "Lost."  There is something else going on here.

Your solution implies that you did not have a unique non-nullable primary key (preferably autoincrement) on your table.  This is...

I think you have to specify WITH VIEW_METADATA at the end of the definition of the view.  Look up CREATE VIEW in BOL:

VIEW_METADATA

Specifies that SQL Server will return to...

This is a very broad and deep topic and there are many divergent opinions about how to proceed.

The most contentious issue is whether to store images as linked files (only store the...

"I think I will just push to have our company get out of MS Access."

IMO, I would say that is the wrong response.  I would rather say that you need better...

Compact and Repair does not really help performance very much.  It primarily gets rid of dead space in your data tables, and fixes data inconsistencies.  It does not fix any...