TheSQLGuru (7/12/2016)

---

Alan: your PK breaks inserts of >1 row with the same datetime value, which is going to happen both with multi-row batch inserts as well as concurrent access (due...

patrickmcginnis59 10839 (7/12/2016)

---

Igor Micev (7/12/2016)

---

patrickmcginnis59 10839 (7/12/2016)

---

An ORDER BY clause can be used explicitly in the end as well. In that case the COUNT is not deterministic. See Deterministic and...

Great work Igor, 5 stars!. You did a great job grouping (pun not intended :-P) together the most important aspects of COUNT. Fantastic article and a great resource to point...

Jeff beat me to it. Here's some DDL that shows how to implement what Jeff suggested.

USE tempdb -- a safe place to test this out...

GO

-- (0) Your table...

To get the current max degree of parallelism for a specific instance of SQL Server:

SELECT value_in_use

FROM sys.configurations

WHERE name = 'max degree of parallelism'

attack

den

Ed Wagner (7/8/2016)

---

Very nice work, Alan. I think you explained the concept really well and used some very good examples. I have to tell you that it reminds...

Ok Solomon, I tried to figure this out and failed. Forgive my CLR noobness (I create about 1 CLR/year) and I'm sure this is simple but I'm having a hard...

Marcia J (7/5/2016)

---

I don't know if it's just my machine, but the final code box is empty. I tried Chrome, IE, and IE with compatibility settings. I assume...

Glassdoor.com is very good and reliable. For example - a google search for "glassdoor dba...

Thanks a lot J. That means a lot!

Here's a couple solutions based on what your output should look like for the values "MDL-9054-1" and "TX GMS-7000"

DECLARE @strings TABLE(string varchar(100));

INSERT @strings VALUES('MDL-9054-1'),('TX GMS-7000');

SELECT

ColA = SUBSTRING(string,1,CHARINDEX('-',string)-1),

...

Another approach would be to split the text into word-level bi-grams using NGrams8K[/url]. See the article for the function and a description of what a word-level bi-gram is.

Using...

Haha! +1