Viewing 15 posts - 38,851 through 38,865 (of 49,571 total)
Roy Ernest (5/28/2009)
GilaMonster (5/28/2009)
Cricket. The only game that you can watch for 5 min every 2 hours and still catch all the action.
That has changed with the introduction of 20/20....
May 28, 2009 at 1:52 pm
Cricket. The only game that you can watch for 5 min every 2 hours and still catch all the action.
May 28, 2009 at 1:41 pm
Do you ever do any queries on that table?
May 28, 2009 at 1:37 pm
On SQL 2000, drop all of those statistics (the names are given in the error message)
DROP STATISTICS <Statistics Name>
Once you've done that, run both of these commands on the SQL...
May 28, 2009 at 1:36 pm
Ok, taking a couple steps back, what are you trying to do here? What's the purpose of that IN statement? It looks like you're trying to return 1 invoice, though...
May 28, 2009 at 1:02 pm
Well, first things first, define what you mean by 'top 2' please? Your query has no Order By on it, so Top 1 will just return you 1 row. Which...
May 28, 2009 at 12:48 pm
Grant Fritchey (5/28/2009)
GilaMonster (5/28/2009)
I hate dogs. Little ones I just dislike, big ones actually scare me.
Sorry to hear it. I love big dogs. We have an 80lb German Shephard, Maximus....
May 28, 2009 at 12:34 pm
I hate dogs. Little ones I just dislike, big ones actually scare me.
May 28, 2009 at 12:02 pm
Update usage won't do a thing here. Update usage just fixes the space-used metadata and that's not the problem. The problem is inconsistencies in the schema
No need to analyse the...
May 28, 2009 at 11:58 am
Uncle Moki (5/28/2009)
I guess the real test will be closer to the end of the month when the data grows to 5+M again.
I'd be quite willing to bet that the...
May 28, 2009 at 10:30 am
kavita_pansare (5/26/2009)
When I am trying to check this value as 'if @variale==1' it gives error.
SQL only uses one = for comparison.
If that's not it, tell us what the error...
May 28, 2009 at 10:11 am
Cats were worshipped as gods in ancient Egypt. Cats have never forgotten that.
May 28, 2009 at 8:39 am
Use a subquery that does the aggregation.
update pallet set palllet.qcscore = MaxScore
FROM ( SELECT max(score) as MaxScore, palletid from qcd inner join qch on qcd.qchid = qch.qchid
...
May 28, 2009 at 8:27 am
Roy Ernest (5/28/2009)
I was thinking maybe we should ask someone who is politically correct to tell him not to be parrot.. 😀
To hell with 'politically correct'. (I can be, I...
May 28, 2009 at 8:18 am
Viewing 15 posts - 38,851 through 38,865 (of 49,571 total)