Parameter Sniffing and Query Optimization
In this content, Benjamin Nevarez discusses the concepts of parameter sniffing, query optimization, and parameterization in SQL Server. He explains the purpose of the query optimizer and procedure cache, different types of parameterization, and provides examples of explicit and implicit parameterization. Dive into the world of SQL Server query tuning with insights from a seasoned professional.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.
E N D
Presentation Transcript
FROM A RESEARCHER TO CEO - MY EXPERIENCE AS A FIRST GENERATION ASIAN-AMERICAN ENGINEER Derek Cheung 5.22.2015 @ Amgen
OUTLINE The power of diversity My career experience Recommendations for career growth
DIVERSITY The size & quality of talent pool is the key for sustainable global competitive advantage USA has an edge over others: Attracts top talent from all over the world Provides the environment to bring out their best Diversity has the added advantage of leveraging unique strengths from multiple cultures for creative problem solving ---------------------------------------------------------------------------------------------------------------- The challenge is to manage diversity effectively
MY CAREER (A MIXTURE OF TECHNOLOGY & BUSINESS) Early Years Childhood - China * High school - Hong Kong * Undergraduate @ Purdue, USA Enlightenment First Job @ Fairchild Semiconductor * PhD @ Stanford A long (32 years) & rewarding career @ Rockwell Science Center in Thousand Oaks Researcher in IR Imaging technology Move up in management: Principal Scientist, Manager, Associate Director Director (Electro-Optics, Electronics, SW & Systems), VP & Chief Scientist RSC Center Director; VP of Research for Rockwell International Corp President & CEO of Rockwell Scientific Company; played key role in acquisition by Teledyne Retirement Founding Director of ITA @ UCLA for technology spin-outs; wrote 2 books on history of electronics; served as senior advisor to several high tech companies and institutions.
TWO PERSPECTIVES ON CAREER GROWTH 1. As a young engineer moving up the career ladder in a major US corporation 2. As CEO of a high-tech company looking at the hiring & development of young talents ------------------------------------------------------------------------------------ Recommendations for tiered career growth, some uniquely tailored for AAs
R1: BASICS FOR CAREER SUCCESS Know your career goal and work for the right employer and boss Achieve success in a Meritocracy system Competent, reliable, dedicated Versatile, flexible, good team worker Proactive, show initiative and continuous self improvement ------------------------------------------------------------------------------------------------------- Be a valuable and useful employee
R2. IMPROVE SOFT SKILLS Don t be overly concerned about Glass Ceiling Focus on Improving communication skills Bridging cultural & value gaps Strengthen EQ (people skill), e.g. Empathy & understand people Emotional maturity & stability; Leadership quality Broaden professional horizon & link with personal goals Understand company strategy & business decisions Recognize opportunities & challenges for career advancement Develop key mentor Soft skills are as important as technical expertise, especially for AAs
R3. BREAK-OUT DIFFERENTIATORS Professional excellence + Business savviness Mastering critical thinking methodology Big picture + logic System-level trade-off and optimization for best solution Some preferred jobs to nurture career growth Experience in Technical Marketing / Sales, Strategic Planning, Production Training ground for senior management Project or Product Leader with P/L responsibilities Build successful track record and be trusted by the decision making team ------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Employer should provide training opportunity for the high potentials
SUMMARY Use Critical thinking for your own career: Know yourself: strengths and weaknesses Asses your situation What is the ideal job for me? Am I on the right track? If yes, what are the next steps that I should take? If no, what are the options? Is it realistic to pursue them? Realize that there is an optimum position, or balance in one s life and career, and they are different for each individual. --------------------------------------------------------------------------------------------------------- Look for win-win solution: Your career satisfaction (happy & productive) and company success !
