Sorry, it's a good abstract.

Good luck.

I don't think there's necessarily anything wrong, but if it's a busy system, SQL might struggle. IF you're Enterprise, you can use In-Memory.

I'd start looking at Redis. I see...

Andrew..Peterson (4/11/2016)

---

crlewis42 (4/11/2016)

---

Seriously though wouldn't it be nice for an analyst to be able to peruse a catalog and lookup their own data sources to support whatever they are tasked...

This can't...

Rod at work (4/11/2016)

---

Steve, thanks for writing this article. It sounds interesting and so I just gave it a try. I use my personal Microsoft account to try and log...

I agree with Hugo, but I'll add one more thing against triggers. They're hidden.

We see them rarely, they don't easily appear in SSMS, and it's easy to forget they're in...

I'd second what Jacob said. Working with SQL Server is always remote. Even if you are on the console, SSMS makes a remote connection, so setup networking and work from...

You can win a conference pass to SQL Bits. Post a review of a previous event, or of one of the videos from a previous event (available online) : http://sqlbits.us4.list-manage.com/track/click?u=3e64686fd47743f72cf7ae22a&id=8d1ba01f21&e=3d669e3feb

I'll disagree with Jeff. Depending on how often and how data is addressed, I think it's fine to keep blob data around. I might normalize pieces of it, but there...

BL0B_EATER (4/8/2016)

---

Would anyone find an article on Azure's SQL elastic pools worth reading? More on the basic setup and screen navigation? Just to understand where you would add a...

Chocolatey is amazing. If you haven't tried it, I recommend it. I've used it more and more, grabbing software as I need it rather than trying to get things setup...

Alan.B (4/7/2016)

---

Steve Jones - SSC Editor (4/7/2016)

---

Well, I'm going to opening day in CO tomorrow, for the first time in like 10 years. I used to go ever year when...

Nothing you can do, AFAIK, until it's done. There are live query statistics in SQL Server 2016, but I don't think anything is back ported to 2014.

This sounds like it's an outer join of some sort. Certainly Patrick's answer might work better, and allow better indexing.

What I'd suggest if you give us the DDL for CREATING...

Well, I'm going to opening day in CO tomorrow, for the first time in like 10 years. I used to go ever year when I got here, but they upset...