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'

...

Quick thoughts, don't use TEXT, use VARCHAR(MAX) or NVARCHAR(MAX) instead,

BOL: ntext , text, and image data types will be removed in a future version of Microsoft SQL Server. Avoid...

Just chipping in a little bit, one of the bigger annoyances when importing data from Excel spreadsheets is the lack of metadata functions/view, think thousands of files with a time...

Great meeting you all, Ola, Erland, Itzik, Grant, Rodders, Gail, Dejan and and all the others, missed Steve although I did catch a glimpse captain America, looking forward to the...

Elementary my dear Dr. Watson Mr. Thomson

😎

krypto69 (3/6/2015)

---

Hi,

I have a statement that I'm having trouble converting:

select * from emails join InternalContacts On emails.EmailAddress = InternalContacts.EmailID

When I run this I get -

Conversion failed when converting the...

Has everyone picked the costume for tonight?

:smooooth:

Quick thought, the difference is mainly that the first code snip implies a group by which translates to a distinct aggregation of each set members by group, the over clause...