Viewing 15 posts - 1 through 15 (of 75 total)
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...
May 10, 2016 at 4:13 am
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...
May 6, 2016 at 2:48 am
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...
February 4, 2015 at 6:53 am
If I open activity monitor though on the server, it populates database names for everything
February 4, 2015 at 6:29 am
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 -...
March 4, 2013 at 2:52 am
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 🙂
September 18, 2012 at 7:26 am
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...
September 18, 2012 at 3:16 am
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...
September 30, 2011 at 4:07 am
Didn't work apparently 🙁
September 30, 2011 at 3:36 am
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...
September 30, 2011 at 3:24 am
the code is running inside a stored procedure
September 30, 2011 at 3:09 am
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...
September 15, 2011 at 9:28 am
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...
May 4, 2011 at 2:48 am
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...
May 4, 2011 at 2:03 am
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...
October 25, 2010 at 3:23 am