Please see the documentation on MSDN: Specifying Paths to External Items

Sean Lange (9/10/2015)

---

Maybe there are rats chewing on the wires. The performance has been steadily getting worse over the last few days. As of today the site is basically unusable...

Hi Gail,

Thanks for explaining all that, I'll have to have a few reads to make sure I understand it fully.

For this simple example, I believe this form may produce a good result:

(only tested on SQL 2016 CTP 2.3 using Kevin's test data from a few posts back)

SELECT first_name, last_name

FROM...

I wouldn't usually answer without checking, but I don't have time right now, sorry...

That said, you could try placing a very small object (maybe a textbox with white font) below...

Steve Jones - SSC Editor (9/2/2015)

---

Ed Wagner (9/2/2015)

---

Agreed. So what is in a CTE? It contains a SELECT statement. You can do multiple things with it, one...

Try running

EXEC('SELECT net_transport, auth_scheme

FROM master.sys.dm_exec_connections

WHERE session_id = @@SPID;') at PROD;

I would imagine that the value of @@SPID is being taken from the local session, so is returning details of a completely different session on the PROD server.

e.g. your local...

Thanks Luis, for a well written article.

There are a couple of things to note when using this technique (I use set based loops regularly) that I think are worth re-iterating...

Unfortunately, there is not one perfect answer because of dynamic sql.

I could build a query that dynamically builds the name of a table and no amount of string searches or...

Nice List, thanks.

I would include Collation in #11 - mixed collations can be very bad and hard to diagnose for performance.

Thanks for a very informative article!

I gave you a 4* instead of 5* simply because I personally prefer (as the years go by) to have the pertinent information right there...

I suspect Jeff is right and your function is a (i)TVF in database "dba", so needs to be referenced in the FROM clause, not the SELECT.

SQLPain (8/25/2015)

---

Thanks for the fast reply.

the current result set contains only 500 values, I don't think it would ever go higher than that. what would be the difference in the...

Jeff Moden (8/25/2015)

---

greg.bull (4/27/2015)

---

Just wondering if anyone has worked out how to control foreground AND background colours for cells in a formatted table?

In essence to combine these:

'font/@color' = case...(set up...