I don't disagree with the general sentiment that developers...

Interesting that you think Developers should be the people responsible for performing the very useful tips you recommend. Everywhere I've worked it has always fallen to DBAs to check execution...

Just a thought - is the database read-only?

Open a new query window against the master database and execute this:

SELECT DATABASEPROPERTYEX('the_name_of_your_database','Updateability')

In order for you to be able to run UPDATE, DELETE...

Brilliant!! Thanks very much 🙂

I find this XML stuff a real struggle.

Lempster

Jacob,

Thanks for the article - very helpful. How would you extend this so that you could extract header and item data for more than one sales order? For example, say...

I was writing a similar article (on some of the possibly lesser-known and/or used T-SQL features)to present to the rest of my team; I think I will scrap that and...

CirquedeSQLeil (1/26/2010)

---

... if one examines execution plans for these two queries and run them together, the query optimizer treats them as the same execution plan and equates both queries to...

Spot on....

It is, but I also think that (depending on...

Thanks Ben! I'm going to print your comment and take it to my next performance review 😉

Harvey Camm (1/21/2010)

---

Compartmentalise: I try to give all I've got but not all the time - when I'm away from the office I grow veg and do the family stuff,...

Jeffrey Williams-493691 (1/7/2010)

---

What would you call it when you have 10 instances installed and running on a 4-node cluster? Note: I have not specified which nodes can host all...

If you failover so that all your instances are running on one node then...

There's not too much difference; Make sure you do the install from the Active node, the install...

Jarda Jirava (7/9/2009)

---

Hi,

I know, it's too late to answer your question. Hope that it helps someone other. SQL Native Client provider cannot run out-of process so what you...