Carl B. (5/7/2010)

---

Hi Grant,

This morning we set the treshold to 25. Rigth after that, locking and performance problem arose. We waited but the situation did not tend to return to...

Jeff Moden (5/7/2010)

---

Grant Fritchey (5/7/2010)

---

Everyone turning off parallelism is ignoring the fact that some queries can benefit. I strongly recommend you explore increasing the cost threshold of parallelism before you...

Bradley B (5/7/2010)

---

most of mine have been taken, but I have a semi-clean story.

I was working with the Army on a FileNet project that had a SQL backend. All...

Brandie Tarvin (5/7/2010)

---

...enjoyable ranting & raving edited out...

On the other hand, the DELETE statements are kinda weird. I've never seen DELETEs phrased this way and I find myself thinking there...

I agree this sounds like parameter sniffing.

As an experiment, you can create local variables within your procedure and then use them in the WHERE clause. You should see a...

While waiting on the table defs, could you try this?

FROM T_IDYou.[dbo].[HST] h

LEFT JOIN srv1.T_id.dbo.MO s

ON h.refID=s.DistributorOrd

AND s.DistributorOrderNumber is null

Two things, using views is fine, but if you starting joining views against views, you can completely overwhelm the ability of the optimizer to simplify your queries to only use...

You should be able to use the processes outlined here to rebuild the tempdb with a different structure. It'll work the same way as if you were moving it.

Also, if you don't want to open a new query window, but just switch the connection in the one you're on, you can click the icon that's in the...

To capture individual statements, or batch calls, you can use a server-side trace. These are set up through the Profiler utility that comes with SQL Server. The specific event you're...

I love it. They're running a delete statement with a READ_UNCOMMITTED isolation level... like that'll prevent locking.

You need to get on the vendor about the issue. It's pretty clear...

mike.renwick-894639 (5/7/2010)

---

Thanks for +ve comments,

Anyone interested in sample code of what we did, take a look here

http://www.mediafire.com/?eim2mydnjti

Disclaimered as you'd expect.

Regarding the ongoing debate about "proper" source control usage, I think...

tony.turner (5/7/2010)

---

eric_russell 13013 (5/6/2010)

---

Note that because it gets this info from database management views, the history only goes back to the last time the SQL Server service was last started....

Unfortunately I don't have any funny names for code.

I do have two quasi-funny phrases that are used around here, a lot, too much.

The first, is a joke, say it, everyone...

Everyone turning off parallelism is ignoring the fact that some queries can benefit. I strongly recommend you explore increasing the cost threshold of parallelism before you simply switch it off....