速報APP / 教育 / SQL Server Internals Quiz Demo

SQL Server Internals Quiz Demo

價格:免費

更新日期:2018-09-20

檔案大小:3.7M

目前版本:1.40

版本需求:Android 4.1 以上版本

官方網站:https://www.uncoverthe.com/en/sql-server-interview/

Email:Nikolaos.Katsogridakis@gmail.com

聯絡地址:28, Korai str Chalkida 34100 GREECE

SQL Server Internals Quiz Demo(圖1)-速報App

This QUIZ is a free demo with 20 questions about the inner workings of SQL Server. It is part of another QUIZ with the same name but with 200 questions which can be bought for the price of 1,5 EURO on GOOGLE PLAY.

The contents of this application is based on my 20 years of experience as a PRODUCTION DBA. My primary role was to tune TSQL queries and stored procedures optimally given the available hardware at a client.

The following topics will be discussed:

SQL Server Internals Quiz Demo(圖2)-速報App

- Optimizer/Cardinality Estimator

- Locking/blocking/Latching.

- Data/Procedure cache management.

SQL Server Internals Quiz Demo(圖3)-速報App

- Index Usage

- Plan Reuse

- Isolation levels

SQL Server Internals Quiz Demo(圖4)-速報App

- Query optimization

- Query hints

Important hints for using the app.

SQL Server Internals Quiz Demo(圖5)-速報App

- Long click on Next/Previous buttons, goes to the Next/Previous unanswered question.

- By default, when you run the app, "Quiz Mode" is off (FAB Icon is Green), turn it ON to update the stats from settings or use FAB icon.

- Your answers are saved when exit the app and if "Quiz Mode" in settings is ON or FAB Icon is Red.

SQL Server Internals Quiz Demo(圖6)-速報App

- If you want to uninstall the app, go to settings and see the section "Delete ALL"

SQL Server Internals Quiz Demo(圖7)-速報App