Stacey Decker (10/30/2014)

---

I agree, why allow two values to mean the same thing? I handle this by allowing optional fields such as AddressLine2 to be NULL and then implement a...

radman_bobbin (10/30/2014)

---

I'm not sure that your example that Address_2 should allow NULLs is particularly convincing.

The approach I was taught (and still follow) is that if NULL "means something" in relation...

Tim0 (10/30/2014)

---

Nice article, but under performance you say in regards to VARCHAR:

"NULL and empty string both take up the same space (zero bytes)"

It was my understanding that a varchar, regardless...

john.p.lantz (9/4/2014)

---

I know this is an old thread, but did you ever get any information from Microsoft on the "undocumented" things that are enabled when you set compatibility mode to...

N_Muller (8/6/2014)

---

Ed Pollack (8/6/2014)

---

Yes! You can definitely create an in memory table using a table type and pass it to a natively compiled stored proc. The only restriction...

N_Muller (8/5/2014)

---

The article is well written and the author must be commended for it.

I tried implementing in-memory tables and compiles stored procedures a couple of months ago, when SQL Server...

That's correct---and the...

The gotcha with in-memory OLTP is that it needs to be completely contained in-memory. A natively compiled stored proc can't go out to disk for other data, or even...

andrewj29 (8/4/2014)

---

Perhaps I missed it, but can a Natively Compiled Stored Procedure (NCSP) be called from within a Non-NCSP?

I am sure some kind of 'wrapper' will be developed in the...

mccork (7/29/2014)

---

Thanks Edward.

A good enhancement to server permissions. It addresses a recent annoyance I found with setting up a SQL 2012 service account for use by SQL Compare... I...

Please check Microsoft's documentation:

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

It is available in Enterprise, but also in Developer and Evaluation.

Excellent article---well-written, a pleasure to read, and a great mix of practical and theoretical examples!!!

prabhu.st (7/25/2014)

---

as I read though this artcile i stuck here..

could you please give me a...

So I love a good challenge, and my first thought here was...how can we do this without loops or XML? Here is a solution that appears to work...let me...

JunkIt (7/9/2014)

---

Nice article.

Isn't sys.dm_exec_query_profiles new in SQL Server 2014? I don't see it mentioned in the article and the spreadsheet indicates "no changes."

http://technet.microsoft.com/en-us/library/dn223301%28v=sql.120%29.aspx%5B/quote%5D

Good catch---the DMV is...