Thank you for the post, good one.

Earlier I was referring to this doc http://download.microsoft.com/download/F/D/3/FD33C34D-3B65-4DA9-8A9F-0B456656DE3B/SQL_Server_2016_datasheet.pdf and to be honest it didn't helped to understand what it is saying, and below at...

Thank you for the post, Steve, good one.

Thank you for the post, Steve, really good one. I really took lot of time (really lot) just to understand the question... then I realized RG can control CPU, Memory......

Thank you for the question, Steve, nice one.

After reading this "Central Management Servers and subordinate servers can be registered by using only Windows Authentication. Servers in local server groups can...

serg-52 (4/16/2015)

---

Explanation says "The result of using XML Data methods will always be nondeterministic. "

It's not correct. Just add WITH SCHEMABINDING

CREATE FUNCTION dbo.ReturnSecIdFromClientXML (@ClientXML XML)

RETURNS...

Thank you for post, good one.

From local help with title "Use XML in Computed Columns"

You can create a computed column by extracting a value from an xml type column as...

cgumprich (4/13/2015)

---

Good question. I'd be interested to know in what situations something like this might be necessary -- in a normal Sql Server uninstall, wouldn't this be taken care of...

Thank you for the post, good one.

(I have used the SC CLT before, for deleting the services left over after uninstalling the some 3rd party tools, and was sure of...

matthew.flower (4/9/2015)

---

I got it right so I'm not complaining, but technically the alias can be defined by providing a column list as per answer 4, specifically:

WITH MonthlyProductSales (YearMonth, ProductID, SumLineTotal)...

Thanks for the post, good one.

I was of sure of usage of square brackets will lead to the successful table creation, and that "tmp." schema name- as not all databases...

Also, BCP command utility works in a same manner with FIRSTROW. As the text file's data has no headers, so based on the row terminator, it instructs to read...

Thank you for the post, Steve, good one. (I use this utility all the time)

Thank you for the post, Steve, really interesting one.

Thank you for post, really good one. I have theoretically read about this but never actually used it at all.

Koen Verbeeck (4/3/2015)

---

...

The book by Itzik describes this behaviour in great detail: it's because ROWS can use a specialized in-memory table for temporary results, but RANGE cannot and has thus...