Viewing 15 posts - 1 through 15 (of 108 total)
Thank you for your replies. I'm taking over from a contractor who put this Levenshtein matching function in place https://stackoverflow.com/questions/36492073/sql-full-text-search-result-priority/36613504#36613504 (literally this function, he copied the code and renamed...
April 11, 2019 at 8:13 am
OK, we bumped the virtual cores up to 16 last night. Performance has gone down slightly for today's import, but because we bounced the box all of the cached...
May 30, 2018 at 10:08 am
Thank you for your reply, bmg002. I'm leaning towards asking to up the cores to 24 for a day and try and see what that run looks like.
Here are a...
May 25, 2018 at 2:45 am
Thanks to you and everyone that has contributed to this article. It is very helpful!
A very, very minor nitpick in your comments please:[code...
March 14, 2017 at 7:42 am
Hehehehe. I missed it the first time I read it. I think the audience might've thought that you up to something and misspelt it on purpose. 🙂
June 22, 2015 at 3:32 am
Marius van Schalkwyk (3/31/2014)I almost forwarded this to my manager. I should have known it was to good to be true.Good one.
Marius van Schalkwyk (3/31/2014)
+1. Steeeeeeeeeeeeeeeeeve!!!!!!!!! :hehe: :hehe: :hehe:
April 1, 2014 at 2:00 am
e-ghetto (7/3/2012)Clustered indexes define the logical order of the tableI would say: Clustered indexes define the physical order of the table. Am I right?
Clustered indexes define the logical order of the table
I would say: Clustered indexes define the physical order of the table. Am I right?
No. There is no guarantee of physical...
July 3, 2012 at 5:37 am
IceDread (6/23/2011)Feels like fundamental flaw when a database server is highly dependent on it's operating system..
June 23, 2011 at 4:26 am
I don't have a script for you, but I can give you a really, really big recommendation to enable HT.
May 11, 2011 at 1:00 am
My condolences Steve and Tom@Intel.
April 26, 2011 at 1:22 am
Or in a lower, cheaper edition.
February 28, 2011 at 7:28 am
Please include a link to where Jeff Moden posted his function.
This search turned up this result.
Is that where you got the function from?
February 28, 2011 at 3:32 am
AMD doesn't implement Hyper-Threading, it implements Two Strong Threads.
Intel combats [the expense of one thread per core] with Hyper-Threading, which allows each physical core to work on two threads....
January 24, 2011 at 12:31 am
Steve Jones - SSC Editor (12/9/2010)
December 9, 2010 at 11:39 pm
December 9, 2010 at 7:50 am