It really depends on what you're doing with that data. If you're doing any kind of filtering or joining against it, then the table variable structure that the table valued...

In addition to what's already mentioned, I'll add Itzik Ben Gan's book, Inside T-SQL Querying.

Additionally, because taking multiple approaches to learning is always best, I'd suggest tracking down your local...

Brandie Tarvin (1/4/2016)

---

BLT... Nom. Now I'm hungry.

Oh, wait. Wrong thread. Thought we were doing Random Words here for a...

Andy Warren (1/4/2016)

---

Grant, I've been using Parallels on my MacAir since I bought it. Works well, though battery life suffers. Its an i7/8G. Not industrial strength, but reasonable. I can't...

Steve & I bought the same model about a month apart. Mine is older...

My problem with the Mac is that I truly hate the OS. I guess if I were shopping (and I'm not, and hope not to be for at least one...

That's extremely abnormal. If it's not a window out of focus as defined above, there must be something wrong on your machine. Check the error logs and try uninstalling unnecessary...

Andy Warren (1/4/2016)

---

I'm intrigued by the Surface Book, but the sleep bugs (Sleep!) in this first iteration worry me. I'd want to see it stable first and I suspect a...

It's so weird that your Toshiba is dead and mine is chugging along (knock wood).

Maybe you're just hard on machines. Ha!

(For those who don't know, I dropped a...

The biggest issue for multi-statement table valued functions is that, regardless of recompile, since they don't have statistics and are always based off of 100 rows (in 2014 using the...

As Jack says, in the scenario described, the optimizer is likely to arrive at the same plan regardless of the approach you take. However, what you're proposing to do with...

Phil Parkin (12/29/2015)

---

Grant Fritchey (12/29/2015)

---

Eirikur Eiriksson (12/29/2015)

---

I really appreciate the effort of those who write the articles posted on this site but sometimes the quality seriously suffers from the absence...

Eirikur Eiriksson (12/29/2015)

---

I really appreciate the effort of those who write the articles posted on this site but sometimes the quality seriously suffers from the absence of technical review and...

Jeff Moden (12/28/2015)

---

Grant Fritchey (12/28/2015)

---

Jeff Moden (12/28/2015)

---

Grant Fritchey (12/28/2015)

---

I have two presentations I do on best practices. Both slide decks are available on slideshare.net. That could act as a guide....