*sigh* I'm so misunderstood. 🙁

Paul White (5/8/2009)

---

...

You are correct that two concurrent transaction could both conclude, from a SELECT at READ COMMITTED that no row exists, and both would attempt an INSERT.

Absent a unique...

Not sure what you're asking? That does behave differently, but then it should because it's...

psangeetha (5/8/2009)

---

I right click on the venc or vdec procedures, execute the procedure and give the input data.

DECLARE@ret_value int,

@out_data varchar(200)

EXEC @ret_val = [dbo].[vdec]

@in_data1 = N'0x008b16f1b5e3ea4eaba24e2348cbf9c501000000fc5b0d5c0',

@in_data2 = N'e2f06f21ff1468953fe1047f3002e61eb0c4cb0e08bdf1ef56b',

@in_data3 = N'80d19af6eecaa4db53e145db9bef3854becd28fb20a857bb6e87',

@in_add_auth...

Thanks folks. If anybody thinks of anything else, please let me know.

If you've got SANs and/or other high-end infrastructure, then one thing that you should seriously consider is Mirror-splitting. I have implemented Reporting Databases for a number of clients and...

Do you know how to use your venc/vdec procedures from SQL? If so, can you provide an example?

Wayne, questions:

1) How many total rows are in the SCHT_obligations table?

2) Have you used the time statistics to confirm if the QP estimates per statement are accurate (i.e., is the...

Heh. Actually, SET is no more safe than SELECT, at least for the examples given here that I have seen so far.

If you look at this code:

Declare @i as...

Thanks Phil.

Paul White (5/8/2009)

---

Jamie,

At the same time as *not* necessarily recommending this as a solution in this...

RBarryYoung (5/8/2009)

---

... because the optimizer does not know what columns will actually be used at run-time, it cannot tell ahead of time what indexes it should be using, so it...

Gail's link is an excellent article from her blog that examines in detail why these "catch-all" queries perform poorly. For purposes of our discussion here, let me summarize the...

veritas_86 (5/8/2009)

---

I'm using SQL to store data where one of the fields is a large array. I was going to put this array into another table that is seperate from...

Looks like I answered my own question. The following seems to work fine:

Declare @qp as XML

SELECT @qp = query_plan

From sys.dm_exec_requests

Cross Apply sys.dm_exec_query_plan(plan_handle)

Where session_id = @@spid

--...