Hugo Kornelis (5/28/2015)

---

Aggregate is a logical operator. It describes the process of applying aggregation function to data,...

I'd appreciate any more explanation of the distinction of Stream Aggregate v. Aggregate. Frankly, I don't recall ever seeing Aggregate on its own. I opted for Stream Aggregate on the...

patricklambin (4/18/2015)

---

+ 1 Tom.

I am thinking that it is only a discussion about the meaning of words which is really far from the topic of the original question.

I think that...

peter.row (4/10/2015)

---

The script in the answer fails because of the following:

select @a, @b-2, @C

As @C is not declared (nor is it used...

A very fine article. I have had little success finding any detail on the algorithms used in optimization. The information provided was most welcome as would be any additional detail....

Eric Prévost (3/25/2015)

---

SETUSER WITH NORESET doesn't prevent anything in SSMS.

After doing the SETUSER, the developer may not be able to do a SETUSER to revert back to sysadmin permisions,...

Brian.Klinect (3/25/2015)

---

sucheta.kothare (3/24/2015)

---

Today's question included the statement regarding walking off "without Logging Off" and still the user should not be able to use the set of permissions then how come...

robert.diley (3/10/2015)

---

Robert-378556 (3/6/2015)

---

Toreador (3/6/2015)

---

chgn01 (3/5/2015)

---

Sorry for the error on choice d). I did test for each choices. Not sure how it happen. Could Steve Jones please change...

Robert-378556 (3/6/2015)

---

Toreador (3/6/2015)

---

chgn01 (3/5/2015)

---

Sorry for the error on choice d). I did test for each choices. Not sure how it happen. Could Steve Jones please change it...

The explanation of sknox makes sense, at least given the empirical evidence from running the code. Still, the documentation does seem decidedly poor in that it takes almost legalistic reasoning...

Good eye. I am uncertain how that space got in there, but...

Philip.Daniels1971 (12/18/2014)

---

The fragmentation problem was worked around years ago with the invention of Combs, long before NewSequentialId existed. It allows sequential Guids to be created on multiple clients without hitting...

BEDMAS? Thanks. Never heard that one before. For me it was always PEMDAS with the mnemonic "Please Excuse My Dear Aunt Sally."

I was a D fan myself.

Then I looked at the query plan for the example in the TechNet article at http://technet.microsoft.com/en-us/library/ms187638(v=sql.105).aspx. What it shows (at least in...

I do have a text in front of me: Fritchey, Grant (2012) SQL Server Execution Plans, 2nd ed.

From p. 88:

"we can discuss the Hash Match join operator.

It occurs when SQL...