Ed Wagner (8/11/2015)

---

The silver spoons need to be ordered again. Better get at least a case.

Here's a quote I don't think I've every seen before:

Unfortunately I get your code...

Eric M Russell (8/11/2015)

---

GilaMonster (8/11/2015)

---

Grant Fritchey (8/11/2015)

---

Updating statistics won't...

Grant Fritchey (8/11/2015)

---

GilaMonster (8/11/2015)

---

It's a side effect of the dissertation, my supervisor and I distilled the 160 page dissertation down into 10 pages...

It's a side effect of the dissertation, my supervisor and I distilled the 160 page dissertation down into 10 pages and submitted it...

You mean my slow internet connection?

😀

And in unrelated news, something of moderate interest might be happening this afternoon/tonight (depending on timezones). Watch twitter.

Grant would love this query. Views within views within views with a CTE and a temp table for good measure. Parse time is around 45 seconds.

Grant Fritchey (8/11/2015)

---

We've reached page 5000 on the standard layout, so only a couple of more to cross the 50,000 post line. Is anyone going to just post them all...

Don't go by the cost %. If you use STATISTICS TIME, which query in the batch is taking the longest time?

Grant Fritchey (8/11/2015)

---

Updating statistics won't change the names of...

Just remove the last_rows from the select clause then run it. That...

You need to either create that path so that the file can be created, or start SQL in single user mode (remote in to the server and work directly) to...

If you want it in a transaction so you can roll it back, it is pointless to do it in...

Yes it is. Add in to the OR set OR a.TRANSTYPE IS NULL and replace b.SERVTYPE = ' 5' with (b.SERVTYPE = ' 5' OR b.SERVTYPE IS NULL)