Gary Varga (3/13/2015)

---

Toby Harman (3/13/2015)

---

Many years ago I found a comment by my boss in the code which read something along the lines of

-- Don't touch this code

-- It does...

Quick thought, could it be that changing the compatibility level flushes the plan cache and that's the real culprit?

😎

Seen everything between a shopping list to poetry, not bothered too much by those, at least not as much as having several hundreds of routines which all had a very...

The beginning and terminating single quotes / apostrophes are missing from the sp_MSforeachdb parameter.

😎

Recommend using Ola Hallengren's scripts[/url] rather than rolling your own.

Ed Wagner (3/12/2015)

---

Yout might pay closer attention to the news than I do. Another possibility is that...

Dwain,

found the cost of the #Temp inserts being the greatest actual cost variant, much stabler results using "bucket" variables, regardless of the function used.

Did some slight changes to...

Quick question, this is a normal size Strat in your picture then?

😎

Played around a little with the application of short-circuiting and ended up with something close to what I normally use for multi-statement table value functions, 15% improvement on this particular...

rodjkidd (3/9/2015)

---

Eirikur Eiriksson (3/9/2015)

---

Grant Fritchey (3/9/2015)

---

Great seeing everyone this week at SQLBits.

And, I got to meet Gianluca and Eirikur for the very first time. Total pleasure gentlemen. By the way,...

dwain.c (3/10/2015)

---

I guess the real point of my post was not to offer competition to DelimitedSplit8K (or any of its variants). Rather to see if anybody has ever seen this...

Very interesting Dwain, and works perfectly in your test harness, maybe I need more coffee in the morning but when I plug this into my normal harness the results are...

Quick suggestion, slightly more efficient at least for this data set

😎

USE tempdb;

GO

declare @myXML XML = '<CustomerMatchings>

<CustomerRecord CustomerId="10600">

<MatchingSetId>11</MatchingSetId>

<MatchingSetId>13</MatchingSetId>

<MatchingSetId>18</MatchingSetId>

<MatchingSetId>23</MatchingSetId>

<MatchingSetId>24</MatchingSetId>

<MatchingSetId>25</MatchingSetId>

<MatchingSetId>28</MatchingSetId>

<MatchingSetId>29</MatchingSetId>

</CustomerRecord>

<CustomerRecord CustomerId="10700">

<MatchingSetId>47</MatchingSetId>

<MatchingSetId>49</MatchingSetId>

<MatchingSetId>50</MatchingSetId>

<MatchingSetId>53</MatchingSetId>

<MatchingSetId>54</MatchingSetId>

<MatchingSetId>55</MatchingSetId>

<MatchingSetId>57</MatchingSetId>

<MatchingSetId>58</MatchingSetId>

<MatchingSetId>62</MatchingSetId>

<MatchingSetId>63</MatchingSetId>

<MatchingSetId>65</MatchingSetId>

<MatchingSetId>66</MatchingSetId>

</CustomerRecord>

</CustomerMatchings>'

DECLARE @RecvMessages TABLE (id INT...

Grant Fritchey (3/9/2015)

---

Great seeing everyone this week at SQLBits.

And, I got to meet Gianluca and Eirikur for the very first time. Total pleasure gentlemen. By the way, Gianluca is a...

zach_john (3/6/2015)

---

Hey All,

Any experts out there that can speak to Fuzzy logic improvements or changes in SQL Server since 2008 R2? I can't find anything that mentions improvements....

Quick suggestion, do this instead

😎

USE master;

GO

IF (SELECT

SD.compatibility_level

FROM sys.databases SD

WHERE SD.name = N'mydatabase'

...