I have to agree with those who warn you against using barcode as primary key. Apart from re-using and changes of barcode, there is also a possibility that a product...

Hello Tim,

in addition to the above, you could also check fragmentation of indexes and run DBCC INDEXDEFRAG, or maybe even better, a full optimization maintenance job on the production DB. Alternatively, try to drop...

I know very little about DTS, so this is just on a chance that the error is raised because of the DISTINCT keyword... quite probably it will fail, too, but...

I tried to guess which of the two possible answers is correct, but my ESP abilities failed me

If the transformation during import suggested by Jeff works with your files, it will be the best way to do this. If you have problems, and need to import the data into...

Interesting thing though... when you CAST/CONVERT to INT, CHAR(160) will raise an error. But if you try CAST/CONVERT to FLOAT, statement will succeed and the nbsp character is ignored, if...

"I also have a scheduled job to run every 10 minutes to 'shrinkfile'."

Well, that could be one of the reasons of bad performance. Imagine...

I agree with alzdba, unless you plan to describe your products in chinese, japanese or other language requiring extensive character sets, you can get rid of Nvarchar in both columns...

Hello Ray,

I don't know the answer to your question, but even the shorter time is quite long... did you consider the possibility to use some application that makes the backup run...

Hello,

you got the answer you need from Ian, just allow me to make one suggestion... To avoid similar problems in future, consider making all changes to stored procedures, views and tables via...

Is it SQL-error? It could also be error message generated by some application using SQL Server database. TDS could be for Tabular Data Stream, but I didn't find any similar...

Depending on what you mean by "vice versa", there may or may not be a better solution. Please could you post precisely what the sorting should be for every value...

ISNUMERIC is not a good way to find out, whether a string contains only numbers - it is rather a test, whether conversion to number will cause error.

SELECT ISNUMERIC('+002') -->...

Could you please explain this in greater detail?

If no updates at all are allowed, set permissions so that everybody is denied the right to update this column. Set the...

This SQL will become considerably simpler, if you calculate the Grade column in one select, and then you can refer to it the way you tried and perform the operations on the computed...