This looks like a problem with your VB code. Are you using a server-side cursor? If so, try making it client side. An example (omitting any parameters...

You could make the REPLACE solution work by replacing spaces with a 'safe' character first, doing the original process and then resetting the spaces. Of course, you now have...

Would you post the query, please

Look up 'parameter sniffing'.

Create a local variable and set this to the value of the parameter. Then use the local variable in your queries rather than the parameter directly....

Or Pharaoh Akhenaten who came up with the idea of montheism in the first place!

I am surprised that nobody else has mentioned Gavrilo Princep (the assassin of Archduke Franz Ferdinand and the spark for the Great War). While the event itself largely was...

While all those listed are heroes or villains to many people, I would suggest that we should be looking for those who have had a fundamental impact on a global...

Gavrilo Princip

Josef Stalin

Mao Tse Tung

Alexander Fleming

Albert Einstein

Adolf Hitler

Emperor Hirohito

Winston Churchill

Franklin Roosevelt

Ronald Regan

(Mainly politicians but the political and socioeconomic changes for which they largely were responsible have been the drivers of...

A major problem that I have encountered with table variables is that SQL Server cannot handle them under parallel processing. Performance plummets on a multi-processor machine if table variables...

ngen /queue pause

... should stop it (I may have the syntax slightly off). I believe that the problem is to do with conflicting thread priorities.

I have set up my...

What is tour licence? Have you hit the limit on number of connections?

Aahh - of course. Thanks.

I konw this works - I just tested it! - but I would have expected Char(12) to pad with leading spaces whereas it actually trims its return value, which is...

This is one of those questions where, 'if you need toknow the answer, you're probably doing something wrong'!

I would suggest writing the list to a temporary table and doing a...

David, yes!

I had been thinking that SUBSTRING was restricted to the first 8k but have just realised that it isn't. Thanks to you and everyone who has given time...