Michael Valentine Jones (9/8/2011)

---

GilaMonster (9/4/2011)

---

Only if those files are on separate drives (not separate partitions...

What's the default size of tempdb? That can be set.

I'm not 100% sure here but I really don't think that tempdb is a perfect copy from model.

Right click on your subreport object, properties, parameters.

Just not to waste a newly minted...

Google output parameters

Tom.Thomson (9/8/2011)

---

Good question and answer.

But the behaviour still seems bizarre to me. Why should the loop join hint be taken to imply the (Force Order) option - if I...

TechnoPeasant (9/8/2011)

---

True Conversation from Tuesday as my boss seagulled in @ 4:45pm.

"Your priorities for this week are projects A,B&C! We dont know anything about them, have no dates and the...

Link to download for us youngsters? Or olders that lost the 2K...

Alright, let me know how it turns out.

Just a FYI, I've never done a report that didn't lead to a business decision (even trending). I know there's only a...

Trade talent / time for love.

Snapshot will allow you to ALWAYS get the correct results with the same speed as nolock.

Also nolock can actually be locked out of some dml operations. It's not a...

The do post back link doesn't work Steve.

What's up with bug finding these days?

Sounds almost like a treasure hunt :w00t:.

I would personnally disable the indexes. That way you don't have to bother about keeping the packages in sync with the index mods for tuning or whatknot.

Use nolock only if management APPROVES getting incorrect reasults. Which they never do.

Change your db to allow snapshop isolation and use that in all your queries & sps.

It increases...