September 14, 2012 at 8:17 am
Stefan Krzywicki (9/14/2012)
GSquared (9/14/2012)
Stefan Krzywicki (9/14/2012)
Brandie Tarvin (9/14/2012)
Stefan Krzywicki (9/14/2012)
GilaMonster (9/14/2012)
Anyone get the increasing feeling people are looking for the 'eazy button'?Case in point:
"I read through those articles [on index column ordering], but I still want a formula that tells me what columns go first in an index"
Pff, a formula for that is easy!
Column A should always go first in an index, possibly followed by B and C, etc...
The number of columns in your index < the number of columns in your table
Where A, B, C, etc... are columns that appear anywhere in your table that, when indexed, provide a performance boost.
🙂
You're doing it wrong.
DBCC Timewarp (# of columns / (pi * # of tables) + 8 )
The 8 is there because everyone knows there are 8 KB per page.
I always thinks DBCC Timewarp is secret and I shouldn't be spreading it around on the forums.
Nah. It's secret now, but since it won't be secret when the year 1900 roles around again, it's okay to post details. In the past-future-imperfect tense, of course.
Excellent, so from then on I will be about to have been going to done so.
Exactly.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 14, 2012 at 8:52 am
Anyone know how to do this?
Search time type between PM and AM
I can't quite figure out a good way to google it or there's just nothing out there on it.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
September 14, 2012 at 9:00 am
Stefan Krzywicki (9/14/2012)
Anyone know how to do this?Search time type between PM and AM
I can't quite figure out a good way to google it or there's just nothing out there on it.
Answered.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 14, 2012 at 9:04 am
GSquared (9/14/2012)
Stefan Krzywicki (9/14/2012)
Anyone know how to do this?Search time type between PM and AM
I can't quite figure out a good way to google it or there's just nothing out there on it.
Answered.
Thanks, and slightly different from how you handle it as integers.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
September 14, 2012 at 9:18 am
How's the refusing to be baited by Celko thing going, Lynn?
September 14, 2012 at 10:41 am
Lynn Pettis (9/14/2012)
Hey, any comments on what is posted here?
My first reaction was, "LOL!". Posted a more serious comment.
September 14, 2012 at 10:50 am
SQL Kiwi (9/14/2012)
Lynn Pettis (9/14/2012)
Hey, any comments on what is posted here?My first reaction was, "LOL!". Posted a more serious comment.
Thank you, you saved me the trouble.
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 14, 2012 at 10:50 am
SQL Kiwi (9/14/2012)
Lynn Pettis (9/14/2012)
Hey, any comments on what is posted here?My first reaction was, "LOL!". Posted a more serious comment.
Remembering that this discussion had occurred before, but not remembering exactly when or where, I really thought it best to defer to others to refute the statement. At least I know I was correct in my own assumptions on this item.
September 14, 2012 at 11:01 am
GilaMonster (9/14/2012)
SQL Kiwi (9/14/2012)
Lynn Pettis (9/14/2012)
Hey, any comments on what is posted here?My first reaction was, "LOL!". Posted a more serious comment.
Thank you, you saved me the trouble.
No worries - I got a good laugh out of it.
I do love it when someone rocks up on a thread and says, "Er, you do realize that [misconception] don't you?"
September 14, 2012 at 11:09 am
My new career: http://www.geekologie.com/2012/09/now-run-them-through-with-a-katana-londo.php
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
September 14, 2012 at 11:20 am
jcrawf02 (9/14/2012)
My new career: http://www.geekologie.com/2012/09/now-run-them-through-with-a-katana-londo.php
Where do I go to volunteer?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 14, 2012 at 11:20 am
SQL Kiwi (9/14/2012)
GilaMonster (9/14/2012)
SQL Kiwi (9/14/2012)
Lynn Pettis (9/14/2012)
Hey, any comments on what is posted here?My first reaction was, "LOL!". Posted a more serious comment.
Thank you, you saved me the trouble.
No worries - I got a good laugh out of it.
I do love it when someone rocks up on a thread and says, "Er, you do realize that [misconception] don't you?"
Yup. Very much so.
I must add that one to the list of query execution/optimisation related misconceptions I want to write about sometime.
The person in question there has got a little aggressive about defending his position before (at least to me). Not 'non-updating update' bad, but still more forceful than I would like.
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 14, 2012 at 11:25 am
GilaMonster (9/14/2012)
Not 'non-updating update' bad, but still more forceful than I would like.
Oh don't remind me! Ha ha ha.
September 14, 2012 at 12:36 pm
GilaMonster (9/14/2012)
SQL Kiwi (9/14/2012)
GilaMonster (9/14/2012)
SQL Kiwi (9/14/2012)
Lynn Pettis (9/14/2012)
Hey, any comments on what is posted here?My first reaction was, "LOL!". Posted a more serious comment.
Thank you, you saved me the trouble.
No worries - I got a good laugh out of it.
I do love it when someone rocks up on a thread and says, "Er, you do realize that [misconception] don't you?"
Yup. Very much so.
I must add that one to the list of query execution/optimisation related misconceptions I want to write about sometime.
The person in question there has got a little aggressive about defending his position before (at least to me). Not 'non-updating update' bad, but still more forceful than I would like.
Same with me on a totally different topic recently too.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 15 posts - 37,831 through 37,845 (of 66,738 total)
You must be logged in to reply to this topic. Login to reply