Hi Stax68,

I relish your condiments with zeal!

I quite like mustard, the hotter the better.

Ketchup - good for licopene, but also high in glucose/fructose.

Mayonnaise - only for older bread.

If anyone is...

Hi David,

Thank you for your reply - it certainly is informative.

I'm recommending some changes be made to the service:

• SET DEADLOCK_PRIORITY LOW
• Call a stored proc instead, and do all transaction handling...

Hi stax68,

I agree with you completely - sweeping dirt under the carpet is what this approach seems to me, and I would only use that approach if no other (more...

Hi Pam,

Thank you for your reply.

Yes, it is dynamic SQL, but only the where clause is affected.

Upper and Like are eliminating the use of the index. The select isn't going...

Hi PW,

I am leaning toward creating the Unique Clustered Index on PatientId. The only thing that makes me hesitate on this, is that I understand that hotspots can be created...

Hi,

Wouldn't the following select work?

Select

  A, B, Max(C)

From

  YourTable

Group By

  A, B

Order By

  A, B

Richard

Hi Ana,

I hope you will understand the following code, and adapt this approach to your problem. Take some time to review it, you may find it useful for other purposes.

Warning:...

Hi Ananda,

In my professional opinion every table involved in a parent/child relationship should have a primary/foreign key constraint. I see a lot of databases these days, and in every one...

Hi Amit,

I re-formatted your query a bit, and it works perfectly.

Thank you for your help!

Hi Mark,

Thank you for your reply. I used that approach a long time ago, and I believe I found an issue with it.

Can't prove it however.

Richard

Hi,

I found out why. It turns out that "Create View" has to be the first statement of a batch. Its written up under "Create View" in Books Online. The following...

Hi Lowell,

That's a very handy piece of code, thanks a lot.

Richard

Good morning,

Insert statements are only an atomic transaction if they run within an implied transaction, IE/no explicit transaction control. In the case where two inserts are executed within an explicit...

There's no issue here, for three reasons:

1. The data went into Child unvalidated, but I can check it after re-enabling the constraint by issuing an update statement.

2. If you drop...

This works, but it's not elegant:

Alter Table Child NoCheck Constraint All

Insert Into Child With (Id, ParentId) Values (1, 3)

Insert Into Parent With (Id) Values (3)

Alter Table Child Check Constraint All

Oh well,...