You do.

We get exclusive rights for... some period of time I don't recall, a year or less. It's...

Lynn Pettis (9/21/2009)

---

Grant, any guidelines on writing the abstract for an article? I think I may have an idea for an article I'd consider writing, but need a little...

There are a whole series of connection settings you can modify. Take a look at the server properties for the default set. Implicit transactions, cursor close on commit, ansi warnings,...

It really depends on what the queries are doing. A select statement without any temp tables, table variables, or ORDER BY clauses, that pulls data through seeks and joins through...

Check the connections settings of both to ensure they're making the same choices regarding ANSI NULL's, etc. That can make a big difference in performance. Also, if you're trying to...

As far as I know it's because you can write procedures and not store them or store the procedures.

It's just a reasonably descriptive name.

Why are you asking about it &...

It's a very good idea to turn on TRACEFLAG 1222. It can be difficult to interpret, but at least you're assured of capturing the information as each deadlock occurs. Otherwise,...

I wouldn't be surprised if you can tune it further. Nice to hear that it's working better.

Yes, but what is occuring inside the function? Is it a single statement function with a query against a single table just with parameters or are multiple tables involved in...

Lynn Pettis (9/18/2009)

---

Grant Fritchey (9/18/2009)

---

Lynn Pettis (9/18/2009)

---

Grant Fritchey (9/18/2009)

---

Lynn Pettis (9/18/2009)

---

Grant Fritchey (9/18/2009)

---

Lynn Pettis (9/17/2009)

---

Just an FYI for the denizens of The Thread, next Tuesday I have another article being...

Roy Ernest (9/18/2009)

---

Grant,

I know I am not the best article writer.. 🙂 But I think I will give it a try if I ever am able to make some time....

I'm a little confused on the idea of a function vs. a join. If you have two sets of data that you want to put together, you have to do...

Lynn Pettis (9/18/2009)

---

Grant Fritchey (9/18/2009)

---

Lynn Pettis (9/18/2009)

---

Grant Fritchey (9/18/2009)

---

Lynn Pettis (9/17/2009)

---

Just an FYI for the denizens of The Thread, next Tuesday I have another article being republished here on ssc...

Lynn Pettis (9/18/2009)

---

Grant Fritchey (9/18/2009)

---

Lynn Pettis (9/17/2009)

---

Just an FYI for the denizens of The Thread, next Tuesday I have another article being republished here on ssc as well. Keep...

Oh, and, in cases like this, all the execution plans are going to be relevant.