SELECT * FROM (

SELECT 1 AS a UNION ALL

SELECT 2 UNION ALL

SELECT NULL) dt

ORDER BY a DESC

SELECT * FROM (

SELECT 1 AS a UNION ALL

SELECT 2 UNION ALL

SELECT NULL) dt

ORDER...

Because null will be at then end of that sort which seems to be what you want to do.

The question is simply : "In the Pry column, is there any...

Then I would suggest that someone sucks at optimizing :hehe:

I'm glad you got this figured out.

david_wendelken (10/14/2010)

---

Toby Harman (10/13/2010)

---

...

I think we should trust our co-workers in this wonderful game that is IT not to do the stupidest thing that we can think of, and maybe...

Nice read. Always something more to [re]learn I guess :w00t:.

This assumes that both column are not nullable and that patid and facid and indexed in the same index in pat..patients

SELECT

patid + facid

FROM

...

Have you compared with left join query and not exists to see which one works better?

I personnally preffer to use not exists because in my mind it's clearer what the...

I would always add performance testing / tuning as #1 priority beyond "does it work as required?".

That MUST include not breaking anything else that was working before. A good...

Gianluca Sartori (10/13/2010)

---

Ninja's_RGR'us (10/13/2010)

---

Am I reading this right??

SET @RND = (SELECT CAST(RAND() * 60 AS INT))

...

...

Am I reading this right??

SET @RND = (SELECT CAST(RAND() * 60 AS INT))

...

...

I'm sure that's not your final query because I've always had to present this in a calendar form to the final user but that gives you an idea :

create...

Start from a calendar table and filter between start date and end date

Left join that to your "days off" table based on the date only.

Group by date

having count(*) > 1

Now...

Not sure what you mean.

I had SSMS opened and I had 5 connections...

I won't have time to finish those tests but I seem to be getting as much as 10-15% throughput increase with that little change and 1M updates in 2 minutes...

Hence you'll need more hardware....

Or a difference solution.

40% is not "much" but as soon as you get a burst or cpu heavy query you're toasted.

But using a tinyint here wouldn't...