Other matters have intervened, but I thought it was worth posting the end of the story here.

There ended up being bigger fish to fry at the time, so I had...

I don't think this is likely to be needed any more but here's the SQL used to run the query over all ApplicationGUIDs. No cursor in sight, as it turns...

Ed Wagner (1/27/2016)

---

After reading about your covering index and statistics, I have to agree with Kevin about the index reduction. The next place I'd go is one you probably...

TheSQLGuru (1/27/2016)

---

As I suspected, you have MULTIPLE NC indexes that start with ApplicationGUID. Since that value is VERY specific (a few tens of rows max out of 1.6M) I bet...

Ed Wagner (1/27/2016)

---

Well, it seems as though we're always asking for information and you've already gathered quite a bit, so well done there. Kevin's already asked for good stuff. I'd...

Haha - and I bet you would have moaned at me...

Oh cock. Sorry - entirely my fault. Should have been running command in an administrative command prompt - do that and it works fine.

Thanks!

Bart

You're welcome, and I...

GilaMonster (6/11/2008)

---

I just checked SQL 2008 RC0 and the intellisense (and syntax checking) only works to a SQL 2008 server. :angry:

This was one of the features I was really, really...

Grant Fritchey (6/11/2008)

---

Thanks Bart. Very useful information. I think I'll be staying away from the list all columns option though. I do like David Poole's tip up above. I need...

Grant Fritchey (6/6/2008)

---

That's what I mean when I say you have to learn how to work with the tool. I generally type 'SELECT * FROM' and then start building the...

Steve (6/5/2008)

---

Tanya, I don't recall the version of SQL Prompt I was running. It was at least a year ago. I was using the version that I "won"...

Hi David,

One of the other developers here at Red Gate just put me on to this. You can do this, but it's not as straightforward as you might like, and...

Try this on for size:

http://www.red-gate.com/MessageBoard/viewtopic.php?t=5606

We've just put out a new EA release of SQL Prompt 3.6 with the promised Data Dude support. Any problems please let me know.

Thanks,

Bart

maybe they have an "Agreement" with the ISV's not to.

If only.