Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 1234»»»

Table Access Order Expand / Collapse
Author
Message
Posted Monday, September 19, 2011 9:52 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 5:09 PM
Points: 11,168, Visits: 10,932
Comments posted to this topic are about the item Table Access Order



Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #1177618
Posted Monday, September 19, 2011 9:52 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 9:16 AM
Points: 20,465, Visits: 14,095
Thanks for another superb question Paul.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1177619
Posted Monday, September 19, 2011 10:33 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 5:09 PM
Points: 11,168, Visits: 10,932
SQLRNNR (9/19/2011)
Thanks for another superb question Paul.

Thanks for leaving a comment - I had completely forgotten this was scheduled for today!




Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #1177632
Posted Monday, September 19, 2011 10:37 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 9:16 AM
Points: 20,465, Visits: 14,095
SQL Kiwi (9/19/2011)
SQLRNNR (9/19/2011)
Thanks for another superb question Paul.

Thanks for leaving a comment - I had completely forgotten this was scheduled for today!


The timing of the question is good. It gives me more info to research for an article I have been stumped on for a few months.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1177633
Posted Monday, September 19, 2011 10:51 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 10:29 AM
Points: 1,592, Visits: 1,488
Even though i got it right, I wasn't 100% sure that it wasn't answer C. Great information!



My blog: SQL Soldier
Twitter: @SQLSoldier
My book: Pro SQL Server 2008 Mirroring
Microsoft Certified Master: SQL Server 2008
Principal DBA: Outerwall, Inc.
Also available for consulting: SQL DBA Master
Post #1177638
Posted Monday, September 19, 2011 10:56 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, April 14, 2014 5:49 PM
Points: 2,263, Visits: 3,758
Nice to see questions like this :)

Mohammed Moinudheen
Post #1177640
Posted Tuesday, September 20, 2011 12:46 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, April 17, 2014 1:16 AM
Points: 2,826, Visits: 2,836
Good question - thanks

-------------------------------
Posting Data Etiquette - Jeff Moden
Smart way to ask a question

There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
Post #1177664
Posted Tuesday, September 20, 2011 1:07 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 4:45 AM
Points: 2,385, Visits: 1,843
Nice Question!!!

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #1177667
Posted Tuesday, September 20, 2011 1:17 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, April 14, 2014 2:13 AM
Points: 1,160, Visits: 1,470
Thank you very much for such an interesting question. Got the old grey matter going!

Bex
Post #1177674
Posted Tuesday, September 20, 2011 1:51 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 6:40 AM
Points: 3,683, Visits: 4,818
Thanks for the interesting question, Paul
really got the grey matter working this morning.


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1177683
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse