Viewing 15 posts - 38,836 through 38,850 (of 49,552 total)
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 28, 2009 at 12:34 pm
I hate dogs. Little ones I just dislike, big ones actually scare me.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 28, 2009 at 10:11 am
Cats were worshipped as gods in ancient Egypt. Cats have never forgotten that.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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
...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 28, 2009 at 8:18 am
Pradyothana Shastry (5/28/2009)
Use msdbgo
select * from sysdtspackages
Why do you keep on repeating what other people post?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 28, 2009 at 8:14 am
Roy Ernest (5/28/2009)
BTW, the echo guy is strange. He has been doing this quite often. Or give an answer without reading the question. :hehe:
Or posting bad advice (truncate tran log,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 28, 2009 at 7:56 am
Depends on the number of queries that ran during that 15 min period. That no of reads could be excessive or they could be very low.
The total reads doesn't...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 28, 2009 at 7:50 am
bhuvnesh.dogra (5/28/2009)
can somebody tell me any short method ?
You've got the two ways to move tables. There isn't a short cut.
For tables without a cluster you could always...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 28, 2009 at 7:18 am
Viewing 15 posts - 38,836 through 38,850 (of 49,552 total)