WayneS (7/22/2010)

---

Steve Jones - Editor (7/22/2010)

---

I tend to agree with you, Gail, but a reference is a reference for purposes of discussion.

I do think this is a thorny issue. Would...

Just grouping by functional area isn't necessarilly going to help with I/O. Do you have multiple disks and multiple controllers? If not, just adding another file and filegroup isn't likely...

I think this...

GilaMonster (7/22/2010)

---

I must admit, I don't agree with that....

There is no implicit conversion from DATETIME to INT. If your table has no data, drop it and recreate it. Otherwise, what you need to do is create the new...

Ooopsie. That's what I get for using my brain instead of the Mark I Eyeball. I really need a brain upgrade. Thanks.

I'm in agreement here. You're possibly looking at a parameter sniffing issue, where the differering parameters are getting you differing execution plans. Based on what you describe, that's pretty likely....

Something along these lines. You have a table with a column, CityName. One row has a value 'Hyderabad.' But that's a bad value. So someone is running a query that...

Uhh... words fail me, but I'd be willing to discuss an hourly rate to untangle the mess.

I agree, based on what you're doing here, I would suggest switching the table...

Also, you can search on the word "deprecated." That frequently indicates things that have been removed from SQL Server.

Alterting and not much else... Check out Red Gate's SQL Alert. I think it might be exactly your cup of tea. I find it way too weak, but I want...

I don't think even his presentation persona is nearly as ascerbic as his online persona....

rjohal-500813 (7/21/2010)

---

This chap ought to update his cv and brush up on his interview skills. Not sure I'd want to work there. This situation could only have arisen as a...

Lynn Pettis (7/21/2010)

---

Never met...

We have the same situation and basically rely on the logs as a mechanism to restore to a precise point in time. That's the best that can be achieved. If...