Viewing 15 posts - 5,206 through 5,220 (of 15,381 total)
Honestly from what you described the time sounds about as good as it is going to get. Assuming roughly 50% of your rows are "ON" then you are selecting about...
April 14, 2014 at 8:07 am
Lynn Pettis (4/14/2014)
Sean Lange (4/14/2014)
Lynn Pettis (4/9/2014)
Sean Lange (4/9/2014)
Lynn Pettis (4/9/2014)
Well, looks like Sean and I have similar but different solutions.
Yes indeed. One suggestion I would offer is to include...
April 14, 2014 at 7:57 am
robmcbarron (4/10/2014)
Sean - many thanks for your perseverance on this. I've found a solution by revisiting the logic but really appreciate your patience and responses.:-)
Glad to hear you found a...
April 14, 2014 at 7:11 am
Jeff Moden (4/12/2014)
I don't believe I've ever seen a Companies table. 😀 It's always been just Company where ever I worked.
I have and it has left a permanent scar...
April 14, 2014 at 7:08 am
Lynn Pettis (4/9/2014)
Sean Lange (4/9/2014)
Lynn Pettis (4/9/2014)
Well, looks like Sean and I have similar but different solutions.
Yes indeed. One suggestion I would offer is to include an order by for...
April 14, 2014 at 7:02 am
Lynn Pettis (4/9/2014)
Well, looks like Sean and I have similar but different solutions.
Yes indeed. One suggestion I would offer is to include an order by for your subquery to ensure...
April 9, 2014 at 2:18 pm
This is exactly the kind of thing where a tally table is perfect. I have a view on my system for a tally table but in this code I included...
April 9, 2014 at 1:47 pm
Sarwan (4/9/2014)
I want to run that query across 100+ servers daily and save the output of 100 +servers in single table so that...
April 9, 2014 at 10:46 am
domleg (4/9/2014)
April 9, 2014 at 10:45 am
Japster (4/9/2014)
Sean Lange (4/9/2014)
Japster (4/9/2014)
thanks for the reply, for this exercise there will always be 7 serials per box.
However there is data in the table that has 42 serials in...
April 9, 2014 at 9:33 am
Japster (4/9/2014)
thanks for the reply, for this exercise there will always be 7 serials per box.
However there is data in the table that has 42 serials in a box, will...
April 9, 2014 at 8:58 am
Lynn Pettis (4/9/2014)
yuvipoy (4/9/2014)
all of the sudden it happened today and...
April 9, 2014 at 8:33 am
Lynn Pettis (4/9/2014)
Simple, don't use NOLOCK.
+10000
OP, do you know the issues with using that hint? Is missing and/or duplicate data acceptable? Because when using NOLOCK both of those things will...
April 9, 2014 at 8:22 am
jasona.work (4/9/2014)
Find out from your wife that sometime between you leaving...
April 9, 2014 at 8:12 am
higgim (4/9/2014)
April 9, 2014 at 7:55 am
Viewing 15 posts - 5,206 through 5,220 (of 15,381 total)