Home
Search results “Oracle partition stats”
Optimizer Statistics
 
11:10
Optimizer Statistics watch more videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjab, Tutorials Point India Private Limited
What is a Hash Partition in Oracle
 
09:07
What is a Hash Partition in Oracle SQL Tutorial SQL Tutorial for beginners PLSQL Tutorial PLSQL Tutorial for beginners PL/SQL Tutorial PL SQL Tutorial PL SQL Tutorial for beginners PL/SQL Tutorial for beginners Oracle SQL Tutorial
Views: 1345 TechLake
Oracle Database Performance Tuning - Optimizer Statistics Gathering - 11g, 12c
 
04:51
Oracle Database Performance Tuning - Optimizer Statistics Gathering - 11g, 12c In this video we explain how to gather the database optimizer statistics #performancetuning, #oracledatabase, #oracle, #database, #optimizerstatistics, #learning, About Optimizer Statistics Collection In Oracle Database, optimizer statistics collection is the gathering of optimizer statistics for database objects, including fixed objects. The database can collect optimizer statistics automatically. You can also collect them manually using the DBMS_STATS package. Oracle Database Performance Tuning - Optimizer Statistics Gathering - 11g, 12c Purpose of Optimizer Statistics Collection The contents of tables and associated indexes change frequently, which can lead the optimizer to choose suboptimal execution plan for queries. To avoid potential performance issues, statistics must be kept current. To minimize DBA involvement, Oracle Database automatically gathers optimizer statistics at various times. Some automatic options are configurable, such enabling AutoTask to run DBMS_STATS. Oracle Database Performance Tuning - Optimizer Statistics Gathering - 11g, 12c Stats collection Stats gathering database performance tuning, 10g, 11g 12c database administration
Views: 625 KINGS TUBE
Oracle Database 12c: Enhanced Optimizer Statistics with Tom Kyte
 
09:11
Tom Kyte discusses enhanced optimizer statistics followed by a demo of on-load statistics gathering in Oracle Database 12c. "Online Statistics Gathering for Bulk Loads" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=TGSQL344 "Histograms" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=TGSQL366 "CREATE TABLE ... AS SELECT" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=DWHSG8317 "CREATE TABLE" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=SQLRF01402
Views: 8425 OracleDBVision
How to gather session stats using Session Built In Variable.
 
08:13
How to gather session stats using Session Built In Variable? Use session built in variable at command or email component of a respective task's command tab.
Views: 1922 Mandar Gogate
Oracle SQL Performance Tuning  1
 
06:49
Oracle SQL Performance Tuning and tips Cost Based Optimizer (CBO) Rule Based Optimizer (RBO) SQL Explain Plan Oracle Explain Plan
Views: 18225 TechLake
ORACLE WORLD - Understanding Oracle Optimizer Statistics part-2nd
 
10:09
Hello friends in this video i'm just showing to you what is optimizer statistics into oracle,optimizer help to improve the performance of sql statements during execution period. #ORACLEWORLD #OptimizerStatistics Oracle database Unbeatable,Unbreakable Platform.
Views: 2413 Oracle World
Libguide v2 Gathering Stats
 
02:03
A short video on how to gather usage statistics in LibGuides v2
Views: 142 Lisa Hastings
0303 Gathering Statistics
 
01:13
ORACLE
Views: 1934 oracle ocm
How can I speed up a query if an index cannot help?
 
08:20
blog: connor-mcdonald.com Highlights from the April DBA Office Hours session. Office Hours is 100% free Q&A sessions held every month by Oracle experts to help you succeed with the Oracle suite of technologies. Music: Smells Like Summer - Del (Vlog Music No Copyrighted) Video Link: https://youtu.be/IrkMsqcOjGU
Views: 1451 Connor McDonald
0302 About Optimizer Statistics
 
03:21
ORACLE
Views: 128 oracle ocm
Partition Tables
 
11:26
Discussion of partition tables, including DOS and GPT tables, partition type codes, and alignment.
Views: 831 Mike Murphy
20 Essential Oracle SQL and PL/SQL Tuning Tips
 
01:11:53
SQL and PL/SQL are powerful languages used to access an Oracle database. Today's databases contain mountains of data which presents itself as a challenge when trying to get to the data we want to in a timely fashion. In this FREE Webinar, OCP DBA John Mullins will present 20 valuable tips to help your SQL or PL/SQL perform better. The tips cover every angle regarding SQL and PL/SQL performance, making the presentation suitable for all job roles. Demonstrations will be used to support many of the tips and Oracle 11g and 12c will be covered.
Views: 42787 Themis Education
How is SQL Server Statistics Histogram Computation Used by The Query Optimizer – Part 1 (by Amit)
 
10:22
In this video, you will understand how is the histogram computation (SQL Server Statistics Data) used by the Query Optimizer for cardinality estimation. Particularly, you will see the usage of EQ_ROWS & AVG_RANGE_ROWS. Learn about Amit Bansal’s ultimate video course on SQL Server Performance Tuning: http://bit.ly/abvideocourse Stay Connected with Amit Bansal and subscribe to the exclusive list of his session attendees (conference and pre-cons), class participants & video viewers. You will get just one email in two weeks with good links to continue your learning. http://bit.ly/connectwithab Also, you can join ‘SQLMaestros Champs’ Telegram group and participate in SQL Server discussions. It’s a forum for SQL Server lovers - https://t.me/joinchat/AnAGwxBU1KXORoUR9jD_dw If you work on other technologies in MS Data + AI Stack, join this group: http://www.dataplatformgeeks.com/dpg-mobile/ Video resources including presentation, demo files, code snippets and more learning material is available on http://www.dataplatformgeeks.com/ (Join for free and access all the resources) Connect With The Speaker (Amit Bansal) -Follow on Twitter: https://twitter.com/A_Bansal -Follow on FaceBook at http://www.facebook.com/amit.r.bansal -Follow on LinkedIN: http://www.linkedin.com/in/amitbansal2010 -Facebook Page: https://www.facebook.com/AmitRSBansal/ Connect with SQLMaestros: http://sqlmaestros.com/ - http://www.twitter.com/SQLMaestros - https://www.facebook.com/SQLMaestros - Email us: [email protected] Data Platform Summit Asia's largest learning event on AI, Data & Advanced Analytics. https://www.dps10.com/ SQLMaestros Video Courses Amit Bansal’s popular SQL Performance Tuning course is now going live in video format. http://sqlmaestros.com/sql-server-videos-courses/ SQLMaestros Hands-On-Labs Want to practice SQL, Azure & BI concepts, step-by-step with exercises, screenshots, instructions & explanations? Get access to 100+ labs covering the entire Microsoft Data Platform stack. Try SQLMaestros Hands-On-Labs – the new way of practical, self-paced learning. Anytime. Anywhere. http://hols.SQLMaestros.com Email [email protected] SQLMaestros Learning Kits The kit comprises of PowerPoint presentations, lab manuals, workbook & instructor demos & notes. The kit is based on Amit Bansal’s Performance Tuning Master Class. https://sqlmaestros.com/sql-server-courseware/ SQL Server Health Check If your SQL Server deployments are not performing good or if you have seen early signs of performance degradation, SQLMaestros can help you with a thorough health check. https://sqlmaestros.com/sql-server-health-check/ Have technical questions? Join the largest SQL group on FB www.facebook.com/groups/theSQLGeeks Our LinkedIn group https://www.linkedin.com/groups/6753546 Our Telegram group on mobile http://www.dataplatformgeeks.com/dpg-mobile/ DataPlatformGeeks (DPG) Community Join the fastest growing community of data & analytics professionals Why Join DPG? http://www.dataplatformgeeks.com/ -Attend all events hosted by DPG, including SQLMaestros Special Events -Get access to free videos, labs, magazines and host of learning resources -Download all events & conference material -Learn new skills. Sharpen existing skills -Be part of Asia’s Largest Data/Analytics Community -Opportunity to be a regional mentor & speaker at our events -Immense technical & professional development If you wish to speak at DataPlatformGeeks events, fill out this form: http://www.dataplatformgeeks.com/call-speakers-dpg-events/ If you wish to become a Regional Mentor with DataPlatformGeeks, fill out this form: http://www.dataplatformgeeks.com/become-regional-mentor/ Watch all recorded DPG webinars here: www.youtube.com/SQLServerGeeks
Views: 776 SQLMaestros
Oracle Indexes - Beginner
 
12:12
Oracle Indexes - Beginner
Views: 67834 Chris Ostrowski
Stats Explanation
 
10:25
Oracle Rugby offers an insight to how stats are calculated in tipping for more go to: http://oraclerugby.com/
Views: 202 Oracle Rugby
Oracle Optimization course, PL/SQL Tutorial - Table Partitions (Lesson 3)
 
15:07
Oracle optimization: create table partitions and Index-Organized Table. Other lessons, visit https://www.youtube.com/watch?v=9RlxvHMg9PI&list=PL99-DcFspRUoscBHdh39T8EHENfm2VcQ3
Oracle High Water Mark
 
02:31
A Brief video about Oracle's Table High Water Mark and How to resolve issues associated with it Music: https://www.bensound.com
Views: 371 ORA-600
"I Faked My Resume-- Now What?" (Dear SQL DBA Episode 46)
 
13:34
This week's question from a reader: "How do I deal with interview questions asking about real-world scenarios when I've faked three years of experience on my resume?" Hear my answer in this 14 minute video. No time to watch? Subscribe to the audio podcast or read the transcript: https://littlekendra.com/2017/08/28/i-faked-my-resume-now-what/
PART 7 MERGE PARTITION
 
01:54
merge partition, alter table, data warehousing
SQL Tuning with Oracle Database 12c Histograms
 
09:20
Learn the new 12c options for creating histograms. See all free video tutorials at http://www.skillbuilders.com/free-oracle-tutorials. In this free tutorial, Oracle Certified Master DBA John Watson demonstrates what histograms do (provide correct cardinality), the difference between histogram types (Frequency and Height Balanced). You will also learn the importance of the auto sample size algorithm in 12c and the new "Hybrid" and "Top Frequency" type histograms.
Views: 3860 SkillBuilders
Why Table Partitioning Doesn't Speed Up Query Performance
 
19:27
Learn why SQL Server's table partitioning feature doesn't make your queries faster-- and may even make them slower. In this 20 minute video, I'll show you my favorite articles, bugs, and whitepapers online to explain where table partitioning shines and why you might want to implement it, even though it won't solve your query performance problems. Articles discussed are by Gail Shaw, Remus Rusanu, and the SQL Customer Advisory Team (SQLCAT). Get URLs to each article here: http://www.littlekendra.com/2016/05/03/why-table-partitioning-doesnt-speed-up-query-performance-video/
SQL Server DBA Tutorial 48-Update Statistics of All the Databases or Single Database in SQL Server
 
17:23
In this video you will learn how to update Statistics of All databases in SQL Server using SQL Server Management studio as well as using T-SQL Script. It shows different options of updating the statistics such as Index statistics, column statistics and statistics of single database using SQL Server Management Studio as well as using T-SQL Script. Blog post link for the video with script http://sqlage.blogspot.com/2015/04/how-to-update-statistics-stats-of-all.html Visit our website to check out SQL Server DBA Tutorial Step by Step http://www.techbrothersit.com/2014/12/sql-server-dba-tutorial.html
Views: 20363 TechBrothersIT
How to tune SQL code
 
20:28
Efficient techniques to tune SQL code.
Views: 35844 amit wadbude
Oracle Performance Tuning - Function Based Indexes
 
06:51
A overview of the function based index and a common mistake which is made by most of us.
Views: 636 Saurabh Kumar
SAP HANA Academy - SQL Functions: PERCENTILE_CONT and PERCENTILE_DISC  [SPS 10]
 
08:01
*** Important: please read this for prerequisites and links to code. In this lesson we'll use the discrete percentile and the continuous percentile functions in SAP HANA. These two functions are Window Functions meaning that they group a query into sets of rows which are named Window Partitions. They differ in their functionality as one value is based on a continuous distribution of column values while the other is based on a discrete distribution, as their names suggest. The code used in this lesson is available here: https://github.com/saphanaacademy/SQL/blob/master/PERCENTILE_CONT_and_PERCENTILE_DISC.SQL * Please see this playlist for more HANA SQL Function videos: https://www.youtube.com/playlist?list=PLkzo92owKnVwpfj5r9EZrPJdZJdUizexs
Views: 4026 SAP HANA Academy
Should You Rebuild or Reorganize Large Indexes? (Dear SQL DBA Episode 19)
 
23:24
The bigger your indexes are, the harder your index maintenance falls. Is it better to rebuild big indexes? Or should you reorganize? Learn the pros and cons of each command.
Let's Learn Teradata Lesson 82: Collect Statistics
 
03:25
Explore Teradata with Tera-Tom of Coffing Data Warehousing! In this lesson, learn about the Collect Statistics function in Teradata!
SQL Server tutorial 84: How to update database statistics using SSMS or T-SQL
 
04:49
How to update database statistics using T-SQL, or SSMS. For more info, or a copy of any of the scripts used in any of my tutorials, please email me at [email protected]
Views: 4673 Johnny Deluca
Oracle database replay deel 2 van 3
 
04:43
Oracle database replay deel 2 van 3
Views: 220 transfersolutions
Stored Procedure Optimization Techniques
 
01:43:16
Kimberly will discuss stored procedure caching and the potential for performance problems due to a problem known as parameter sniffing. There are some common solutions and while they can drastically improve performance, they can also cause other problems. Sometimes a hybrid solution is needs, from this session, you’ll know the best way to write procedures so that stable requests are cached and unstable requests are not (giving you the most optimal performance without wasting resources). Kimberly Tripp Kimberly’s an author, consultant, and top-rated speaker having spoken at PASS, TechEd, SQLintersection, and numerous other events around the world; she’s also been a Microsoft SQL Server MVP for over 10 years. She has over 25 years of experience designing and tuning SQL Server solutions with a focus on optimizing procedural code, indexing strategies, statistics, and partitioning. When she's not tuning SQL servers, she's diving and photographing all sorts of underwater critters such as frogfish with her husband, Paul S. Randal.
Views: 6972 DBAFundamentals
Using Oracle Metadata to your Advantage Explained with real scenarios.
 
17:15
In this video I have explained who you can use the Oracle metadata tables to your advantage with real project scenarios and situations. The video is a little descriptive it gives you much more than just the syntax and the tables. All database offer a bunch of tables using which you can make smart inferences about your data,process and health of the database. I have explained the below tables in this video and how to use them smartly 1.All_Source 2.all_objects 3.All_tables 4.all_tab_cons 5.all_constraints I will be sharing more such places where we can use these metadata queries so don't forget to subscribe to my channel. If you can questions/clarifications just drop a comment and I will be more than happy to solve your queries.
Views: 5393 Tech Coach
Alex Nuijten - Analytic Functions: Unleash the SQL Power
 
51:00
Analytic Functions have been around for quite a long time, and still they are a relatively unknown. If you are unfamiliar with these very powerful functions, you are missing out on something spectacular. Analytic Functions add inter-row calculations, aggregates over multiple dimensions, or rank assignment based on values within a group of values - all without a GROUP BY clause. The syntax might seem daunting at first, but it is really not that scary. This session will focus on the syntax with tons of real world uses for Analytic Functions.
Views: 972 Riga Dev Days
09 06 Monitoring Index Usage
 
04:27
ORACLE
Views: 147 oracle ocm
Improve SQL Server performance using profiler and tuning advisor
 
13:12
For more such videos visit http://www.questpond.com See our other Step by Step video series below :- Learn SQL Server Step by Step in 16 hours:- http://tinyurl.com/ja4zmwu Learn MSBI Step by Step in 32 hours:- https://goo.gl/TTpFZN Learn Angular tutorial for beginners https://tinyurl.com/ycd9j895 Learn MVC Core step by step :- http://tinyurl.com/y9jt3wkv Learn MVC 5 Step by Step in 16 hours:- https://goo.gl/dmdakg Learn Xamarin Mobile Programming Step by Step :- https://goo.gl/WDVFuy Learn Design Pattern Step by Step in 8 hours:- https://goo.gl/eJdn0m Learn C# Step by Step in 100 hours :- https://goo.gl/FNlqn3 Learn Data structures & algorithm in 8 hours :-https://tinyurl.com/ybx29c5s Learn Javascript in 2 hours :- http://tinyurl.com/zkljbdl Learn SharePoint Step by Step in 8 hours:- https://goo.gl/XQKHeP Learn TypeScript in 45 Minutes :- https://goo.gl/oRkawI Learn webpack in 50 minutes:- https://goo.gl/ab7VJi Learn Visual Studio code in 10 steps for beginners:- https://tinyurl.com/lwgv8r8 Learn Tableau step by step :- https://tinyurl.com/kh6ojyo This video first starts with a simple explanation of what is a SQL server profiler and performance tuning wizard. After completing the basic concepts it then demonstrates a simple example using two tables by capturing the work load and understanding the recommendations given by the tuning wizard. For more such videos visit http://www.questpond.com We are also distributing a 100 page Ebook "Sql Server Interview Questions". If you want this ebook please share this video in your facebook/twitter/linkedin account and email us on [email protected] with the shared link and we will email you the PDF.
Introduction to the KNIME data mining system (tutorial)
 
02:23
Tutorial regarding how to build a workflow in the KNIME data mining and predictive analytics system. For more information or to download KNIME, please visit: http://www.knime.org/ Brought to you by Rapid Progress Marketing and Modeling, LLC (RPM Squared) http://www.RPMSquared.com/
Views: 42324 Predictive Analytics
Set Statistics IO in SQL Server Tamil
 
07:01
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg Used to display information regarding the amount of disk activity generated by TSQL Statements Scan Count, Physical Reads, Logical Reads
Views: 131 IT Port
SQL Server Statistics and the New Cardinality Estimator Part 1
 
27:32
SQL Server Statistics and the New Cardinality Estimator Part 1
SQL Server Statistics – Are My Stats Objects Being Used?(by Amit Bansal)
 
15:43
In this video, you will learn some quick techniques to identify which stats objects are being used by the SQL Optimizer. These techniques can help you in your query tuning endeavors. Learn about Amit Bansal’s ultimate video course on SQL Server Performance Tuning: http://bit.ly/abvideocourse Stay Connected with Amit Bansal and subscribe to the exclusive list of his session attendees (conference and pre-cons), class participants & video viewers. You will get just one email in two weeks with good links to continue your learning. http://bit.ly/connectwithab Also, you can join ‘SQLMaestros Champs’ Telegram group and participate in SQL Server discussions. It’s a forum for SQL Server lovers - https://t.me/joinchat/AnAGwxBU1KXORoUR9jD_dw If you work on other technologies in MS Data + AI Stack, join this group: http://www.dataplatformgeeks.com/dpg-mobile/ Video resources including presentation, demo files, code snippets and more learning material is available on http://www.dataplatformgeeks.com/ (Join for free and access all the resources) Connect With The Speaker (Amit Bansal) -Follow on Twitter: https://twitter.com/A_Bansal -Follow on FaceBook at http://www.facebook.com/amit.r.bansal -Follow on LinkedIN: http://www.linkedin.com/in/amitbansal2010 -Facebook Page: https://www.facebook.com/AmitRSBansal/ Connect with SQLMaestros: http://sqlmaestros.com/ - http://www.twitter.com/SQLMaestros - https://www.facebook.com/SQLMaestros - Email us: [email protected] Data Platform Summit Asia's largest learning event on AI, Data & Advanced Analytics. https://www.dps10.com/ SQLMaestros Video Courses Amit Bansal’s popular SQL Performance Tuning course is now going live in video format. http://sqlmaestros.com/sql-server-videos-courses/ SQLMaestros Hands-On-Labs Want to practice SQL, Azure & BI concepts, step-by-step with exercises, screenshots, instructions & explanations? Get access to 100+ labs covering the entire Microsoft Data Platform stack. Try SQLMaestros Hands-On-Labs – the new way of practical, self-paced learning. Anytime. Anywhere. http://hols.SQLMaestros.com Email [email protected] SQLMaestros Learning Kits The kit comprises of PowerPoint presentations, lab manuals, workbook & instructor demos & notes. The kit is based on Amit Bansal’s Performance Tuning Master Class. https://sqlmaestros.com/sql-server-courseware/ SQL Server Health Check If your SQL Server deployments are not performing good or if you have seen early signs of performance degradation, SQLMaestros can help you with a thorough health check. https://sqlmaestros.com/sql-server-health-check/ Have technical questions? Join the largest SQL group on FB www.facebook.com/groups/theSQLGeeks Our LinkedIn group https://www.linkedin.com/groups/6753546 Our Telegram group on mobile http://www.dataplatformgeeks.com/dpg-mobile/ DataPlatformGeeks (DPG) Community Join the fastest growing community of data & analytics professionals Why Join DPG? http://www.dataplatformgeeks.com/ -Attend all events hosted by DPG, including SQLMaestros Special Events -Get access to free videos, labs, magazines and host of learning resources -Download all events & conference material -Learn new skills. Sharpen existing skills -Be part of Asia’s Largest Data/Analytics Community -Opportunity to be a regional mentor & speaker at our events -Immense technical & professional development If you wish to speak at DataPlatformGeeks events, fill out this form: http://www.dataplatformgeeks.com/call-speakers-dpg-events/ If you wish to become a Regional Mentor with DataPlatformGeeks, fill out this form: http://www.dataplatformgeeks.com/become-regional-mentor/ Watch all recorded DPG webinars here: www.youtube.com/SQLServerGeeks
Views: 537 SQLMaestros
Advanced SQL and the Power of Rewriting Queries
 
57:53
Presented by Tony Andrews, Themis Inc. Often times there can 4,5,6 different ways to write an SQL query and get the same results back. What makes one better than any of the others, and is there any ones that are always better, or always worse? Sometimes rewriting 1 predicate in an SQL statement can cause optimization to change. This presentation breaks down many examples of query rewrites and how they can affect performance and optimization. Being strong in SQL is a great skill when it comes to performance and tuning of queries. Tony Andrews has more than 25 years’ experience in the development of relational database applications. Most of this time, he has provided development and consulting services to Fortune 500 companies and government agencies. Tony has written literally thousands of queries and programs during his development years, and has also served as a database analyst. For the last 10 years, Tony has been splitting his time between performance and tuning consulting engagements along with training. His main focus is to teach today’s developers the ways of RDMS application design, development and SQL programming -- always with a special emphasis on improving performance. He is a current IBM Champion, and regular speaker at many regional user groups, IDUG NA, and IDUG EMEA. He is also the author of a book for developers titled ‘DB2 SQL Tuning Tips for z/OS Developers’.
SQL Server tutorial 81: Rebuilding Indexes
 
06:56
How to rebuild an index with SSMS or T-SQL. For more info, or a copy of any of the scripts used in any of my tutorials, please email me at [email protected]
Views: 14003 Johnny Deluca
Ms SQL Server DBA Experienced Interview Questions And Answers - 08
 
20:06
Ms SQL Server DBA Experienced Interview Questions And Answers - 08 Like Share And Comment Below. Don't Forget To Subscribe My Channel ▶DONT CLICK THIS -https://bit.ly/2MwpkxO sql server sql server management studio sql server express sql server 2005 sql server download sql server tutorial sql server port sql server reporting services what is sql server sql server agent download sql server sql server version sql server 2000 sql server replication sql server client sql server trigger free sql server sql server training sql server developer sql server function sql server enterprise manager sql server select sql server instance sql server tools sql server data type sql server view sql server execution plan connect to sql server sql server procedure sql server 2003 sql servers sql server license sql server error 17 sql server performance sql server queries sql server driver transaction sql server sql server commands server sql sql server for sql server service pack sql server stored procedures sql server course sql server express 2010 sql server text sql server courses sql server support stored procedures sql server sql server sql sql server magazine sql server gui sql server service pack 3 sql server resume sql server sp3 using sql server sql server utility sql server error 80004005 odbc sql server driver timeout expired sql server 2005 developer edition download sql server sp4 sql server position as in sql server sql server qualifications administering sql server sql server serveradmin sql server openings sql server experience
Views: 16344 Real Time Interviews
How to run and use the Project Statistics Report contained in Informatica Data Subset
 
08:45
This video walks throught he process of runnng the project statistics report contained in the Informatica TDM Data Subset for use with SAP version 6.1D product.
Views: 156 Informatica Support
Identifying and Fixing Performance Problems using Execution Plans
 
01:07:21
Check Out Our Performance Tuning Blog - http://blog.pragmaticworks.com/topic/performance-tuning This session will demonstrate how SQL Server execution plans can be used to identify problems with the database design, or the TSQL code, and address those problems. The session takes the user through various common issues such as poor or missing indexes, badly written code and generally bad query performance, demonstrating how to identify the issues involved using execution plans. The session will then demonstrate different methods for addressing the issues and show how the fixed query’s execution plans differ. Multiple methods for accessing execution plans including graphical, DMV’s, and trace events are demonstrated. All this is meant to lay a foundation for a general troubleshooting approach to empower the attendee to make their own queries run faster and more consistently.
Views: 310 Pragmatic Works
Stored Procedure Optimization Techniques
 
13:50
Performance Tunning : Procedure : 1.Set Nocount On 2.Set Isolation level Read Uncommited / Nolock 3.Missing Indexes : 4.Scalar function 5.COvering index -- include 6.Partition . 7.Proper Index -- Column Store 9.Try to minimize Physical read 10.Fragmentation issue (Index rebuilding + Reorganizing ) 11.understand Execution planning (opertor )
Views: 16976 SqlIsEasy
How Do I Analyze a SQL Server Execution Plan? (Dear SQL DBA Episode 50)
 
26:17
Prefer a written transcript? Go to https://littlekendra.com/2017/09/22/how-do-i-analyze-a-sql-server-execution-plan/ A query is slow, and you figure out how to collect the query execution plan. Now what? In this episode I talk "big picture" about what execution plans are, what "cost" is, why to collect "compiled for" values, and the steps I take to analyze execution plans while performance tuning queries.
Should I Get Certified as a DBA? (Dear SQL DBA Episode 41)
 
17:30
Find out if getting certified will help you land an entry level DBA job, and if you do want to get certified, get Kendra's tips on preparing for the exam. Links to resources mentioned in the video: SQL Server User Groups - http://www.pass.org/Community/Groups/LocalGroups.aspx SQL Saturdays - http://sqlsaturday.com/