There are a lot of commands in SSMS that use server level calls to work. So, they don't work well with Azure. The basics are there, but not the more...

There is no easy way to do this. Each report can be an ad hoc T-SQL statement, a stored procedure or a view. You can at least document the dependencies...

That command isn't one I would have used all that much in the past which might explain why I had to look it up. If you look at the documentation...

yb751 (6/1/2016)

---

Grant Fritchey (6/1/2016)

---

yb751 (6/1/2016)

---

Steve Jones - SSC Editor (6/1/2016)

---

yb751 (6/1/2016)

---

Christmas in June!!!

The purchase of some Red Gate tools finally got approved by my boss. 😀

Feels like I've been...

Eric M Russell (6/1/2016)

---

Grant Fritchey (6/1/2016)

---

Eric M Russell (6/1/2016)

---

Enclose each of the queries within the following while you unit test them. This will return statistics such as physical/logical page reads,...

Eric M Russell (6/1/2016)

---

Enclose each of the queries within the following while you unit test them. This will return statistics such as physical/logical page reads, CPU time, plan text, etc....

And if you're going to apply them as is (and please read Kevin's warnings, they're very accurate and if anything not dire enough), the keys consist of the equality and...

Jacob Wilkins (6/1/2016)

---

There's an "Execute SQL" option in the Query Designer that you can use to run the query straight from the designer (available by right-clicking the SQL pane).

Starting a...

jasona.work (6/1/2016)

---

You know what's annoying?

When you're reading something, think of something (maybe related, maybe not) that you want to look up, and in the time it took to open a...

Jacob Wilkins (6/1/2016)

---

There's an "Execute SQL" option in the Query Designer that you can use to run the query straight from the designer (available by right-clicking the SQL pane).

Starting a...

With one being estimated and one being actual, I'm inclined to say these plans are identical, but I'd want to be sure before I went there. Frankly, I'm not sure...

yb751 (6/1/2016)

---

Steve Jones - SSC Editor (6/1/2016)

---

yb751 (6/1/2016)

---

Christmas in June!!!

The purchase of some Red Gate tools finally got approved by my boss. 😀

Feels like I've been begging forever. ...

No. That's why it's telling you to install Visual Studio.

You could probably treat it like versioned data and only retrieve the latest row of each type. I have example queries in this article [/url]on how to do this.

SSDT is built into Visual Studio. You're going to have to install at least the shell of Visual Studio to get SSDT. You can download it from here. The requirements...