I got it wrong but noticed that only 2 people answered the question (including me), we both got it wrong, yet it says only 50% selected option 3 and no-one...

I teach SQL on SQL Server and one thing that Linux gives is the ability to set up an inexpensive VPS on a service such as DigitalOcean for about $10 per...

Hello Andrew

Thanks for all the information you have given and the things to check.

I have now added primary keys and clustered indexes to all tables in the database and this...

Kristen-173977 (10/8/2015)

---

robinwilson (10/7/2015)

---

I...

Hello Wayne

Sorry I forgot to reply but this was not the issue and it...

Hello All

I just wanted to say thanks for the help everyone has given.

The software supplier has now agreed to implement primary keys and clustered indexes across their software in the...

Jeff Moden (10/5/2015)

---

The final 42 million reads is pretty bad, as well, even for a batch run. ...

Hello All

I just wanted to update this topic after completing some testing.

Virtualisation

We set up a new physical server and restored a copy of the database there to see if it...

Kristen-173977 (9/27/2015)

---

robinwilson (9/26/2015)

---

it gets truncated at 4,000 characters.

I think you are going to have that problem with all of them (except perhaps sp_HelpText) due to column-width display limits in SSMS...

Hello All and thanks for the replies.

Yes this is really strange but then most things seem to be in my database (i.e. complete lack of clustered indexes or primary keys,...

Kristen-173977

I do really need today's data if possible. They need to be able to view the data, act on it and then refresh to make sure what they have done...

Thanks for the interesting replies!

The vendor has now taken a copy of our database and sent me a query with a few table-value functions they could run within 47 seconds...

Thanks all for the information and detailed responses which is all really useful.

Heaps

I was told this by the software supplier:

I accept that clustered indexes do seem like a simple solution...

Please can I ask if anyone knows the answers to these questions:

Primary Key vs Clustered Index

Would a clustered index or a primary key (which seems to always create a clustered...

Hello both

Kristen-173977

In using the software it does seem a bit faster but it is a bit hard to benchmark (like your traffic light example!) as the test system is not...