Hey again,

I was wondering if you could give an idea of the scope/scale this is rolled out to, and your resource available to manage it? I.e. could you cope with...

Interesting article, thanks for taking the time to write it.

Interesting replies too!

All good food for thought.

Question: For your particular use case/situation and with your available resources, have you found your...

That is perfect, thank you 🙂 Different from the variants I was looking at.

BTW just for info, connections with nothing happening are included, in my case, as MS Access client...

If I open activity monitor though on the server, it populates database names for everything

Part of the trick is doing your research before you buy any SSD's. They are not all the same! There are some that have very bad reputations with reliability -...

I call it a win win! You could use it as a stand alone search in a field, or combine it with other things for a super search 🙂

M.

Great article! 🙂 Brilliantly written too!

Out of interest, what other fuzzy search methods do people use?

One I came up with for a crm system a fair few years ago works...

Had the dev. replace select into with insert into + relevant changes to handle the tables, and all is good in the world.

I would still be interested to know why...

Didn't work apparently 🙁

Ahh the person running this (I hate it when its a 3rd party your trying to help) says the waitfor in a SP doesn't help.

I've pointed them at sp_refreshview, fingers...

p.s.

the code is running inside a stored procedure

If you are using identity columns and are using multiple servers, you can set each server to use its own `bank of numbers`. E.g.

Server1: identity seed = 00,000,000,000

Server2: identity seed...

Just wanted to add my experience of CLR....

Used in the right place (i.e. where it was worth optimisation), it doubled the speed of some of my TSQL (doing some heavy...

I think it seperates into 2 areas

- 3rd party products your software may come to rely on (e.g. expansion of functionality, 3rd party dll's, etc.)

- 3rd party products that enhance/speed...

Back to the scenarios - i've found myself in similar situations on many occasions.

My tips are always to document everything, keep evidence trails (and these don't have to be secret...