Viewing 15 posts - 22,231 through 22,245 (of 49,552 total)
Another case of 'The Department of Redundancy Department'. Those 2 hints mean exactly the same thing (and it's not 'go faster')
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
November 14, 2011 at 8:17 am
SELECTCOUNT(Price),
Price
FROMTempSales
GROUP BY Price
ORDER BY Price;
That's a really, really weird query to run. Count the non-null values of price for each unique value or price, then order by the same column.
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
November 14, 2011 at 8:12 am
There's no 'log chain' on a mirroring partner. Mirroring doesn't depend on log backups to copy transactions across (as log shipping does). You can't take log backups on a mirror...
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
November 14, 2011 at 8:05 am
Either Suppliers or Permissions are views or functions, or you radically simplified the query when you posted it. There are references to so many tables that are not mentioned in...
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
November 14, 2011 at 7:47 am
raotor (11/14/2011)
Could it simply be that an index on a single column will actually be a degrading factor in query performance if there's high numbers of duplicates present?
No.
An...
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
November 14, 2011 at 7:25 am
TheSQLGuru (11/14/2011)
GilaMonster (11/13/2011)
If it's an urgent, major, critical issue, I suggest you open a case with Microsoft CSS.
Very STRONG agreement here Gail! Anything that is marked as "huge emergency"...
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
November 14, 2011 at 7:20 am
martin.kerr 34088 (11/14/2011)
well thanks for all of your replies but i have just started using sql so am a little rusty on the syntax ect.
No worries.
The syntax for update catches...
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
November 14, 2011 at 6:47 am
p.s. A binding error (it can have other names) is thrown by the algebriser as it binds the query to the objects that it refers to. That's the phase after...
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
November 14, 2011 at 6:42 am
Ninja's_RGR'us (11/14/2011)
Gianluca Sartori (11/14/2011)
With my powers of divination I foresee just a few more threads like this one and Gail taking a break from the forums again.:hehe:
I can handle him...
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
November 14, 2011 at 6:39 am
Gianluca Sartori (11/14/2011)
With my powers of divination I foresee just a few more threads like this one and Gail taking a break from the forums again.:hehe:
I'm already taking a break....
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
November 14, 2011 at 6:33 am
Is the application ever going to select all rows?
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
November 14, 2011 at 6:11 am
Dev (11/14/2011)
It's not a run-time error, try-catch can't catch it.
Well, it should.
No it shouldn't.
p.s. A runtime error does not cause a crash unless the person who wrote...
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
November 14, 2011 at 6:09 am
Ok, let's put it this way.
What kind of error is this?
SELECT Col1, Col2, Col3 FROM TableThatDoesNotExist
It's not a syntax error, that passes syntax check successfully.
It's not a run-time error, try-catch...
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
November 14, 2011 at 6:01 am
Dev (11/14/2011)
That's why the join was not throwing a syntax error
So you are saying it's runtime / logical error...
No, it's a binding error (if it passed syntax check...
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
November 14, 2011 at 5:41 am
Brandie Tarvin (11/14/2011)
Don't beat up the people who have to deal with the hand dealt to them just because they got those particular cards. It's not their fault.
No one's...
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
November 14, 2011 at 5:40 am
Viewing 15 posts - 22,231 through 22,245 (of 49,552 total)