I don't think this can be caught in a simple metric. How many rows are returned from those combined tables? How much logic has to be done in order to...

GilaMonster (1/27/2016)

---

ChrisM@Work (1/27/2016)

---

GilaMonster (1/27/2016)

---

With Azure SQL DB, there's no such...

Well, since the performance is bad they apparently are not as fine as they...

I think that it would help if you can post CREATE TABLE statements for all tables involved, INSERT statements with a few rows of sample data, and the expected result....

Oh, and a second reason for allowing multiple instances is that they can be different versions. So if you have SQL 2012 and you want to upgrade to SQL 2014...

I tihnk the main reason is to enable companies to better utilize their hardware. If a database server was underutilized, adding a second instance allowed for better utilization of the...

Google for "FOR XML PATH String concatenation", then read some of the hits you'll find.

If you feel you need help piecing together the actual code, then post CREATE TABLE statements,...

Those schemas are out of the box owned by the principals of the same name, so you are correct that the ALTER AUTHORIZATION you ran sets it back to default.

The...

Based on the title of the question, the answer is good. However, specifically for the text in the question (which explicitly limits the query type to backup and restore), I...

Bruce Dow (1/26/2016)

---

> Correct answer: This function returns a GZip compressed version of the string.

I disagree with the answer.

COMPRESS can return a GZip compressed version of the string, but...

Grant Fritchey (1/25/2016)

---

Hugo Kornelis (1/25/2016)

---

Grant Fritchey (1/25/2016)

---

A few questions for the threadizens. Interested in this from everyone, but especially interested in what you guys who consult think.

What blockers are you...

Pseudo-code is for procedural programming, and should only be in the design document. Not in the comments. That's not what comments are for, they should clarify.

My commenting style is to...

If you force a new plan every time (which might or might not be a good idea, but using the DBCC FREEPROCCACHE sledgehammer is definitely not right), then the most...

Aggregate functions that do not use ORDER BY in the OVER clause (so that would be OVER(PARTITION BY ...) or just OVER (), which implies a single partition for the...

Manic Star (1/26/2016)

---

Luis Cazares (1/26/2016)

---

Manic Star (1/26/2016)

---

So we had a development. An SQL MVP at days of .Net told our devs that their beloved UberQueries were ok since the QA...