[null, null, {"document_url": "https://slideplayer.com/slide/231891/", "unformatted_src": "/1/4928/big_thumb.jpg", "src": "https://slideplayer.com/1/4928/big_thumb.jpg", "formatted_filename": "big thumb", "alt_text": "Using the SQL Access Advisor"}, null, {"document_url": "https://slideplayer.com/slide/231891/", "unformatted_src": "/5/1527361/big_thumb.jpg", "src": "https://slideplayer.com/5/1527361/big_thumb.jpg", "formatted_filename": "big thumb", "alt_text": "Why is that LOV in the screen not returning me desired value?"}, null, {"document_url": "https://slideplayer.com/slide/231891/", "unformatted_src": "/5/1577119/big_thumb.jpg", "src": "https://slideplayer.com/5/1577119/big_thumb.jpg", "formatted_filename": "big thumb", "alt_text": "Copyright \u00a9 1999-2000 SoftTree Technologies, Inc. DB Tuning Expert."}, null, {"document_url": "https://slideplayer.com/slide/231891/", "unformatted_src": "/5/1596621/big_thumb.jpg", "src": "https://slideplayer.com/5/1596621/big_thumb.jpg", "formatted_filename": "big thumb", "alt_text": "Copyright \u00a9 2011 by the Commonwealth of Pennsylvania. All Rights Reserved. Load Test Report."}, null, {"document_url": "https://slideplayer.com/slide/231891/", "unformatted_src": "/7/1650028/big_thumb.jpg", "src": "https://slideplayer.com/7/1650028/big_thumb.jpg", "formatted_filename": "big thumb", "alt_text": "Data Management and Index Options for SQL Server Data Warehouses Atlanta MDF."}, null, {"document_url": "https://slideplayer.com/slide/231891/", "unformatted_src": "/7/1652113/big_thumb.jpg", "src": "https://slideplayer.com/7/1652113/big_thumb.jpg", "formatted_filename": "big thumb", "alt_text": "Creating Tables. 2 home back first prev next last What Will I Learn? List and provide an example of each of the number, character, and date data types."}, null, {"document_url": "https://slideplayer.com/slide/231891/", "unformatted_src": "/11/3318166/big_thumb.jpg", "src": "https://slideplayer.com/11/3318166/big_thumb.jpg", "formatted_filename": "big thumb", "alt_text": "\u00a9 IBM Corporation 2006 1 Informix Chat with the Labs John F. Miller III Unlocking the Mysteries Behind Update Statistics STSM."}, null, {"document_url": "https://slideplayer.com/slide/231891/", "unformatted_src": "/12/3389702/big_thumb.jpg", "src": "https://slideplayer.com/12/3389702/big_thumb.jpg", "formatted_filename": "big thumb", "alt_text": "Big Data Working with Terabytes in SQL Server Andrew Novick www.NovickSoftware.com."}, null, {"document_url": "https://slideplayer.com/slide/231891/", "unformatted_src": "/12/3521000/big_thumb.jpg", "src": "https://slideplayer.com/12/3521000/big_thumb.jpg", "formatted_filename": "big thumb", "alt_text": "1 SQL Server Management Studio SQL DDL CREATE TABLE Constraints ALTER TABLE DROP TABLE The GUI way Steen Jensen, autumn 2013."}, null, {"document_url": "https://slideplayer.com/slide/231891/", "unformatted_src": "/12/3654066/big_thumb.jpg", "src": "https://slideplayer.com/12/3654066/big_thumb.jpg", "formatted_filename": "big thumb", "alt_text": "1. \uf07d Understanding about How to Working with Server Side Scripting using PHP Framework (CodeIgniter) 2."}, null, {"document_url": "https://slideplayer.com/slide/231891/", "unformatted_src": "/13/4129592/big_thumb.jpg", "src": "https://slideplayer.com/13/4129592/big_thumb.jpg", "formatted_filename": "big thumb", "alt_text": "1Key \u2013 Report Creation with DB2. DB2 Databases Create Domain for DB2 Test Demo."}, null, {"document_url": "https://slideplayer.com/slide/231891/", "unformatted_src": "/14/4191021/big_thumb.jpg", "src": "https://slideplayer.com/14/4191021/big_thumb.jpg", "formatted_filename": "big thumb", "alt_text": "Common Mistakes Developers Make By Bryan Oliver SQL Server Mentor at SolidQ."}, null, {"document_url": "https://slideplayer.com/slide/231891/", "unformatted_src": "/14/4334513/big_thumb.jpg", "src": "https://slideplayer.com/14/4334513/big_thumb.jpg", "formatted_filename": "big thumb", "alt_text": "ERWin Template Overview By: Dave Wentzel. Agenda u Overview of Templates/Macros u Template editor u Available templates u Independent column browser u."}, null, {"document_url": "https://slideplayer.com/slide/231891/", "unformatted_src": "/15/4597405/big_thumb.jpg", "src": "https://slideplayer.com/15/4597405/big_thumb.jpg", "formatted_filename": "big thumb", "alt_text": "10 Things Not To Do With SQL SQLBits 7. Some things you shouldn\u2019t do."}, null, {"document_url": "https://slideplayer.com/slide/231891/", "unformatted_src": "/15/4710376/big_thumb.jpg", "src": "https://slideplayer.com/15/4710376/big_thumb.jpg", "formatted_filename": "big thumb", "alt_text": "DIMES Planner The DIMES Project Tel Aviv University October-2010."}, null, {"document_url": "https://slideplayer.com/slide/231891/", "unformatted_src": "/16/4928271/big_thumb.jpg", "src": "https://slideplayer.com/16/4928271/big_thumb.jpg", "formatted_filename": "big thumb", "alt_text": "A U Database Review Professor J. Alberto Espinosa ITEC 334 Fall 2010 Online (Business) Application Development."}, null, {"document_url": "https://slideplayer.com/slide/231891/", "unformatted_src": "/16/4936304/big_thumb.jpg", "src": "https://slideplayer.com/16/4936304/big_thumb.jpg", "formatted_filename": "big thumb", "alt_text": "A Guide to SQL, Seventh Edition. Objectives Create a new table from an existing table Change data using the UPDATE command Add new data using the INSERT."}, null, {"document_url": "https://slideplayer.com/slide/231891/", "unformatted_src": "/16/5130274/big_thumb.jpg", "src": "https://slideplayer.com/16/5130274/big_thumb.jpg", "formatted_filename": "big thumb", "alt_text": "Multiple Tiers in Action"}, null, {"document_url": "https://slideplayer.com/slide/231891/", "unformatted_src": "/19/5813828/big_thumb.jpg", "src": "https://slideplayer.com/19/5813828/big_thumb.jpg", "formatted_filename": "big thumb", "alt_text": "Structured Query Language SQL IST359 M005 Yang Wang 342 Hinds"}, null, {"document_url": "https://slideplayer.com/slide/231891/", "unformatted_src": "/19/5862435/big_thumb.jpg", "src": "https://slideplayer.com/19/5862435/big_thumb.jpg", "formatted_filename": "big thumb", "alt_text": "Soror SAHRI SD-SQL Server: a Scalable Distributed Database."}, null, null]
Simon Liao Survive in Database --For New Developers.

Published byMichael MacLean Modified over 4 years ago


Presentation on theme: "Simon Liao Survive in Database --For New Developers."— Presentation transcript:

1 Simon Liao Survive in Database --For New Developers

2 Agenda Welcome to ETOWN family DBA team recommend Release team suggest SQL Server likes Q & A

3 DBA team Release team

4 SQL Server SQL 2005 SP2 (9.0.3042) SQL 2008 R2 (10.50.1600)

5 DBA Recommend (1) SP Create [TableName]_[Action]_p use dbo prefix set nocount on go permission grant to db base role SP Alter No drop/create V2 when parameter number changes CodeSpewWizard tool $/Builds/_Builds/Tools/CodeSpewingWizard

6 DBA Recommend (2) Table Create Singular form CapitalCasing _lkp, _lnk, w* PK, FK, UQ Collate SQL_Latin1_General_CP1_CI_AI InsertDate/UpdateDate Table Drop _RemoveMeAfter20101201_ByXXX No _new, _1, _2, _bak

7 DBA Recommend (3) Data Update Select before update with the same where clause Use usb-etowndevts to access U.S.-based db servers Add yourself in EnglishtownDevelopersShanghai group Add your Chinese name in your Skype

8 Release Team Suggest AutoBuild tool Run it before you request DB review Release Request (RR) submit Dont forget click Request Review Email/DropBy me for emergency release Take care the New/Update action Take care the US/CN/Both environment flags Read-only data release Just get it ready in QA db server No need db script

9 SQL Server Likes (1) WITH (NOLOCK) Specially for large table and live servers No transaction We never use it except few scenarios No Select * No covering index except table scan Additional disk IO and network bandwidth SELECT TOP 10 Order By PK column

10 SQL Server Likes (2) Sequential inserting to avoid page split Identity column LastID Execute queries in VS3 instead of VS1 Avoid additional workload for VS1 VS3 has more indexes and much lighter workload Cancel any query running longer than 2 minutes Try stricter Where clause at first, then less Filter the data based on famous index columns ET_Main..Members: MemberId, UserName, Email, PartnerSite ET_Payment..PaymentRequest: MemberId, Email VisitTracking: VisitDate PageVisit: VisitDate

11 Q & A

12 Thank You

Download ppt "Simon Liao Survive in Database --For New Developers."
 Using the SQL Access Advisor Copyright © SoftTree Technologies, Inc. DB Tuning Expert. Data Management and Index Options for SQL Server Data Warehouses Atlanta MDF. © IBM Corporation Informix Chat with the Labs John F. Miller III Unlocking the Mysteries Behind Update Statistics STSM. Big Data Working with Terabytes in SQL Server Andrew Novick 1 SQL Server Management Studio SQL DDL CREATE TABLE Constraints ALTER TABLE DROP TABLE The GUI way Steen Jensen, autumn 2013. 1Key – Report Creation with DB2. DB2 Databases Create Domain for DB2 Test Demo. Common Mistakes Developers Make By Bryan Oliver SQL Server Mentor at SolidQ. ERWin Template Overview By: Dave Wentzel. Agenda u Overview of Templates/Macros u Template editor u Available templates u Independent column browser u. 10 Things Not To Do With SQL SQLBits 7. Some things you shouldn’t do. DIMES Planner The DIMES Project Tel Aviv University October-2010. A U Database Review Professor J. Alberto Espinosa ITEC 334 Fall 2010 Online (Business) Application Development. A Guide to SQL, Seventh Edition. Objectives Create a new table from an existing table Change data using the UPDATE command Add new data using the INSERT. Structured Query Language SQL IST359 M005 Yang Wang 342 Hinds Soror SAHRI SD-SQL Server: a Scalable Distributed Database.

