Search results “Oracle drop column unused”
061-Oracle SQL 12c: Set unused option -read only- drop table
تعلم اوراكل حتى الاحتراف تعلم اوراكل من الصفر
Views: 1182 khaled alkhudari
6-Add Drop Modify Rename Disable Enable truncate  unused column Cascade Update Delete.avi
Columns -- Constraints -- Add Drop Modify Rename Disable Enable truncate -- unused column -- Cascade Update Delete.
Views: 1484 Adel Sabour
Oracle Tutorial - How to add virtual column in oracle 11g
Hello friends in this video i'm going to demonstrate you how to add virtual column in ORACLE 11g step by step. Oracle 11g supports virtual columns which are derived from the other columns in the table. You can use the virtual columns in your queries, you can index them, you can collect the statistics, etc. There are few restrictions on the virtual columns. You cannot write/insert the data into virtual columns. There is no support for index_organized, external, object, cluster, temporary tables.
Views: 1243 OCP Technology
What Impact Do Indexes Have on Inserts?: Finding All the Red Sweets Part 0
Creating indexes can improve query performance. Oracle must maintain the indexes however. This increases the work it must do whenever you modify data in indexed columns. In this video Chris looks at this overhead using a real world analogy - recording the color of all the candies stored in party bags! ============================ 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: 2414 The Magic of SQL
56. ALTER TABLE to ADD and DROP integrity constraints in PL/SQL Oracle
In this video you will learn about ALTER TABLE to ADD and DROP integrity constraints in PL/SQL Oracle. For Support =========== Email: [email protected] Contact Form: http://www.learninhindi.com/home/contact Our Social Media ================ Facebook: https://www.facebook.com/LearnInHindi Twitter: https://twitter.com/LearnInHindi For Training & Videos ===================== For more videos and articles visit: http://www.learninhindi.com Free Java Programming In Hindi Course ===================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAwwhMyoLISrxkXTADGp7PH Free Oracle PL/SQL Programming In Hindi Course ============================================== https://www.youtube.com/playlist?list=PLB5DA82419C2D99B6 Free C Programming In Hindi Course ================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAxKpBLMWogxSdy6BZcsAJq Trips & Tricks Channel ====================== https://www.youtube.com/channel/UCGmLfkuCo-3lHHJXRJ9HUMw Programming in Hindi Channel ============================ https://www.youtube.com/channel/UCudElIDgwNrybeAvXIy1HZQ
Views: 2910 ITORIAN
TSQL: Find Unused Tables
I applaud the author of the article for looking at this, as it's challenging. I would be very careful though before making some of the assumptions; we want to be sure that something is unused, and we should always have discussions with application developers to make sure we don't disrupt what they're doing.
Views: 53 SQLInSix Minutes
On Delete Cascade - SQLServer
http://xtutorialsplus.blogspot.com/ Se muestra con un ejemplo el uso de On Delete Cascade en SQL Server 2008.
Views: 14252 Aneudy Abreu
Altering an INT Column to a BIGINT (Dear SQL DBA Episode 11)
You need to change an INT column to a BIGINT in a large table. Learn why this schema change can make your transaction log explode, and how to avoid it. For a transcript of this video with clickable links, go to: http://www.littlekendra.com/2016/08/04/altering-an-int-column-to-a-bigint-dear-sql-dba-episode-11/ To subscribe to the podcast, go to http://www.littlekendra.com/dearsqldba/
Views: 1032 SQL Workbooks
TSQL: How To Find Unused Stored Procedures
GitHub location: https://github.com/tmmtsmith/SQLServer/blob/master/Admin%20Tools/Cleaning/procmaintenance.sql
Views: 515 SQLInSix Minutes
SDU Tools 61 Translate SQL Server T-SQL strings to avoid nested REPLACE operations
SDU Tools are free tools for SQL Server developers and DBAs. This tool avoids the need for a nested REPLACE statements in T-SQL by allowing a whole set of replacements to be specified in a single statement. SQL Server 2017 includes a new TRANSLATE built-in function but this tool provides the same functionality for earlier versions of SQL Server. You'll find more info about SDU Tools and download details at http://www.sqldownunder.com/Resources/SDUTools
Views: 37 SQL Down Under
Remove Unwanted Characters in Excel
Check out my Blog: http://exceltraining101.blogspot.com This brief video show some example of how to remove unwanted characters or spaces. It gives an overview of the what symbols are in Excel and what to look out for when deleting "spaces". P.S. Feel free to provide a comment or share it with a friend! ----------------------------------
Views: 150510 Doug H
How to drop primary key clustered index using query window
When dropping a primary key clustered index using query window you will get msg 3723 - An explicit DROP INDEX is not allowed on index 'Table.PK__Table__3214EC079D3D6FE5'. - It is being used for PRIMARY KEY constraint enforcement. for more about it: www.mybook-lang.com
Views: 164 Devendra Gohel
08 09 Demo   Invisible Indexes
Views: 123 oracle ocm
Check Last Modified DateTime for An Object (Table,Stored Procedure,Trigger etc.) in SQL Server
We as SQL Server developers send our DDL Scripts ( Add New Column, Drop some column from table, or Alter Stored Procedure) to DBA. After deployment we verify those changes and sometime it happens that the changes are not done. Maybe DBA has missed one of the script to run. If we can get the last modified date for object ( Table,Stored Procedure, View etc) that can confirm the changes are done on given date. blog post link for scripts used in this video http://sqlage.blogspot.com/2014/01/tsql-how-to-check-when-object-table.html
Views: 6103 TechBrothersIT
How to hide all unused cells in all columns and all rows in Excel spreadsheets
A demonstration on how to hide unused cells in all columns and rows in Excel 2013, 2010 and 2007. Also visit our blog at my-excel-tutorials.blogspot.com BEST VIEWED IN FULL SCREEN, HIGH RESOLUTION
Views: 143692 United Computers
How to use Compile Time Warnings to Find Dead PL/SQL Code by Steven Feuerstein
Watch all free Oracle tutorials at http://www.skillbuilders.com/oracle-tutorials. In this tutorial, Oracle ACE Director Steven Feuerstein demonstrates how to use Oracle PL/SQL Compiler to locate - and remove - PL/SQL code that is never executed (i.e. dead code). Steven also demonstrates the "format error backtrace" function to report the precise line number that an error occurred. Finally, Steven demonstrates improving PL/SQL performance with pipelined table functions.
Views: 516 SkillBuilders
How to Add Multiple Columns to a SQL Server Table in Single Statement- TSQL Tutorial
Sometime we have to add multiple columns to the already existing table. Instead of adding one column at a time we can add multiple columns in one SQL statement. blog post link for scripts used in this video http://sqlage.blogspot.com/2013/12/tsql-alter-table-add-multiple-columns.html
Views: 6296 TechBrothersIT
7- Oracle Database insert - update - delete - intro select - -char functions.avi
7-Oracle Database - SQL - insert - update - delete - intro select - working with dates and default value - to_date and to_char functions.avi
Views: 2684 Adel Sabour
DB2 Tips n Tricks Part 87 - How To Map Table File Object Id with Table Name in SMS Table Space
How To Map Table File Object Id with Table Name in SMS Table Space Use: TABLEID Column in SYSCAT.TABLES TAB_FILE_ID Column in MON_GET_TABLE Function TAB_FILE_ID Column in SYSIBMADM.ADMINTEMPTABLES View db2pd -db dbname -tcbstats tbspid Happy Learning & Sharing
Views: 618 DB2-LUW-ACADEMY
Oracle CURRENT_DATE Function
https://www.databasestar.com/oracle-date-functions/ The Oracle CURRENT_DATE function is used to return the current date in the session timezone. The session timezone is the timezone that the current user is logging in from. This can be different from the database’s timezone. The syntax of the CURRENT_DATE function is: CURRENT_DATE No parameters are needed - just the function name. The function returns a DATE data type, and it includes hours, minutes, and seconds. This is good to know because the default display format for DATE does not include the time component, and it can be easy to forget. It’s different to the SYSDATE function as SYSDATE returns the date in the database timezone, and CURRENT_DATE returns the date in the session time zone. So, if I’m logging in from Melbourne, Australia, and the database is in London, England, then the CURRENT_DATE will return a date and time that’s 10 hours ahead of SYSDATE. It may be on the same day, or it could be a different day, depending on when I run the function. You can perform arithmetic on this function just like any other date value (e.g. CURRENT_DATE - 7 for 7 days ago). For more information about the Oracle CURRENT_DATE function, including all of the SQL shown in this video and the examples, read the related article here: https://www.databasestar.com/oracle-date-functions/
Views: 57 Database Star
SQL Null or Empty   How to Check for Null or Empty Column in SQL Server   SQL Training Online
http://www.sqltrainingonline.com SQL Null or Empty - How to Check for Null or Empty Column in SQL Server - SQL Training Online You can download the sample table script at http://www.sqltrainingonline.com/how-to-filter-for-sql-null-or-empty-string/. In this video, I show you how to filter for a SQL null or empty string. It can be difficult to filter a null because you can't simply compare with an equal sign. You have to use a special IS NULL clause to make the filter work. I also show you how to combine both the SQL Null and Empty String together in a special trick with the isnull SQL Server function. I use SQL Server 2012 to demonstrate the technique. Let me know what you think by commenting or sharing on twitter, facebook, google+, etc. If you enjoy the video, please give it a like, comment, or subscribe to my channel. You can visit me at any of the following: SQL Training Online: http://www.sqltrainingonline.com Twitter: http://www.twitter.com/sql_by_joey Google+: https://plus.google.com/#100925239624117719658/posts LinkedIn: http://www.linkedin.com/in/joeyblue Facebook: http://www.facebook.com/sqltrainingonline
Views: 14448 Joey Blue
SQL Cascade Delete Details
Views: 1885 Mike Perel
DB2 Tips n Tricks Part 12 - How to Rebind a specific Routine(UDF,Trigger,Sto.Proc)
How to Rebind a specific Routine(UDF,Trigger,Sto.Proc). Method 1: call SYSPROC.REBIND_ROUTINE_PACKAGE() for REBINDING PACKAGE Method 2: call SYSPROC.ALTER_ROUTINE_PACKAGE() for ALTERING PACKAGE Happy Learning & Enjoy
Views: 1762 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 38 - Limitation on Monitor Metrics by Dynamic SQL Snapshot
How Dynamic SQL Snapshot is Technically Correct but Functionally Incorrect Solution: Dynamic SQL Snapshot aggregates monitor metrics based on Statement Text. Use MON_GET_PKG_CACHE_STMT aggregates monitor metrics based on Execution Id. Happy Learning & Sharing
Views: 1516 DB2-LUW-ACADEMY
SQL Server Temp Tables - TSQL Command Line  with  IF EXISTS and  DROP TABLE
Discussion of Temp Tables and persistence and why IF EXISTS and DROP TABLE are not necessary. Temp Tables are created in the tempdb system database in SQL Server. They are persistent but not necessarily long lived. Temp tables hav many similarities to true tables, however they also have special properties that allow more flexibility respecting scope.
Views: 1782 Dave Merton
Manage Schema Objects
Views: 196 sd4it
On cascade
On cascade http://istao.ma/showthread.php?t=181
Views: 176 Jelti Yassir
10 Oracle Database   Like   Order by Alias   Operators Precedence
Oracle Database - Like - Order by Alias - Operators Precedence
Views: 1120 Adel Sabour
Which is Worse: an Unused Index, or an Un-Indexed Foreign Key? (Dear SQL DBA Episode 16)
Should you always index your foreign keys? What if you index your foreign key, and then the index never gets used? Get clickable links and a readable version of the discussion here: http://www.littlekendra.com/?p=5496&preview=true Subscribe to the podcast at http://www.littlekendra.com/dearsqldba/
Views: 1463 SQL Workbooks
[오라클 기초 강좌] 14 - 테이블 관리 및 활용 - 테이블 생성/변경/제거, 칼럼 제거, Row Chain, Row Migration, PCTFREE, PCTUSED
칼럼 제거 - 칼럼 제거 시 SET UNUSED COLUMN은 해당 칼럼의 데이터를 물리적으로 삭제하는 것이 아니라 사용하지 않는 칼럼으로 Marking 하는 것이다. DROP UNUSED COLUMNS는 UNUSED로 Marking 된 모든 칼럼들을 DROP 한다. Row Chain & Row Migration - Row Chaining이란 Data Block 하나에 전부 입력할 수 없는 Row가 여러 Block에 걸쳐서 입력되는 것을 말한다. - Row Chain이 발생 하면 Chain이 발생한 Row를 조회 시 하나 이상의 Block에 대해 I/O가 발생하므로 성능을 저하 시키는 요인이 된다. - 이러한 Row Chaining 현상은 해결하기 위해 Row Migration이라는 기법을 이용한다. (일부 저장 용량의 손실을 감수 하더라도...) - Row Migration이란 Block 하나에 전부 입력할 수 없는 Row를 다른 Block으로 옮겨서 입력하는 것을 말한다.
Views: 1434 Yongjin Choi
How To Check If Column Exists for a Table Or View in Database in SQL Server - SQL Server Tutorial
On daily basis, we come across this scenario when we have to find out if a column exists for a Table or View in Database. Specially if we are debugging SQL Server Reports/An application, we take a column name or part of it and want to know that from which table this column is used. We can query INFORMATION_SCHEMA.COLUMNS view to get this information. blog post link for scripts used in this video http://sqlage.blogspot.com/2014/01/tsql-how-to-check-if-column-exists-for.html
Views: 4633 TechBrothersIT
Unique key constraint - Part 9
In this video we will learn 1. What is unique key constraint 2. When do you use unique key constraint over primary key constraint 3. Difference between unique key constraint and primary key constraint Text version of the video http://csharp-video-tutorials.blogspot.com/2012/08/unique-key-constraint-part-9.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-9-unique-key-constraint.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 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
Views: 270204 kudvenkat
086-Oracle SQL 12c: Managing constraints Part 2
تعلم اوراكل حتى الاحتراف تعلم اوراكل من الصفر EXAM 1Z0-061 EXAM 1Z0-071
Views: 784 khaled alkhudari
DB2 Tips n Tricks Part 9 - Obviate a Drop Table Scenario
Prevent Accidental Drop of a Table. Solution : Use "Restrict on Drop" Clause in Create / Alter Table Statement; Pre-emptive Approach with no Performance Overhead. Drop table Recovery is only a contingency plan. Happy Learning & Enjoy
Views: 1527 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 25 - How to Find unused tables,indexes or stored procedures in the Database
How to Find unused tables,indexes or stored procedures in the Database. When it was last accessed? Solution: LASTUSED Column in SYSCAT.TABLES,SYSCAT.INDEXES,SYSCAT.PACKAGES Happy Learning & Sharing
Views: 3551 DB2-LUW-ACADEMY
DB2 Tips n Tricks - Part 3 - SET INTEGRITY for Re-Generation of Generated Columns
DB2 Tips n Tricks Video Part 3 uploaded. No Need to Drop and Re-create Generated Columns for altering them. Use SET INTEGRITY for RE-GENERATION OF GENERATED COLUMNS as explained with online example.....
Views: 2865 DB2-LUW-ACADEMY
SQL Server 33 - Indexes
Indexes allow us to tell the database that certain columns are columns we want to retrieve commonly. This allows the database to optimize retrieval. Additionally, when we get into the SELECT statement, we will often have to join data from multiple tables. When we correctly add indexes to our tables, we can improve the speed of our SELECT and also our joins. There are two types of Index. One is called clustered and the other is called non-clustered. Clustered indexes determine the actual order of the table. By default this is going to be the primary key column. So when you label a column as PRIMARY KEY, you are also going to be creating an INDEX that is a clustered index. A clustered index is kind of like a telephone book, where the data is right there when you look up a phone number. This means that if you are just making a small database that is only going to store a few things, you may be fine. But more likely than not you are going to want to add additional indexes. When you add a new index, you create a non-clustered index. These things do not actually determine the order of the rows in the table. A way of how you can think of how these work is like an index in the back of a book. The index of the book does not actually contain the data, it just tells you where to find it. What columns do you index? You are going to want every primary key to be indexed. What about foreign keys, are they indexed by default? No, they are not. Of all columns, you are probably going to want to index the foreign keys the most because they are used in joins. Lastly, you will likely want to index columns that you are going to use on a regular basis. You can also make composite indexes just like you can make composite keys. You would want to do this when you are going to constantly being using those columns together. There is a lot to learn on multicolumn indexes. We may explore this concept in more detail and see how SQL Server uses them in a future video, but as of right now it's probably more important that we get a general understanding of all things SQL Server before we deep dive on something like that. In the upcoming videos I'll be teaching you how to create indexes. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Support me! http://www.patreon.com/calebcurry Subscribe to my newsletter: http://eepurl.com/-8qtH Donate!: http://bit.ly/DonateCTVM2. ~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~ More content: http://CalebCurry.com Facebook: http://www.facebook.com/CalebTheVideoMaker Google+: https://plus.google.com/+CalebTheVideoMaker2 Twitter: http://twitter.com/calebCurry Amazing Web Hosting - https://www.dreamhost.com/r.cgi?1487063 (The best web hosting for a cheap price!)
Views: 5886 Caleb Curry
Excluindo tabela no oracle
Esse vídeo ensina como excluir uma tabela no oracle.
Views: 163 welton Silva
DB2 Tips n Tricks Part 21 - How to Override Current Committed Semantics for a specific select query
How to Override Current Committed Semantics for a specific select query Override Registry Variables:DB2_SKIPINSERTED, DB2_SKIPDELETED, DB2_EVALUNCOMMITTED Solution: WAIT FOR OUTCOME Clause Happy Learning & Sharing
Views: 1121 DB2-LUW-ACADEMY
Considerations for a DB2 Environment
Moving on to slide number 7 so here is a list of considerations for a DB2 environment. So before you actually go head and try to install DB2 on system and get started with setting up an environment. Please take a look at some of these which are very very crucial for functioning from a functional perspective. The first thing that you need to remember is whether to choose physical system or a virtual system. So when we say physical or virtual what it mean is, is a system going to be (( )) or a VM image which is a virtualized or can be focused on physical system.
Views: 33 TechGig
DB2 Tips n Tricks Part 22 - How to Exclusively lock set of Rows using select query
How to Exclusively lock a set of Rows using select query Solution: LOCK REQUEST Clause USE and KEEP SHARE/UPDATE/EXCLUSIVE Locks Happy Learning & Sharing
Views: 1822 DB2-LUW-ACADEMY
Clustered index on View SQL Server
How to clustered index on view in SQL Server, SQL Server Tutorial, SQL Server for beginner, how to give index on view SQL Server
Views: 85 Nur Jalih
Java JDBC Tutorial - Part 1: Connect to MySQL database with Java
5 FREE JAVA VIDEO COURSES - CLICK HERE - https://goo.gl/7i95F8 --- View more videos on my "Java JDBC Tutorial" Playlist: http://goo.gl/crT4nS Closed-Captioning and English subtitles available. In this tutorial, you will learn how to connect to a MySQL database with Java. Download source code from - http://www.luv2code.com/2014/03/21/connect-to-mysql-database-with-java-jdbc/ Please subscribe to my channel. http://goo.gl/EV6Kwv ---- Follow luv2code: Website: http://www.luv2code.com YouTube: http://goo.gl/EV6Kwv Twitter: http://goo.gl/ALMzLG Facebook: http://goo.gl/8pDRdA --- Join my mailing list: Get advance notice on new tutorials. Emails about 1 per week. - http://www.luv2code.com/joinlist --- Questions or problems? Post them in the comments section below. --- Want to suggest a video? Leave a comment below. I'm always looking for new video ideas. Let me know what video you'd like for me to create. --- Video Transcript Time - 00:00 Hello. In this tutorial, you will learn how to connect to a MySQL database with Java. In this session we’re going to learn how to connect a MySQL database with Java. Before we get started there are some prep work that needs to take place. One is that you need to have a MySQL database already installed. If not, you can download one from the site listed here on the slide. Time - 00:20 Next, we’ll need to download and install a MySQL JDBC driver. This driver will allow the Java program to connect to the database. You can download it from this URL, and I’ll do that now. I’ll just take this URL, drop it into my favorite browser and here I am at the page. I’m on this page, this is for downloading the Connector/J browser. I’ll select the platform, platform independent. Now move down and I’ll select download and it will download a zip archive. Make sure you download the most recent version. In this case it’s 5.1.29. Make sure you download something at that version or later. Time - 01:04 Download, scroll down, select, “No thanks, just start my download.” This will start downloading the file for you. Now what we can do is show it in the finder. I’ll double click it to extract it. At this point I have the driver extracted. There’s a file in here called MySQL connector.jar that we’ll use later. Time - 01:34 Next, what I need to do is create a Java project in Eclipse. Let’s do that. On Eclipse I’ll say I’ll save file, new, Java project. This will be JDBC demo and I will select finish. What I’ll do is I will add a new class. New, class, this will be my driver and it will have a public static void main region. At this point we have a shell for our project created. Time - 02:28 Next, what we’ll do is we will talk to the actual development process and I really like this slide because it outlines exactly what we need to do. The first thing we’ll do is add the database driver to the classpath. Next, we’ll get a connection, we’ll submit a SQL query and then we’ll process the result set. Time - 02:48 Let’s start with step one, adding a MySQL database driver to the classpath. In our Eclipse project I’m going to add a new folder called lib, lib for library. In this lib folder I’m going to add the driver that I downloaded earlier. What I’ll do is I’ll just grab this driver. It’s the MySQL connector bin.jar and I’ll just drag and drop it to this lib folder. It will prompt me and I’ll say go ahead and copy the file. Time - 03:25 Next, I need to add the jar file, the driver to the classpath. I’ve set this up with properties, choose Java build path and then I’ll choose add jars. Expand this folder, that lib, I’ll grab that jar file and I’ll have it setup. Great. Time - 03:51 Now we can start coding. We need to get a connection, submit a SQL query and process a result set. Let me just sketch this out on a slide over here. The first thing I’ll do up top is I’ll just do an import on java.sql.* because all of the classes and interfaces that we need are in this package. Time - 04:17 I’ll also just setup a try catch block just to handle for any exception that may occur. Small typo there. Time - 04:40 Inside of this section I’m going to first get a connection to database. Then next I will create a statement. Then from here I will execute a SQL query and then I will process the result set. Time - 05:16 That’s my basic game plan, let’s fill it in with some real code. Here I’ll say connection, myConn = DriverManager.getConnection. I’ll give the jdbc:mysql://localhost:3306/demo student, student. Student is the user ID and student is also the password. [snip] Click the Transcripts tab for full transcript.
Views: 595131 luv2code
The Mines of the Many  | Critical Role RPG Episode 98
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 To save the Darrington family, Vox Machina descend deep into an abandoned mine. Thanks to @CRTranscript and all the #critters for closed captions! 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 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: 621040 Geek & Sundry
SDU Tools   41   Capture Load and Analyze SQL Server Query Performance Tuning Traces
SDU Tools are free tools for SQL Server developers and DBAs. This video describes three tools that can be used to help find queries that need tuning on a SQL Server system. The first tool captures a performance trace for a period of time, the next tool loads that into a table, and the third tool analyzes the data that has been loaded. You'll find more info about SDU Tools and download details at http://www.sqldownunder.com/Resources/SDUTools
Views: 113 SQL Down Under