alanspeckman (9/12/2012)

---

Is it ever considered a best practice to use a UniqueIdentifier(GUID) as a primary key?

Is there ever a case where you would want to use a GUID as a...

The comma form parses correctly if you list Worker second:

Select M.name, F.name, B.name

From Role F, Worker M

LEFT JOIN Worker B ON M.superiour=B.nr

Where M.Role = code

It might be a limitation of...

Rather than trying to navigate all the quirks of the interpretation of strings as dates, use an explicit style:

-- Style 103 = dd/mm/yyyy

SELECT DATEPART(DAY, CONVERT(date, '13/09/2012', 103));

Usman Butt (9/12/2012)

---

hahahaha..:-D Yes, one can change it since the source code is available. But since it is to be taken as the generic splitter :cool:, it should be handling...

Avocado 😀

Yes, but it all gets very inconvenient from there on in - for example working out whether...

SomewhereSomehow (9/11/2012)

---

What I observed was function "sqlservr!Record::FindDiff", after call to this one, the subsequent calls for updating and nonupdating differs. For non-updating: nothing happens. For updating: some extra...

Not for me, no 🙂

The source code is there...

m.t.cleary (9/11/2012)

---

I agree that the CLR has additional and desirable features, but if we're comparing apples we need to make sure the functionality we are comparing is the same. My...

The question didn't mention trace flag 610 (which would enable minimal-logging in this scenario) so I assumed it was off, and was rewarded with a green tick and a point.

http://msdn.microsoft.com/en-us/library/dd425070.aspx...

More than two (it supports very long strings and Unicode) but overall the...

It is interesting that explicitly filtering out updates isn't always faster than performing a non-updating update either:

USE tempdb;

SET NOCOUNT ON;

GO

CREATE TABLE dbo.Test

(

Name char(200) COLLATE Latin1_General_CI_AI NULL

);

GO

INSERT dbo.Test

SELECT...

If...

Good question, thanks Kenneth.

Lynn Pettis (9/7/2012)

---

Okay, an etiquette question as a Good Samaritan. How many times should you refuse money for helping a motorist with a disabled vehicle? I was walking...