1 / 9

October 1-2 Ølensvåg

October 1-2 Ølensvåg. Session Code: SQL-401-Hardcore Speaker(s): Vidar Nordnes. Hardcore SQL. sa’s password is blank. Easier that way. Whops! Forgot the WHERE clause. Backups? What backups? I used a clustered index so it’ll be redundant!

quanda
Download Presentation

October 1-2 Ølensvåg

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. October 1-2 Ølensvåg

  2. Session Code: SQL-401-Hardcore Speaker(s): Vidar Nordnes Hardcore SQL

  3. sa’s password is blank. Easier that way. • Whops! Forgot the WHERE clause. • Backups? What backups? • I used a clustered index so it’ll be redundant! • Hey, what were you storing in that database? Was it important? No reason, I’m just, uh, curious • Why is my log file sooo much bigger than my database? • DMV? Yeah I’ve got to go renew my license! Thanks for reminding me • We’re migrating to Access • Just put it all on one disk #thingsYouShouldNeverHearADBASay

  4. WHY shrink database is a big NO NO • What happens when you press F5? • How to read the Execution Plan • Index maintenance • Backup and restorestrategies Agenda:

  5. WHY shrink database is a big NO NO

  6. Is this syntax ok? Algebrizer Output: Processor tree What happens when you press F5? Which tables? How many rows? Lowest cost? Query Optimization Output: Execution plan Execution

  7. Index Scan Index Seek How to read the Execution Plan Compute Scalar Delete Filter Hash Match Insert

  8. Remove Indexes Index Maintenance Observe Add Indexes

  9. Backup types • Full • Differential • Transaction Log Backup and restorestrategies Tran Tran Tran Tran Tran Thursday Tuesday Wednesday Monday Sunday Friday Saturday Diff Diff Full Diff Diff Diff Diff

More Related