Grant Fritchey (8/22/2011)

---

If you do a little searching, I posted the questions I used to ask on phone interviews, if you think that will help. But the in person interview......

Repro scripts without having to restore.

I had nagging feeling that there might be something in the db itself that was helping this.

Script tested on 2k5 sp3 and 2k8 R2 SP1.

Bug...

Or a short exemple like : SELECT NULL

It's the only thing I can imagine with 0 cost plan...

granted I didn't give this any energy before today.

Jeffrey Williams-493691 (8/20/2011)

---

GilaMonster (8/20/2011)

---

I'll tell Grant he's wrong. He'll agree with me.

The query optimiser costs were times at one point. They were benchmark times on a specific computer in the...

Grant Fritchey (8/21/2011)

---

mister.magoo (8/20/2011)

---

Any chance the plan xml is more than the limit on xml data in the grid results (default is 2MB i think)?

The other way I can get...

sku370870 (8/21/2011)

---

Jeffrey Williams-493691 (8/20/2011)

---

It all really depends on the query that is getting the data and as you pointed out, how that table is used in the application.

I just had...

sku370870 (8/21/2011)

---

Thank you for all the replies. I have done this sort of 'run a job at night to send some emails' but never more than a few emails at...

sku370870 (8/21/2011)

---

Ninja's_RGR'us (8/20/2011)

---

Might actually be the case where cursor is the better choice.

Looping is looping, the realy slow part here is sending the message...

If this is not a 1 off...

Not possible. Please read...

GSquared (7/1/2011)

---

MuskaanGoyal (6/24/2011)

---

I have already applied cell level encryption. But I don't want DBA to see the definition or modify any object. We are blocking DBA access for the security...

My point with temp table was if this is a daily process and that the table gets inserts during the process, then I treat it as a queue and I...

Might actually be the case where cursor is the better choice.

Looping is looping, the realy slow part here is sending the message...

If this is not a 1 off insert, I'd...

Workaround :

Comment this out

ALTER TABLE dbo.RPT_Historique_Couts

ALTER COLUMN DateHistorique_fin DATETIME NULL

then use this to insert instead :

SELECT

...

Paul Randal (8/19/2011)

---

You've hit bugs in rollback - contact PSS and they'll work to get a workaround and fix. Nothing much else to do without being able to step through...

LutzM (8/19/2011)

---

Exactly the same results on my (test) instances (both on the same machine):

Microsoft SQL Server 2005 - 9.00.4060.00 (Intel X86) Developer Edition, (Build 2600: Service Pack 3)

Microsoft...