1 / 12

Back to Indexes – The Original culprits

Back to Indexes – The Original culprits. Amit Bansal CTO, eDominer Systems & Peopleware India www.amitbansal.net | @ A_Bansal. Your Speaker. CTO, eDominer Systems & Peopleware India Corporate Trainer/Consultant & Evangelist

torin
Download Presentation

Back to Indexes – The Original culprits

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Back to Indexes – The Original culprits Amit Bansal CTO, eDominer Systems & Peopleware India www.amitbansal.net | @A_Bansal

  2. Your Speaker • CTO, eDominer Systems & Peopleware India • Corporate Trainer/Consultant & Evangelist • Conducted more than 450+ workshops on SQL Server & BI for top notch IT companies world wide • Microsoft MVP for SQL Server • Speaker at TechED India, TechED US & TechEDEurope, SQLBits, MCT Summit • Technical Reviewer/SME – MSL courses & certifications on SQL Server • Co-Founder & President – SQLServerGeeks.com

  3. Agenda? • DEMOS DEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOSDEMOS

  4. Comparing performance

  5. Comparing performance LA 0 LB 1 LC 0 LD 2 LE 0 LF 1 LG 0 LH 2 LI 0 LJ 1 LK 0 LM 2 LN 0 LO 1 LP 0 LQ 2 LR 0 LS 1 LT 0 LU 2 LV 0 LW 1 LX 0 LY 2 0 LA 0 LC 0 LE 0 LG 0 LI 0 LK 0 LN 0 LZ 1 LA 1 LF 1 LJ 1 LO 1 LOA 1 LOB 1 LOC 1 LOD 1 LS 1 LZ 2 LA 2 LH 2 LM 2 LQ 2 LU 2 LZ

  6. Comparing performance LA 0 LB 1 LC 0 LD 2 LE 0 LF 1 LG 0 LH 2 LI 0 LJ 1 LK 0 LM 2 LN 0 LO 1 LP 0 LQ 2 LR 0 LS 1 LT 0 LU 2 0 LA 0 LC 0 LE 0 LG 0 LI 0 LK 0 LN 0 LP 1 LB 1 LF 1 LJ 1 LO 1 LS 1 LW 2 LD 2 LH 2 LM 2 LQ 2 LU 2 LY

  7. Call to Action / Summary • ALWAYS try various combinations • Guidelines / rule of thumb are good – but exceptions can be there • Download the scripts from www.SQLServerGeeks.com/files • Follow me on twitter for more webcasts: @A_Bansal

  8. Thank you  for suggestions, please email at amit.bansal@peoplewareindia.com

  9. Join my network • Join my network: • Personal Site – http://www.amitbansal.net • LinkedIn – http://www.linkedin.com/in/AmitBansal2010 • Forum – www.SQLServerGeeks.com • FaceBook – http://www.facebook.com/people/Amit-Bansal/525339346 • Twitter – http://www.twitter.com/A_Bansal • Blog – www.SQLServerGeeks.com

More Related