Home
Search results “Oracle hint range scan”
Indexes in Oracle :Index Scan Methods :Part 2
 
30:18
The Video Explains when should you create indexes. The difference between Simple and composite Index, Relevance of order in composite indexes and Index Scan Methods in detail. 1.Index Unique scan 2.Index Range Scan 3. Index Skip Scan 4. Fast full Index Scan 5. Full Index Scan If you have any questions just drop in a comment
Views: 5247 Tech Coach
Oracle Hints Tutorial for improving performance
 
10:35
Oracle Hints Tutorial for improving performance APPEND PARALLEL JOIN INDEX NO_INDEX SELECT /*+ FIRST_ROWS(10) */ * FROM emp WHERE deptno = 10; SELECT /*+ ALL_ROWS */ * FROM emp WHERE deptno = 10; SELECT /*+ NO_INDEX(emp emp_dept_idx) */ * FROM emp, dept WHERE emp.deptno = dept.deptno; SELECT /*+ INDEX(e,emp_dept_idx) */ * FROM emp e WHERE e.deptno = 10; -- SELECT /*+ INDEX(scott.emp,emp_dept_idx) */ * FROM scott.emp; SELECT /*+ AND_EQUAL(e,emp_dept_idx) */ * FROM emp e; SELECT /*+ INDEX_JOIN(e,emp_dept_idx) */ * FROM emp e; SELECT /*+ PARALLEL_INDEX(e,emp_dept_idx , 8) */ * FROM emp e; SELECT /*+ LEADING (dept) */ * FROM emp, dept WHERE emp.deptno = dept.deptno; SELECT /*+ PARALLEL(8) CACHE (e) FULL (e) */ * FROM emp e ; SELECT /*+ PARALLEL FULL (e) */ * FROM emp e ; SELECT /*+ PARALLEL USE_MERGE (emp dept) */ * FROM emp, dept WHERE emp.deptno = dept.deptno; -- SORT Merge Join SELECT /*+ PARALLEL USE_HASH (emp dept) */ * FROM emp, dept WHERE emp.deptno = dept.deptno; -- Hash Join SELECT /*+ PARALLEL */ * FROM emp e ; INSERT /*+ APPEND */ INTO mytmp select /*+ CACHE (e) */ *from emp e; commit;
Views: 5003 TechLake
A Story of Indexes and Full Table Scans: Finding All the Red Sweets Part 1
 
08:43
"Why isn't Oracle using my index?!" is a common question people have when tuning SQL queries. In this episode Chris compares two methods for finding all the red candies from party bags he's prepared. He shows how these are like a full table scan and an index range scan. He goes on to compare the performance of these two approaches. He shows when a full table scan becomes more efficient than an index range scan and vice versa. ============================ The Magic of SQL with Chris Saxon Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 7506 The Magic of SQL
07 06 Index Skip Scan Operations
 
03:14
ORACLE
Views: 767 oracle ocm
Oracle SQL Tuning Expert Series - Understanding Indexes
 
01:32:30
Ross Leishman of DWS Ltd presents the principles of Understanding Indexes for SQL Tuning. The presentation includes an entertaining demonstration of Indexes featuring DWS Alumnus Jordan Thomas as a "Buffer Cache". DWS Ltd is a leading publicly listed Australian IT Services company, providing services to blue chip organisations since 1991. With a business philosophy based upon integrity, reliability and professional service delivery, DWS provides end to end IT solutions. www.dws.com.au
Views: 43412 DWS Ltd
Oracle Hints explained
 
42:56
Oracle Hints
Views: 348 Telugu Blast News
SQL: Explain Plan for knowing the Query performance
 
05:17
In this tutorial, you'll learn how to compare queries to know the better performance query..
Views: 93025 radhikaravikumar
TIPS AND TRICK About ORACLE Kill streak
 
03:00
Hey guys heres a video on some tips and tricks about the oracle. Enjoy.
Views: 79 Blurrr_
sub partitioning in oracle  or composite partitioning in Oracle RANGE-LIST, RANGE-HASH
 
07:24
sub partitioning in oracle or composite partitioning 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: 442 TechLake
Reverse Key Index :Types of Btree Index in Oracle
 
15:44
Please subscribe to my new channel. https://www.youtube.com/c/AnIndianAbroadd The Videos explains how Reverse Btree Index works and in what condition they shall be used. Reverse Btree index are used to solve index block contention. You can't perform range scans in reverse btree Index.
Views: 1557 Tech Coach
Why Isn't My Query Using an Index?
 
47:01
“Why isn’t my query using an index?” is a common question people have when tuning SQL. This session explores the factors that influence the optimizer’s decision to answer this question. It does so by comparing fetching rows from a database table to finding all the red M&Ms a packet, and contrasts using an index range scan and a full table scan. It also introduces the concepts of blocks and the clustering factor. The session offers a discussion of how these affect the optimizer's calculations, and includes a demo of how these concepts work in practice using real SQL queries. This session is intended for developers who want to learn the basics of how the optimizer chooses between an index range or full table scan. Speaker: Chris Saxon
Views: 263 Oracle Developers
When to use Oracle Database Bitmap Indexes Lesson 1
 
00:49
This tutorial will identify some use cases for Oracle bitmap indexes, including some of the more advanced capabilities. See all lessons, free, at http://www.skillbuilders.com/when-to-use-oracle-bitmap-indexes. Indexing your Oracle Database for best performance? There are cases, depending on data structures and queries, where b-tree indexes are not useful (e.g. scan access paths perform inadequately). In these cases, bitmap indexes may be a better solution. Bitmap indexes are a powerful tool, but they need to be used with care. Inappropriate use may cause problems worse than those they solve. The tutorial covers somewhat more advanced cases such as using bitmap join indexes to denormalize a snowflake schema, and to enable star transformations in queries that join fact tables to several dimension tables. This training will benefit any Oracle DBA administering a Data Warehouse or VLDB and "power" developers working in same. Instructor: Oracle Certified Master DBA John Watson, SkillBuilders
Views: 482 SkillBuilders
Partitioning in Oracle - Performance Basics
 
28:35
This is the 2nd video from " Partitioning in Oracle " series, It explains how oracle stores and manages data. What is single Block IO and Multi Block IO ? Why full table scan is better than index access in few cases. The video is very elaborate, I have tried my level best to keep it as simple as possible
Views: 7555 Tech Coach
Indexing in Oracle :B-Tree,Bitmap Indexing
 
25:48
This Video is the 1st tutorial in the video series Indexing in Oracle , The video series explains in detail, What are indexes?It's types, what index should be used in which scenario and other important thing in basic terminology. Note :You may want to watch the video with a higher playback speed(1.25 if it suits you more)
Views: 10409 Tech Coach
SQL: Optimizer Hints Part-2
 
05:06
In this tutorial, you'll learn...what are optimizer hints and how to use it.. SQL (pronounced "ess-que-el") stands for Structured Query Language. SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems.
Views: 11089 radhikaravikumar
Oracle Indexes - Live Demonstration
 
19:12
When is a Full Table Scan faster than an Index Scan? Watch Ross and Jordan act out an Oracle database reading and caching data via both methods, explaining the costs and benefits in simple and easy to understand terms. The demonstration is part of a talk by Ross Leishman of DWS Ltd on the principles of Understanding Indexes for SQL Tuning. The full lecture is at this link: https://www.youtube.com/watch?v=Z4hKomnGHFA DWS Ltd is a leading publicly listed Australian IT Services company, providing services to blue chip organisations since 1991. With a business philosophy based upon integrity, reliability and professional service delivery, DWS provides end to end IT solutions. www.dws.com.au
Views: 2655 DWS Ltd
Local Vs Global Partitioned Index in Oracle 11g
 
17:30
The Video Explains the difference between Local Partitioned Indexes(Prefixed vs Non Prefixed Indexes). and Global Partitioned Index along with the challenges in maintaining Global partitioned Indexes when the underlying tables partitioned is dropped/truncated/Merged/Moved. Local Partitioned Index Shares the same boundaries as the table and are in the same number as table partitions they are widely used in DSS and DWH systems. While Global Partitioned Index are predominantly used in OLTP systems
Views: 4700 Tech Coach
Hash Partitioning in Oracle
 
16:25
The Video explains Hash partitioning in oracle and how it focuses on equal data distribution. It explains how hash partitioning uses partition joins to improve performance in VLDB by MPP.
Views: 4197 Tech Coach
BITMAP  and  BITMAP JOIN INDEX IN ORACLE explained
 
25:12
The video explains BITMAP and BITMAP JOIN INDEX IN ORACLE and when you should create them on a column. BITMAP INDEXES should be dealt with carefully as they can lead to serious performance issues if the table is updated by multiple processes in parallel. Indexing Basics :https://www.youtube.com/watch?v=0X9bbtwTnuE&t=1095s Star and snowflake Schema :https://www.youtube.com/watch?v=Qq4yhhAk9fc&t=17s
Views: 2500 Tech Coach
Oracle Exadata Smart Scan - Limitations and Best Practices
 
03:21
Smart Scan is a wonderful capability, but you don't always get it. It's impossible for many execution plans, and this is a major restriction. If you think about what a Smart Scan actually does, it delivers individual columns, individual rows back to the instance. Now, a buffer cache can accept only blocks. Therefore, Smart Scan cannot possibly put those columns of rows into the buffer cache. It's simply not formatted appropriately. So, a Smart Scan has to return values directly into the session's PGA or, to put it another way, the only access method that can use Smart Scan is direct read. Well, what access methods can use direct read? There are only two, which are table full scan and index fast full scan. Any other access method, typically index range scan, table access by row ID, cannot use a Smart Scan. The second major issue, there are strict limitations of the type of objects that can be accessed through Smart Scan. It really is only heap tables. You can't use indexes. You can't use clusters. You can't use IOTs. Heap tables only. Perhaps hardest to track down and giving sometimes very erratic results is that Smart Scan can be interrupted by various conditions. You've met all the requirements for Smart Scan, directory and so on, got the right execution plan. The Smart Scan starts and then hits something that causes a problem. Issues that we know cause problems are, for instance, read consistency, also delayed block cleanout, change rows. Any of those issues and a few others mean that the storage tier will have to interrupt its Smart Scan, deliver complete blocks into that buffer cache, let your session then do what is necessary to the block, and only then can the Smart Scan proceed. Now, in order to maximize the use of Smart Scan, there may be quite a lot of work. Very often, you'll have to adjust your index structures. Making them invisible is a nice technique there. There are many, many, many parameters that can influence the likelihood of achieving a Smart Scan, and almost inevitably you're going to be rewriting a lot of hint SQL and putting hints in it to get the correct execution plans that can enable a Smart Scan to occur. This is all because of one fundamental problem; the optimizer is not in any way aware of the Exadata. The optimizer develops an execution plan in exactly the way it would without the Exadata storage. The use of Smart Scan, the awareness of Exadata comes at the next level down. The optimizer develops the plan through a normal pass and then passes it through to the SQL execution engine, and it's the SQL execution engine that determines, on a case-by-case basis, whether to use the Smart Scan. This means that you might develop a plan and execute the statement 50 times. Forty-nine times, you get a Smart Scan. The 50th time, for whatever reason, the SQL execution engine decides not to. This can result in somewhat erratic performance.
Views: 1626 SkillBuilders
Reference partitioning in Oracle 11g
 
09:50
The video explains Reference partitioning and its advantages in Oracle with real project example. It builds on the limitations of reference partitioning in oracle 11g (Interval partitioning) and scenarios where you should implement reference partitioning
Views: 1282 Tech Coach
Oracle Performance Tuning - Loading Data - 03 Using manual parallelism and changing initrans
 
13:50
Connect with me or follow me at https://www.linkedin.com/in/durga0gadiraju https://www.facebook.com/itversity https://github.com/dgadiraju https://www.youtube.com/c/TechnologyMentor https://twitter.com/itversity
Views: 804 itversity
Oracle Tutorial || Online Training || Adv Sql | Index Organized Table Part - 1 by basha
 
33:16
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS ,ADF,INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo......
Oracle ||  Index Organized Tables by siva
 
25:46
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS , ADF, INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo............
Performance tuning tip 1  -  Remove Corelated subquery
 
14:11
Best explanation how to remove correlated sub query.Please watch complete video for more detail.
Views: 739 SqlIsEasy
Clustered vs. Nonclustered Index Structures in SQL Server
 
08:04
Clustered and nonclustered indexes share many of the same internal structures, but they're fundamentally different in nature. Watch Microsoft Certified IT Professional Jon Seigel explain the similarities and differences of clustered and nonclustered indexes, using a real-world example to show how these structures work to improve the performance of SQL queries. Blog post on primary key vs. the clustered index: http://voluntarydba.com/post/2012/10/02/The-Primary-Key-vs-The-Clustered-Index.aspx CREATE INDEX statement reference: http://technet.microsoft.com/en-us/library/ms188783.aspx ALTER INDEX statement reference: http://technet.microsoft.com/en-us/library/ms188388.aspx Index navigation internals by example: http://sqlblog.com/blogs/paul_white/archive/2011/08/09/sql-server-seeks-and-binary-search.aspx Sample index data is from the AdventureWorksLT2008R2 sample database: http://awlt2008dbscript.codeplex.com/releases/view/46169 Visit my channel for more database administration videos: https://www.youtube.com/voluntarydba Subscribe to get notified about my latest videos: https://www.youtube.com/voluntarydba?sub_confirmation=1 Read additional content on my blog: http://voluntarydba.com Follow on Twitter: https://twitter.com/voluntarydba Like on Facebook: https://facebook.com/voluntarydba
Views: 275373 Voluntary DBA
How to understand and use the query optimizer – Couchbase Connect 2016
 
50:50
Every flight has a flight plan. Every query has a query plan. You must have seen its text form, called EXPLAIN PLAN. Query optimizer is responsible for creating this query plan for every query, and it tries to create an optimal plan for every query. In Couchbase, the query optimizer has to choose the most optimal index for the query, decide on the predicates to push down to index scans, create appropriate spans (scan ranges) for each index, understand the sort (ORDER BY) and pagination (OFFSET, LIMIT) requirements, and create the plan accordingly. When you think there is a better plan, you can hint the optimizer with USE INDEX. This talk will teach you how the optimizer selects the indices, index scan methods, and joins. It will teach you the analysis of the optimizer behavior using EXPLAIN plan and how to change the choices optimizer makes. Speaker: Keshav Murthy, Director, Query Development, Couchbase Slideshare: http://www.slideshare.net/Couchbase/how-to-understand-and-use-the-query-optimizer Visit our website for more information: https://www.couchbase.com/
Views: 465 Couchbase
Index Organized Tables
 
09:58
Bases de Datos 2 Index Organized Tables Michelle Cersosimo Fernando Mata
Views: 782 Mich Cersosimo
What is REVERSE INDEX? What does REVERSE INDEX mean? REVERSE INDEX meaning & explanation
 
04:05
What is REVERSE INDEX? What does REVERSE INDEX mean? REVERSE INDEX meaning - REVERSE INDEX definition - REVERSE INDEX explanation. Source: Wikipedia.org article, adapted under https://creativecommons.org/licenses/by-sa/3.0/ license. SUBSCRIBE to our Google Earth flights channel - https://www.youtube.com/channel/UC6UuCPh7GrXznZi0Hz2YQnQ Database management systems provide multiple types of indexes to improve performance and data integrity across diverse applications. Index types include b-trees, bitmaps, and r-trees. In database management systems, a reverse key index strategy reverses the key value before entering it in the index. E.g., the value 24538 becomes 83542 in the index. Reversing the key value is particularly useful for indexing data such as sequence numbers, where each new key value is greater than the prior value, i.e., values monotonically increase. Reverse key indexes have become particularly important in high volume transaction processing systems because they reduce contention for index blocks. Reversed key indexes use b-tree structures, but preprocess key values before inserting them. Simplifying, b-trees place similar values on a single index block, e.g., storing 24538 on the same block as 24539. This makes them efficient both for looking up a specific value and for finding values within a range. However if the application inserts values in sequence, each insert must have access to the newest block in the index in order to add the new value. If many users attempt to insert at the same time, they all must write to that block and have to get in line, slowing down the application. This is particularly a problem in clustered databases, which may require the block to be copied from one computer's memory to another's to allow the next user to perform their insert. Reversing the key spreads similar new values across the entire index instead of concentrating them in any one leaf block. This means that 24538 appears on the same block as 14538 while 24539 goes to a different block, eliminating this cause of contention. (Since 14538 would have been created long before 24538, their inserts don't interfere with each other.) Reverse indexes are just as efficient as unreversed indexes for finding specific values, although they aren't helpful for range queries. Range queries are uncommon for artificial values such as sequence numbers. When searching the index, the query processor simply reverses the search target before looking it up. Typically, applications delete data that is older on average before deleting newer data. Thus, data with lower sequence numbers generally go before those with higher values. As time passes, in standard b-trees, index blocks for lower values end up containing few values, with a commensurate increase in unused space, referred to as "rot". Rot not only wastes space, but slows query speeds, because a smaller fraction of a rotten index's blocks fit in memory at any one time. In a b-tree, if 14538 gets deleted, its index space remains empty. In a reverse index, if 14538 goes before 24538 arrives, 24538 can reuse 14538's space.
Views: 650 The Audiopedia
SQL: Types of Indexing
 
05:23
In this tutorial, you'll learn how to make use of different indexes...
Views: 31603 radhikaravikumar
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.
Sql server query plan cache
 
14:20
Text version of the video http://csharp-video-tutorials.blogspot.com/2017/04/sql-server-query-plan-cache.html Slides http://csharp-video-tutorials.blogspot.com/2017/04/sql-server-query-plan-cache_12.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All SQL Server Tutorial Videos https://www.youtube.com/playlist?list=PL08903FB7ACA1C2FB All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists In this video we will discuss 1. What happens when a query is issued to SQL Server 2. How to check what is in SQL Server plan cache 3. Things to consider to promote query plan reusability What happens when a query is issued to SQL Server In SQl Server, every query requires a query plan before it is executed. When you run a query the first time, the query gets compiled and a query plan is generated. This query plan is then saved in sql server query plan cache. Next time when we run the same query, the cached query plan is reused. This means sql server does not have to create the plan again for that same query. So reusing a query plan can increase the performance. How long the query plan stays in the plan cache depends on how often the plan is reused besides other factors. The more often the plan is reused the longer it stays in the plan cache. How to check what is in SQL Server plan cache SELECT cp.usecounts, cp.cacheobjtype, cp.objtype, st.text, qp.query_plan FROM sys.dm_exec_cached_plans AS cp CROSS APPLY sys.dm_exec_sql_text(plan_handle) AS st CROSS APPLY sys.dm_exec_query_plan(plan_handle) AS qp ORDER BY cp.usecounts DESC As you can see we have sorted the result set by usecounts column in descending order, so we can see the most frequently reused query plans on the top. usecounts - Number of times the plan is reused objtype - Specifies the type of object text - Text of the SQL query query_plan - Query execution plan in XML format To remove all elements from the plan cache use the following command DBCC FREEPROCCACHE In older versions of SQL Server up to SQL Server 6.5 only stored procedure plans are cached. The query plans for Adhoc sql statements or dynamic sql statements are not cached, so they get compiled every time. With SQL Server 7, and later versions the query plans for Adhoc sql statements and dynamic sql statements are also cached. Things to consider to promote query plan reusability For example, when we execute the following query the first time. The query is compiled, a plan is created and put in the cache. Select * From Employees Where FirstName = 'Mark' When we execute the same query again, it looks up the plan cache, and if a plan is available, it reuses the existing plan instead of creating the plan again which can improve the performance of the query. However, one important thing to keep in mind is that, the cache lookup is by a hash value computed from the query text. If the query text changes even slightly, sql server will not be able to reuse the existing plan. For example, even if you include an extra space somewhere in the query or you change the case, the query text hash will not match, and sql server will not be able find the plan in cache and ends up compiling the query again and creating a new plan. Another example : If you want the same query to find an employee whose FirstName is Steve instead of Mark. You would issue the following query Select * From Employees Where FirstName = 'Steve' Even in this case, since the query text has changed the hash will not match, and sql server will not be able find the plan in cache and ends up compiling the query again and creating a new plan. This is why, it is very important to use parameterised queries for sql server to be able to reuse cached query plans. With parameterised queries, sql server will not treat parameter values as part of the query text. So when you change the parameters values, sql server can still reuse the cached query plan. The following query uses parameters. So even if you change parameter values, the same query plan is reused. Declare @FirstName nvarchar(50) Set @FirstName = 'Steve' Execute sp_executesql N'Select * from Employees where [email protected]', N'@FN nvarchar(50)', @FirstName One important thing to keep in mind is that, when you have dynamic sql in a stored procedure, the query plan for the stored procedure does not include the dynamic SQL. The block of dynamic SQL has a query plan of its own. Summary: Never ever concatenate user input values with strings to build dynamic sql statements. Always use parameterised queries which not only promotes cached query plans reuse but also prevent sql injection attacks.
Views: 21945 kudvenkat
Migrating your data warehouse to Google BigQuery: Lessons Learned (Google Cloud Next '17)
 
01:01:52
BigQuery Data Warehousing customers often migrate their DW from another source or grow from a small project. This video will provide details on data migration, scaling up and the best practices for a smooth transition. Missed the conference? Watch all the talks here: https://goo.gl/c1Vs3h Watch more talks about Big Data & Machine Learning here: https://goo.gl/OcqI9k
Views: 8729 Google Cloud Platform
Taryon, My Wayward Son | Critical Role RPG Episode 97
 
04:13:23
Check out our store for official Critical Role merch: https://goo.gl/BhXLst Catch Critical Role live Thursdays at 7PM PT on Alpha and Twitch: Alpha: https://goo.gl/c4ZsBj Twitch: https://goo.gl/D9fsrS Thanks to @CRTranscript and all the #critters for closed captions! Listen to the Critical Role podcast: https://goo.gl/jVwPBr Tary's past catches up with him, as Vox Machina find themselves racing towards the city of Deastok. Watch Critical Role Live Thursdays at 7pm PT at https://www.twitch.tv/geekandsundry and https://www.projectalpha.com Thanks Backblaze! https://bitly.com/BackblazeCriticalRole Thanks to our friends at Wyrmwood Gaming for sponsoring Critical Role! Check out their handcrafted goods at http://www.wyrmwoodgaming.com You can pick up Critical Role merch at http://shop.geekandsundry.com For more RPGs we love, go to http://bit.ly/GS_RPG Music and Sound by Syrinscape. https://store.syrinscape.com/what-is-syrinscape/?critatt Visit us on http://geekandsundry.com Subscribe to Geek and Sundry: http://goo.gl/B62jl Join our community at: http://geekandsundry.com/community Twitter: http://twitter.com/geekandsundry Facebook: http://facebook.com/geekandsundry Instagram: http://instagram.com/geekandsundry Google+: https://plus.google.com/+GeekandSundry/
Views: 639913 Geek & Sundry
Thar Amphala | Critical Role RPG Episode 101
 
03:31:26
Vox Machina journey through the Ziggurat into the Shadowfell, hot on the trail of Delilah Briarwood. Watch Critical Role Live Thursdays at 7pm PT at https://www.twitch.tv/geekandsundry and https://www.projectalpha.com Thanks to our friends at Wyrmwood Gaming for sponsoring Critical Role! Check out their handcrafted goods at http://www.wyrmwoodgaming.com Thanks to @CRTranscript and all the #critters for closed captions! You can pick up Critical Role merch at http://shop.geekandsundry.com For more RPGs we love, go to http://bit.ly/GS_RPG Music and Sound by Syrinscape. https://store.syrinscape.com/what-is-syrinscape/?critatt Visit us on http://geekandsundry.com Subscribe to Geek and Sundry: http://goo.gl/B62jl Join our community at: http://geekandsundry.com/community Twitter: http://twitter.com/geekandsundry Facebook: http://facebook.com/geekandsundry Instagram: http://instagram.com/geekandsundry Google+: https://plus.google.com/+GeekandSundry/
Views: 563754 Geek & Sundry
Grog's One-Shot | Critical Role RPG One-Shot
 
03:57:44
Watch Critical Role Live Thursdays at 7pm PT on Alpha https://projectalpha.com, or Twitch at https://www.twitch.tv/geekandsundry Thanks to Marvel Puzzle Quest for sponsoring this episode of Critical Role! Check out http://bit.ly/MarvelCrit to learn more, and download the game for free on the Apple App Store & Google Play. You can pick up Critical Role merch at http://shop.geekandsundry.com For more RPGs we love, go to http://bit.ly/GS_RPG Music and Sound by Syrinscape. https://store.syrinscape.com/what-is-syrinscape/?critatt Visit us on http://geekandsundry.com Subscribe to Geek and Sundry: http://goo.gl/B62jl Join our community at: http://geekandsundry.com/community Twitter: http://twitter.com/geekandsundry Facebook: http://facebook.com/geekandsundry Instagram: http://instagram.com/geekandsundry Google+: https://plus.google.com/+GeekandSundry/
Views: 779630 Geek & Sundry
Nested Loop Join in SQL Server by Satya Ramesh
 
19:39
In this video, you will learn about basics around Nested Loop join and how Nested Loop Join algorithm works. You will also learn about different scenarios where SQL Server decides to use Nested Loop Join operator and how it affects performance. 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 (Satya Ramesh) -Follow on Twitter: https://twitter.com/satyaramesh230 -Follow on FaceBook at https://www.facebook.com/satyaramesh230 -Follow on LinkedIN: https://www.linkedin.com/in/ramesh-sa... Connect with SQLMaestros: http://sqlmaestros.com/ -http://www.twitter.com/SQLMaestros -https://www.facebook.com/SQLMaestros -Email us: [email protected] Have technical questions? Join the largest SQL group on FB www.facebook.com/groups/theSQLGeeks Our LinkedIn group https://www.linkedin.com/groups/6753546 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 Do you know about Data Platform Summit? http://www.DPS10.com
Views: 347 SQLMaestros
Passed Through Fire | Critical Role RPG Show Episode 69
 
02:58:28
Check out our store for official Critical Role merch: https://goo.gl/BhXLst Catch Critical Role live Thursdays at 7PM PT on Alpha and Twitch: Alpha: https://goo.gl/c4ZsBj Twitch: https://goo.gl/D9fsrS Listen to the Critical Role podcast: https://goo.gl/jVwPBr Vox Machina return to Whitestone in a desperate attempt to save Percy, but there’s far more waiting for them than they bargained for. Don't forget to check out: http://shop.geekandsundry.com/ for Critical Role goodies! Loot Crate's offering a discount for critters! http://bit.ly/Lootcrate_CriticalRole Enter promo code: CRITICALROLE for $3 off their subscription You can pick up Critical Role merch at http://shop.geekandsundry.com For more RPGs we love, go to http://bit.ly/GS_RPG Visit us on http://geekandsundry.com Subscribe to Geek and Sundry: http://goo.gl/B62jl Join our community at: http://geekandsundry.com/community Twitter: http://twitter.com/geekandsundry Facebook: http://facebook.com/geekandsundry Instagram: http://instagram.com/geekandsundry Google+: https://plus.google.com/+GeekandSundry/
Views: 724793 Geek & Sundry
Batman: Arkham Knight Walkthrough - Part 11 - Founders' Island
 
28:51
Batman: Arkham Knight New Game Plus Mode - Mission Walkthrough \ Guide in Full HD (1080p and 60fps) Batman: Arkham Knight New Game Plus Playlist: https://www.youtube.com/playlist?list=PLJms5sWamFOWmrGgkZVyz7_SkBSkF3hb9 =================================== PART 11: Founders' Island Primary Objectives: - Destroy the Arkham Knight's defense grid on Founders' Island to allow the Batwing to scan for the Cloudburst - Return to Oracle’s Clock Tower to review the Batwing scans for the Cloudburst device Objectives: - Head to Panessa Studios to analyze the Arkham Knight's forces - Glide onto the relay drone and examine it to find a way to defeat the drone forces - Destroy the Arkham Knight’s radar network - Lower the barriers protecting the missile launcher - Take out the Arkham Knight's Cobra drones protecting Founders' Island - Take out the long range missile launcher =================================== Game available on: Sony PlayStation 4, Microsoft Xbox One & PC Video recorded on: PC (with all settings maxed out) =================================== Follow BatmanArkhamVideos on: ● YouTube - http://www.youtube.com/BatmanArkhamVideos ● Twitter- http://www.twitter.com/ArkhamVideos ● Facebook - http://www.facebook.com/BatmanArkhamNews For more info and videos, visit http://www.Batman-Arkham.com and http://www.Games-Series.com
Views: 398088 Batman Arkham Videos
The Echo Tree | Critical Role RPG Show Episode 63
 
04:10:15
A fixed version of this episode can be found here: https://geekandsundry.com/critical-role-episode-63-the-echo-tree/ Check out our store for official Critical Role merch: https://goo.gl/BhXLst Catch Critical Role live Thursdays at 7PM PT on Alpha and Twitch: Alpha: https://goo.gl/c4ZsBj Twitch: https://goo.gl/D9fsrS Listen to the Critical Role podcast: https://goo.gl/jVwPBr Vox Machina find the root of the pestilence deep within the Shademirk, and come face to face with the creature who holds the next vestige. Thanks to Loot Crate! Get $3 off at http://bit.ly/Lootcrate_CriticalRole You can pick up a Critical Role poster at http://shop.geekandsundry.com Thanks to @CRTranscript and all the #critters, especially @eponymous_rose for closed captions! For more RPGs we love, go to http://bit.ly/GS_RPG Visit us on http://geekandsundry.com Subscribe to Geek and Sundry: http://goo.gl/B62jl Join our community at: http://geekandsundry.com/community Twitter: http://twitter.com/geekandsundry Facebook: http://facebook.com/geekandsundry Instagram: http://instagram.com/geekandsundry Google+: https://plus.google.com/+GeekandSundry/
Views: 880595 Geek & Sundry
Finding Stock Trends to Trade
 
03:05
http://www.markettrendsignal.com/stock-trends Stock trends are presented by a technical analysis of a stock's price activity. Stock trends are classified into three categories, up trend, down trend and no trend. A stock is trending up when the price action is progressing higher with a series of higher highs and higher lows.
Views: 6242 Market Trend Signal
Spinosaurus fishes for prey | Planet Dinosaur | BBC
 
04:04
New David Attenborough series Dynasties coming soon! Watch the first trailer here: https://www.youtube.com/watch?v=JWI1eCbksdE --~-- Check out BBC Earth on BBC online - http://www.bbc.com/earth/world John Hurts tells the stories of the biggest, deadliest and weirdest Dinosaurs ever to walk the Earth. Massive carnivorous hunter Spinosaurus hunts the giant fresh water fish Onchopristis. Planet Dinosaur tells the stories of the biggest, deadliest and weirdest creatures ever to walk the Earth, using the latest fossil evidence and immersive computer graphics. Narrated by John Hurt. Visit http://www.bbcearth.com for all the latest animal news and wildlife videos BBC Earth Facebook http://www.facebook.com/bbcearth (ex-UK only) BBC Earth Twitter http://www.twitter.com/bbcearth Subscribe to BBC Earth: http://bit.ly/ydxvrP BBC Earth Channel: http://www.youtube.com/BBCEarth Latest BBC Earth videos: http://bit.ly/y1wtbi
Views: 14200348 BBC Earth
Imagining the Universe: Life on Mars with Tracy K. Smith
 
53:20
With allusions to David Bowie and interplanetary travel, Life on Mars imagines a soundtrack for the universe to accompany the discoveries, failures, and oddities of human existence. In these brilliant new poems, Tracy K. Smith imagines a sci-fi future sucked clean of any real dangers, contemplates the dark matter that keeps people both close and distant, and revisits the kitschy concepts like “love” and “illness” now relegated to the Museum of Obsolescence. These reveal the realities of life lived here, on the ground, where a daughter is imprisoned in the basement by her own father; where celebrities and pop stars walk among us; and where the poet herself loses her father, one of the engineers who worked on the Hubble Telescope. Smith’s Pulitzer Prize-winning poems established her as among the best poets of her generation. http://artsinstitute.stanford.edu/programs/imagining-the-universe/
Views: 5231 Stanford
Exploring Various Network Scanning Techniques
 
10:45
Lab 5 module 3 Exploring Various Network Scanning Techniques Nmap comes with various inbuilt scripts that can be employed during a scan process in an attemp to find the open ports and services running on the ports. Overview of the Lab TCP connect() to determine if a port is available. Xmas scan sending TCP segment with all flags sent in the packet header. ACK flag scan sending ACK prob packet with random sequence number. UDP scan sending a generic UDP packet to the target. IDLE scan sending spoofed packet to the target. Steps 1. Launch Windows Server 2012 virtual machine 2. log in into kali linux virtual machine 3. Launch a command-line-terminal 4. Type the command: nmap -sT -T3 -A [ 10.0.2.8 ], to perform TCP scan 5. The scan result includes all the open ports, operating system figherprint result, nbstat result, smb-os-discovery results, smb version .... 6. Xmas scan sends a TCP frame to remote a device with PSH, URG, and FIN flags set 7. Switch to Windows Server 2012 and enable windows firewall 8. Switch to the kali linux virtual machine and launch a command-line-terminal 9. Type: nmap -sX -T4 [IP address of windows server 2012] 10. The scan result includes all open/filters ports, which means a firewall has been configured on the target machine 11. Switch to Windows Server 2012 and turn-off windows firewall 12. launch a command-line-terminal, type: nmap -sA -v -T4 [IP address of windows server 2012] ACK sacn displays the port disposition 13. Attackers send ACK prob packet : No response means the port is filtered, unfiltered response means the port is closed 14. launch a command-line-terminal, type: nmap -sU -T5 [IP address of windows server 2012] -sU: UDP sacn, -T5: time, this scan displays open and closed ports along with services running on them 15. launch a command-line-terminal, type: nmap -Pn -p 80 -sl [IP address of Zombie machine] [IP address of windows server 2012] we are probing port 80 16. also there other Scanning Techniques, such as Inverse TCP flag scan and Stealth Scanning to find open ports, services running on the ports
Views: 37 Tahani Gr
117-202 – LPI Test Level 2 Exam 202 Questions
 
00:53
For LPI 117-202 Test Questions and Answers Please Visit: https://www.PassEasily.com/117-202.htm Exam Section 1 – Domain Name Server Questions (Test Coverage 17%) Exam Section 2 – Web Services Questions (Test Coverage 18%) Exam Section 3 – File Sharing Questions (Test Coverage 21%) Exam Section 4 - Network Client Management Questions (Test Coverage 12%) Exam Section 5 – E-Mail Services Questions (Test Coverage 21%) Exam Section 6 – System Security Questions (Test Coverage 22%) (Exam Time): 60 minutes (Number of Test Questions): 40 (117-202 Passing Score): 70% This is a required exam for 117-202 LPI certification Level 2. It covers advanced skills for the Linux professional that are common across all distributions of Linux test. Each test questions is assigned a weighting value. The weights range roughly from 1 to 10 and indicate the relative importance of each objective. Objectives with higher weights will be covered in the exam with more questions. Exam candidates should be able to create a zone file for a forward or reverse zone and hints for root level servers. This test objective includes setting appropriate values for records questions, adding hosts in zones and adding zones to the DNS questions. A test candidate should also be able to delegate zones to another DNS exam server. Test candidates should be able to install and configure a web server exam. This test objective includes monitoring the server's load and performance questions, restricting client user access questions, configuring support for scripting languages as modules and setting up client user authentication questions. Also included is configuring server options to restrict usage of resources questions. Test candidates should be able to configure a web server to use virtual hosts and customise file access. Exam candidates should be able to configure a basic OpenLDAP server including knowledge of LDIF format and essential access control questions. An understanding of the role of SSSD in authentication and identity management is included. You will be tested for: • OpenSSH questions configuration files, tools questions and utilities questions • Login 117-202 restrictions for the superuser and the normal users • Managing 117-202 and using server questions and client keys test to login with and without password • Usage test of multiple connections from multiple hosts to guard against loss of connection to remote host following configuration changes • Tools test and utilities test to scan and test ports on a server • Locations exam and organisations that report security alerts as Bugtraq exam, CERT exam, CIAC exam or other exam sources • Tools and utility questions to implement an intrusion detection system (IDS) • Awareness of OpenVAS test and Snort • Iptables exam configuration files questions, exam tools and utilities questions • Tools questions, commands and utilities to manage routing tables. • Private exam address ranges • Port redirection test and IP exam forwarding • List and write test filtering and rules that accept or block datagrams based on source or destination protocol, port and address • Save exam and reload filtering configurations • Awareness test of ip6tables and filtering • Apache 2.x exam configuration files, terms and utilities • Apache log test files configuration and content • Access restriction methods and files • mod_perl and PHP exam configuration • Client user authentication files test and utilities • Configuration of maximum requests exam, minimum and maximum servers and clients • Apache 2.x virtual host test implementation (with and without dedicated IP addresses) • Using redirect statements in Apache's configuration exam files to customise file access
Views: 448 PassEasilyReloaded
Google I/O 2008 - Underneath the Covers at Google
 
59:47
Underneath the Cov I/ers at Google: Current Systems and Future Directions Jeff Dean (Google) Over the past several years, we have built a collection of systems and tools that simplify the storing and processing of large-scale data sets, and the construction of heavily-used public services based on these data sets. These systems are intended to work well in Google's computational environment, which consists of large numbers of commodity machines connected by commodity networking hardware. Our systems handle issues like storage reliability and availability in the face of machine failures, and our processing tools make it relatively easy to write robust computations that run reliably and efficiently on thousands of machines. In this talk I'll highlight some of the systems we have built, and discuss some challenges and future directions for new systems.
Views: 24800 Google Developers
Computer based design of Islamic geometric patterns
 
01:26:17
About the speaker: Craig S. Kaplan is an Associate Professor in the David R. Cheriton School of Computer Science at the University of Waterloo. Islamic art encompasses one of the world's greatest traditions of decorative geometric patterns. These patterns are well suited for study, construction and visualization using computational techniques. Professor Kaplan will discuss his ongoing research on the structure of Islamic geometric patterns, and algorithms for constructing them automatically. He will also present several novel artistic variations based on techniques that would have been impossible or impractical historically. These variations allow contemporary craftspeople to create innovative new designs that are still recognizably part of an ancient tradition.
Views: 41126 renisonvideo
Pixel Starships - Basic Ship Design Tips
 
09:23
Some basic design rules of thumb and some sweet sweet victories. Hope this helps explain the importance of armor.
Views: 36060 Bandersnitch
Quantum Resonance whatever analyze this
 
03:36
Within a minute the software generates a huge complete health report. You can have a stock of vitamins and health supplements piled up, and this oracle like machine tells what your clients need. May be good for business, but is it ethical? Until this video came, there was no review or critical test of the Quantum Resonance Magnetic Analyzer. Produced in the far east, praised as a quantum based wonder analyzer, it is seen more frequently over the net for sale as a diagnostic tool for homers, or even for serious practitioners to advice clients. It may easily get those vitamins sold off the shelf. Is it a scam? Is it a toy? Do practitioners play with clients? I like to tear things like this down to bits - no mercy. What is your opinion about this? I decided to take the chance to see if this concept was for real. Knowing that it might be money lost. I imported two different QRMA late 2012 from the most renown QRMA selling companies I could find in China. Two great looking touch pc systems with the analyser build in from Schenzen Huge Creation Technology Company at healthcare-ems.com. The other (the black box type) from Yikang at quantumanalyzer.net. They have many notes on their site warning about fake analyzers and claim they are the manufactures, and they display cerfitifications, so maybe they know what they are doing. I took the analyzers through some systematic testing. I quickly found that I could use a wet paper cloth or a resistor instead of a human hand. I took them to bits and pieces like I have always done with things like that, since I can remember. I find it hard to believe that there are any QRMA's out there that actually is for real, but please come up with some hard facts against mine to tell me if the whole concept is not fake or a scam, I could be wrong. I feel I need to inform about this. I am quite shocked to see so many people are eating it raw... Why are so many companies selling this far out quiz machine along with medical certified equipment? Could it just be plain business and materialism has finally come to the far east. Would you buy it after watching this demonstration? Would you trust in its generic reports? Is it a harmless toy when practitioners are using it on their clients? This demonstration was brought to you by Jørgen A. Jacobsen. You may visit http://shop.7d.dk - Here you find useful and well documented and tested health gadgets. I did not find machines like QRMA good enough for the shop. The origin of the analyzer and maybe patents: http://google.it/patents/US5592086 Report on utilizing the QRMA in clinical studies: http://koreamed.org/SearchBasic.php?RID=2047KJP%2F1993.6.2.192&DT=1 Memories of Masaru Emoto how the QRMA promoted his research and discoveries of the memory of water http://books.google.sk/books?id=sVcIwvKnFcQC&pg=PR8&lpg=PR8&dq=masaru+emoto+weinstock+Bio+Cellular+Analyzer&source=bl&ots=Om3ZKijy88&sig=ANu04bSjAJqrzc4yUGc5PbqBTvw&hl=en&sa=X&ei=llrDUvXcOYjZsgarv4BI&redir_esc=y#v=onepage&q=masaru%20emoto%20weinstock%20Bio%20Cellular%20Analyzer&f=false
Views: 100593 Jørgen A. Jacobsen

Free printable cover letter samples
Accenture internship cover letter
Read sample cover letters for resume
Resume cover letter example australian
Graphic design cover letter examples aiga chicago