Viewing 15 posts - 23,491 through 23,505 (of 49,552 total)
Use the costs, use statistics time, use statistics IO. Just understand then limitations.
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
September 16, 2011 at 2:32 am
If you want blog posts: http://sqlinthewild.co.za/index.php/2009/02/19/estimated-and-actual-execution-plan-revisited/
http://www.scarydba.com/2009/03/19/execution-plan-estimated-operator-cost/
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
September 16, 2011 at 2:29 am
No, far, far from it. The costs are estimates always. They are calculated at compile time (they're used by the optimiser to work out the cheapest plan), not at run...
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
September 16, 2011 at 1:48 am
skrilla99 (9/15/2011)
But, what I am left wondering is, where are the precision and scale defined?
In the system tables. It would be a waste of space to store that it's a...
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
September 16, 2011 at 1:44 am
Mark S. Rasmussen (9/15/2011)
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
September 15, 2011 at 3:01 pm
Yes.
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
September 15, 2011 at 2:01 pm
xgcmcbain (9/15/2011)
so your saying redgates is better ? ok
Way better
another very important feature, is the "tree" icons to the left in a very lengthy stored procedure, where it matches up...
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
September 15, 2011 at 12:49 pm
Buy RedGate's SQL prompt and then turn the built-in intellisense off. It's terrible in comparison
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
September 15, 2011 at 12:39 pm
No.
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
September 15, 2011 at 12:24 pm
Don't understand the question.
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
September 15, 2011 at 11:43 am
Absolutely no way to say from the information you've given. You haven't said how many columns the spreadsheet has. You haven't said anything about the data in those columns.
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
September 15, 2011 at 11:35 am
jcrawf02 (9/15/2011)
I was going to start talking about red hats and puffs of smoke...
Lol
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
September 15, 2011 at 11:32 am
GSquared (9/15/2011)
What if you happen to know that 40% of the cars in there are white? That'll help you plan how long this project will take, and what method...
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
September 15, 2011 at 10:17 am
GSquared (9/15/2011)
But how many can define "cardinality" without looking it up or with total certainty?
Way too many people when they give a definition of cardinality actually give a...
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
September 15, 2011 at 10:05 am
winston Smith (9/15/2011)
But one thing i cant find out is what if your row only takes up...
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
September 15, 2011 at 9:28 am
Viewing 15 posts - 23,491 through 23,505 (of 49,552 total)