Home
Search results “Oracle partitioned table size”
SQL Server Tutorial 23: Partitioning Tables and Indexes
 
07:05
How to partition a table and an index using SSMS, or T-SQL. For more info, or a copy of the scripts used in this tutorial, please email me at [email protected]
Views: 22558 Johnny Deluca
How to use partitioning to improve performance of large tables
 
42:49
In this video we cover in much more detail the improvement in performance that can be achieved by using partitioning. MS SQL server databases can scale well using this feature. We cover how partitioning a table gives similar performance as a single table with a clustered index, we then explore how adding NC index improve performance of the heap table as well as the partitioned table.
Views: 20369 Jayanth Kurup
Table Shrinking in Oracle Database
 
14:15
1.Shrink the Table: Shrinking is started from 10g. In this method I’m using user u1 and table name sm1. Now I’m deleting some rows in sm1 COUNT ---------- 1048576 Table sm1 has 1048576 rows. [email protected]: delete from sm1 where deptno=10; 262144 rows deleted. I deleted above number of rows. Rows COUNT ---------- 786432 And I’m giving commit [email protected]: commit; Commit complete. So now we have 786432 rows in sm1 table. Now see the following command [email protected]: select OWNER,TABLESPACE_NAME,SEGMENT_NAME,SEGMENT_TYPE,BYTES/1024/1024||' mb'"space",BLOCKS,EXTENTS from dba_segments where tablespace_name like 'U%TS'; OWNER TABLESPACE_NAME SEGMENT_NAME SEGMENT_TYPE space BLOCKS EXTENTS ----- --------------- ------------- ------------- ------ ---------- ---------- U1 U1TS SM1 TABLE 29 mb 3712 44 After I deleted some rows in sm1 table still above result showing same values, so now our duty is shrink this table. This is done by following 2 ways, i By using COMPACT key word: In this method shrinking is done in two phases. In the first phase all fragmented space are just defragmented, but still the High Water Mark is persist with last used block only. That mean used free blocks are not de allocated and HWM is not updated here. Issue the following command before use shrink command. [email protected] alter table sm1 enable row movement; Table altered. There is particular use with above command, when we shrink the table all rows are moves to contiguous blocks, so here row movement should be done. By default the row movement is disabled for any table, so above command enabled the row movement. Then execute shrink command now. [email protected]: alter table sm1 shrink space compact; Table altered. Now see the space of table by using below command. [email protected]: select OWNER,TABLESPACE_NAME,SEGMENT_NAME,SEGMENT_TYPE,BYTES/1024/1024||' mb'"space",BLOCKS,EXTENTS from dba_segments where tablespace_name like 'U%TS'; OWNER TABLESPACE_NAME SEGMENT_NAME SEGMENT_TYPE space BLOCKS EXTENTS ----- --------------- ------------- ------------- ------ ---------- ---------- U1 U1TS SM1 TABLE 29 mb 3712 44 So here seems nothing happened with above shrink command, but internally the fragmented space is defragmented. But the high water mark is not updated, used free blocks are also not de allocated. For de allocating the used blocks we have to execute below command. This is the second phase. [email protected]: alter table sm1 shrink space; Table altered. Now see the space by using below command. [email protected]: select OWNER,TABLESPACE_NAME,SEGMENT_NAME,SEGMENT_TYPE,BYTES/1024/1024||' mb'"space",BLOCKS,EXTENTS from dba_segments where tablespace_name like 'U%TS'; OWNER TABLESPACE_NAME SEGMENT_NAME SEGMENT_TYPE space BLOCKS EXTENTS ----- --------------- ------------- ------------- ---------- ---------- ---------- U1 U1TS SM1 TABLE 20.8125 mb 2664 36 So now the space of sm1 table is reduced. Note: Actually the alter table sm1 shrink space command will complete these two phases of the shrinking of table at a time. But here we done shrink process in two phases because when we use alter table sm1 shrink space command the table locked temporarily some time period, during this period users unable to access the table. So if we use alter table sm1 shrink space compact command the table is not locked but space is defragmented. When we not in business hours issue the second phase shrink command then users are won’t get any problem. ii Because of above method the table dependent objects are goes to invalid state, to overcome this problem we have to use below command. [email protected]: alter table sm1 shrink space cascade; Table altered. The above command also shrinks the space of all dependent objects. We also do this in two phases like above two phases. See the below command. [email protected]: alter table sm1 shrink space compact cascade; Table altered. And then [email protected]: alter table sm1 shrink space cascade; Table altered. Transporting tablespace to different platform by Using RMAN : https://www.youtube.com/watch?v=CN401PUKK4A Oracle EBS apps Upgrade from 12 2 to 12 2 5 (start CD 51) : https://www.youtube.com/watch?v=zeO4goqR70Y Transport tablespace by using RMAN.: https://www.youtube.com/watch?v=YG6kWX7Par8
Views: 7412 BhagyaRaj Katta
02 How to configure Rang partition In oracle database
 
15:35
Now a days enterprises run databases of hundred of Gigabytes in size. These databases are known as Very Large Databases (VLDB). From Oracle Ver. 8.0 Oracle has provided the feature of table partitioning i.e. you can partition a table according to some criteria . For example you have a SALES table with the following structure Suppose this table contains millions of records, but all the records belong to four years only i.e. 1991, 1992, 1993 and 1994. And most of the time you are concerned about only one year i.e. you give queries like the following select sum(amt) from sales where year=1991; select product,sum(amt) from sales where year=1992 Group by product; Now whenever you give queries like this Oracle will search the whole table. If you partition this table according to year, then the performance is improve since oracle will scan only a single partition instead of whole table. This type of partitioning is useful when dealing with data that has logical ranges into which it can be distributed; for example, value of year. Performance is best when the data evenly distributes across the range
Views: 1951 Md Arshad
Oracle Database 12c: Partitioning Improvements with Tom Kyte
 
08:08
Tom Kyte introduces the new partitioning improvements in Oracle Database 12c, followed by a demo of global index maintenance. For more information: "Asynchronous Global Index Maintenance for Dropping and Truncating Partitions" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=VLDBG14107 "Changes for Very Large Databases and Partitioning in Oracle Database 12c Release 1" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=VLDBG14100 "ALTER INDEX COALESCE Clause" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=SQLRF52782 "DBMS_PART.CLEANUP_GIDX Procedure" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=ARPLS74409
Views: 14124 OracleDBVision
Dynamic Partitioning
 
05:16
Business intelligence is a growing area of business optimization focused on utilization of an organization's data. Business intelligence projects have consistently proved to increase profits and competitiveness of the organizations that implement it. The understanding, methodology and available technologies for developing business intelligence systems have reached a level of maturity where even smaller organizations can reap the benefits. In fact, with recent evolution in hardware and software, smaller organizations even have distinct advantages over larger organizations that allow them to develop BI systems faster, with less costs and with significant functional advantages. This is the right time to learn business intelligence and with this book the subject is as easily accessible as ever before.
Views: 2690 Business Intelligence
Table size ,Number of records,Disk usage in SQL Database,clear logs,cache
 
06:51
This clip will show you how to check each Table size, Number of records, Disk usage in SQL Database. You can see how to write the query to get details of all tables in terms of size, records, space utilization and free space on disk for tables. http://daynamicsaxaptatutorials.blogspot.com This is axapta ERP blog for Technical and functional fields and includes Microsoft Dynamics Axapta tutorials and Dynamics Axapta Coverage. This blog also contains x++ code help for Ax developer and solution of technical and functional daily issues. This blog is specific for Microsoft dynamics programming. Enterprise portal, SharePoint services, business connectors and Enterprise Resource Planning applications and sql database.It will help to get Microsoft Business Solutions. SQL subpart, SQL remainder, SQL language, SQL unit, SQL making, SQL portion, SQL auto, SQL part, SQL addition, SQL picture, SQL element, SQL supplement, SQL heating, SQL element, SQL hardware, SQL constituent, SQL factor, SQL constituent, SQL part, SQL residue, SQL unit, SQL butt, SQL basis, SQL appurtenance, SQL landside, SQL module, SQL crystal, SQL spare, SQL part,SQL section, SQL ingredient, SQL base, SQL balance, SQL residuum, SQL meronymy, SQL portion, SQL item, SQL substance, SQL part, SQL to, SQL whole, SQL relation, SQL spark, SQL gap, SQL car, SQL part, SQL pel, SQL audio, SQL computer, SQL hardware, SQL element, SQL pixel, SQL improver, SQL spare, SQL retrofit, SQL ingredient, SQL add-on, SQL input, SQL accessory,division, SQL point, SQL constituent, SQL part, SQL be-all, SQL and, SQL end-all, SQL plot, SQL element, SQL be, SQL all, SQL and, SQL end, SQL all, SQL element, SQL detail, SQL component, SQL part, SQL member, SQL rest, SQL linguistic, SQL unit, SQL relation, SQL particular, SQL residual, SQL part,
Views: 1041 Santosh kumar Singh
60. ALTER TABLE for Adding Column by Position with constraints in SQL (Hindi)
 
04:31
Please Subscribe Channel Like, Share and Comment Visit : www.geekyshows.com
Views: 9644 Geeky Shows
Index Rebuild vs. Reorganize
 
05:48
Some of my thoughts about performing either, or any at all. In some cases, I won't use indexes.
Views: 4543 SQLInSix Minutes
Oracle Tablespace Management | Important Things Explained Under 5 Mins | Oracle DBA
 
04:39
Oracle DBA - Tablespace Management Explained Under 5 Mins.! (ASM) Managing Oracle Tablespace - Important Things Explained Under 5 Minutes - Oracle DBA Tablespace Management Important Things Explained Under 5 Minutes - Oracle DBA Thanks for Watching please Like, Subscribe and Share...
Views: 228 BoxCut Media
How to Fetch Latest record/row from the Table in Oracle Database
 
03:32
You will learn how to How to Fetch Latest record/row from the Table in Oracle Database. Realtime Scenario: This logic can be implemented to find whether the latest record should be inserted or updated to datawarehouse
Oracle Database11g tutorials 14 : How to CREATE TABLE using sql developer and command prompt
 
08:36
Oracle Database11g tutorials 14 How to Create table using command prompt and Create table using sql developer Blog Link http://bit.ly/1TkY4Oe Time Line 0:25 Introduction of Tables in Database 1:03 What is Create Table (Introduction of create table) 1:30 Syntax of Create Table 2:08 How to create table using Command Prompt 4:55 How to create table using SQL Developer Links for Oracle Database tutorials 4: database connectivity using SQL developer and command prompt http://youtu.be/wSqoXRlXDUU You can have indepth knowledge about SQL create table here http://www.rebellionrider.com/sql-create-table.html Tool used in this tutorial is command prompt. This tutorial series is part of SQL expert exam certification training. if you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 Contacts E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com Today in this oracle database tutorial we will see How to CREATE A TABLE. if we have to define a table in layman language then we can say that Tables are just a collection of Rows and Columns but In RDBMS tables are database objects which help in organizing data into ROWS and COLUMNS. We can also say that SQL tables are kind of data structure which are used by database for efficient storage of data. To create a table in our database we use SQL CREATE TABLE command. SQL CREATE TABLE is a type of DATA DEFINITION LANGUAGE also known as DDL. To Create a table in your schema you will require CREATE TABLE system privilege. In our future videos we will see what are system and object privileges and how to grant them to a user. Today for this video we will be using Sample schema HR which already has all the necessary privileges. Ohk Let's see the syntax. CREATE TABLE table name ( column name1 Data-Type(size), column name2 Data-Type(size), ..... ); CREATE TABLE is an oracle reserved word or say an Oracle key word whereas There are 3 different ways of creating a table in Oracle database. Creating a table using Command Line Interface (CLI) in Oracle database For demonstrating how to create table in oracle database using CLI, I'll be using Command prompt. Thats how we create table using command prompt. you can check your table structure by DESCRIBE command for that just write DESC and your table name. Like this Another way of creating a table is by using Graphic user interface (GUI) in Oracle database To demonstrate how to create table using GUI we will use SQL developer. Lets open our SQL developer I am connected to HR schema if you do not know how to create a connection to database using SQL developer please watch my oracle database tutorial 4 that explains database connectivity using SQL developer and command prompt. Link for this video is in the description below. So lets create a table. Creating a table using SQL developer is very easy we do not have to fire any query here. Let's start First of all right click on your connection in which you want to create a table and choose schema browser. This will open a separate schema browser pane or you can expend your connection by clicking this + sign and then right click on table and choose New Table. However I prefer working with schema browser so let's skip to schema browser pane here from the first drop-down list you can choose connection name and in the second drop down list you can choose what database objects you want to work with we want to create a table thus I'll choose table and then click this arrow here and choose option for new table Ok we have created a table wizard first of all give a unique name to your table and add some column as well. For this, click the green plus button. Now we already have a column so give it some name. Also choose a datatype from the list and specify any size you can check this not null column if in case you want to make this a mandatory column you can also specify default value and constraint If you want to make this column a primary key you can click here In my future video i'll show you what are these constraints and different ways of applying them on a column in a table. for this video we will concentrate on create table only so when you are done with all your columns click ok Thats your table You can double click on your table here and can see its structure. Thats it
Views: 189341 Manish Sharma
Creating and Formatting Partitions with FDISK and mkfs - BASH - Linux
 
08:21
http://filmsbykris.com/wordpress/?p=318 Got Questions? visit http://FilmsByKris.com/forum Chat with us and learn more http://FilmsByKris.com/irc
Views: 113518 Kris Occhipinti
What is an Oracle Schema - Database Tutorial 58 - Oracle DBA Tutorial
 
10:48
What is an Oracle Schema - Database Tutorial 58 - Oracle DBA Tutorial An Oracle Schema is a generic user which is used to store the data. It starts as an user. But once the objects are created beneath this user, then this user becomes a schema. Other Oracle users will be given access to these schema objects so that they can work with these objects.
Views: 30716 Sam Dhanasekaran
Resizing a Linux Partition using GPARTED
 
04:01
Resize a VMs virtual drive using GPARTED. this step follows an earlier increase in size performed by Oracle's VirtualBox which effectively increased the available size but did not utilise all of it until now!
Views: 32052 Mon Goose
Does partitioning Improve performance ? Explained
 
07:14
Partitioning is a great feature for improving the way we manage our data. However we can also improve performance of select statements from the table as well. This requires a good understanding of the way partitioning works and how properly placing files on the disk can improve the IO performance. One common way that partitioning can improve performance for loading data is the sliding window method but in this post I am mainly talking about how to improve read performance. Before showing the improvements from partitioning it’s important to visit the indexes since a common belief is that a good index can provide faster data access than partitioning can.
Views: 1282 Jayanth Kurup
List all tables in a sql server database using a query  Part 65
 
05:38
Text version of the video http://csharp-video-tutorials.blogspot.com/2013/06/part-65-list-all-tables-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2013/09/part-65-list-all-tables-in-sql-server.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 In this video we will discuss, writing a transact sql query to list all the tables in a sql server database. This is a very common sql server interview question. Object explorer with in sql server management studio can be used to get the list of tables in a specific database. However, if we have to write a query to achieve the same, there are 3 system views that we can use. 1. SYSOBJECTS - Supported in SQL Server version 2000, 2005 & 2008 2. SYS.TABLES - Supported in SQL Server version 2005 & 2008 3. INFORMATION_SCHEMA.TABLES - Supported in SQL Server version 2005 & 2008 -- Gets the list of tables only Select * from SYSOBJECTS where XTYPE='U' -- Gets the list of tables only Select * from SYS.TABLES -- Gets the list of tables and views select * from INFORMATION_SCHEMA.TABLES To get the list of different object types (XTYPE) in a database Select Distinct XTYPE from SYSOBJECTS Executing the above query on my SAMPLE database returned the following values for XTYPE column from SYSOBJECTS IT - Internal table P - Stored procedure PK - PRIMARY KEY constraint S - System table SQ - Service queue U - User table V - View Please check the following MSDN link for all possible XTYPE column values and what they represent. http://msdn.microsoft.com/en-us/library/ms177596.aspx
Views: 95096 kudvenkat
How to increase Virtual Hard Disk Size on a Linux Virtual Machine
 
06:32
Blog Link : http://prasaddomala.com/how-to-increase-virtual-hard-disk-size-on-oracle-linux-virtual-machine/
Views: 19545 Prasad Domala
Oracle 12c new feature Identity column
 
09:48
Oracle 12c new feature Identity column oracle identity column identity columns in oracle 12c
Views: 360 Siva Academy
Very Large Databases Lessons Learned
 
01:10:26
Whoever coined the term "one size fits all" was not a DBA. Very large databases (VLDBs) have different needs from their smaller counterparts, and the techniques for effectively managing them need to grow along with their contents. In this session, join Microsoft Certified Master Bob Pusateri as he shares lessons learned over years of maintaining databases over 20TB in size. This talk will include techniques for speeding up maintenance operations before they start running unacceptably long, methods for minimizing user impact while critical processes run, the awesome world of data compression, and new features in SQL Server 2014 and 2016 that can really make your life easier. You'll also see how generally-accepted best practices aren't always the best idea for VLDB environments, and how, when, and why deviating from them can be appropriate. Just because databases are huge doesn't mean they aren't manageable, attend this session and see for yourself!
Views: 3310 DBAFundamentals
how to increase swap partition
 
11:19
In this tutorial you can learn how to increase swap partition
Views: 3668 Md.Mozzammal Haque
AskTOM Office Hours - partitioning for database administrators
 
53:44
blog: https://connor-mcdonald.com AskTOM Office Hours DBA free webinar
Views: 741 Connor McDonald
Oracle Tutorial ||online training|| Oracle|Adv Sql | Table Locks Part - 2 by basha
 
33:30
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......
Fix Windows Cannot be Installed To This Disk
 
02:16
Windows cannot be installed to this disk. The selected disk has an MBR partition table. On EFI sytems, Windows can only be installed to GPT disks. Visit my website: http://www.avoiderrors.net/?p=22853
Views: 525704 AvoidErrors
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: 3855 SkillBuilders
Resizing of standard xfs Partition in centos (NOT LVM)
 
06:18
NOTE :- First do this on a test environment 1. I made the partition type as Standard and let Centos create them Automatically.. / partition was /dev/sda3 and with 8.71GB Format Option was xfs 2. After running "parted" it shows my existing disk size is 10.7GB .. Lets increase it up to 15Gb and give a restart 3. Run a "Parted" again and check new disk size. now it shows 16.1GB 4. Now we are going to increase size of / partition (/dev/sda3). Please note that to do this the partition you are going to increase should be the last partition on partition table . 5. First we have to delete the existing / partition entry from Partition table . Dont worry this will not delete your data . 6. Run fdisk /dev/sda 7. Type "p" to print partition table . Check if the /dev/sda3 drive have bootable flag (*) and make a note of the starting cylinder. When creating the new parttion with increased size the starting cylinder of the new partition should be the same as the old one 8. Type "d" and select partition that you are going to delete . ( the last one) 9. Now create a new one . Make the partition type as primary . Extend will destroy everything 8. Give the starting cylinder as same as the old one . If your are going to use the whole available space for this partion just type return for the end cylinder . it will allocate all available space to this new partition 9. Now type "w" and write these changes to the partition table . 10. Check blkid of the new partition and make changes to fstab if necessary 11. Now go ahead and restart your computer . 12. This partition will not be resized until we run resize2fs or xfs_growfs . resize2fs only supports ext file format partitions . This is a xfs partition so we have to use xfx_growfs tool . 13. First run xfs_info /dev/sda3 to check current details of the partition . 14. Then run xfs_growfs /dev/sda3 this will do on-line resize of our / partion . Thats it . Hope this tutorial helped you .
Views: 5415 Sinethra Seneviratne
Data Warehouse 2 Query IO Statistics
 
27:57
00:00 Measure Query Size and Throughput 05:49 Demo Measure Query IO statistics 13:47 Demo Page Compression IO statistics 21:41 Demo Columsntore Index IO statistics Use IO Statistics to measure query size in MB and compare query and table sizes that use page compression and Columnstore Indexes script: http://garrettedmondson.wordpress.com/2012/09/02/columnstore-index-throughput/
Views: 1662 Garrett Edmondson
NTILE function in SQL Server
 
05:10
In this video we will discuss NTILE function in SQL Server NTILE function 1. Introduced in SQL Server 2005 2. ORDER BY Clause is required 3. PARTITION BY clause is optional 4. Distributes the rows into a specified number of groups 5. If the number of rows is not divisible by number of groups, you may have groups of two different sizes. 6. Larger groups come before smaller groups For example NTILE(2) of 10 rows divides the rows in 2 Groups (5 in each group) NTILE(3) of 10 rows divides the rows in 3 Groups (4 in first group, 3 in 2nd & 3rd group) Syntax : NTILE (Number_of_Groups) OVER (ORDER BY Col1, Col2, ...) SQL Script to create Employees table Create Table Employees ( Id int primary key, Name nvarchar(50), Gender nvarchar(10), Salary int ) Go Insert Into Employees Values (1, 'Mark', 'Male', 5000) Insert Into Employees Values (2, 'John', 'Male', 4500) Insert Into Employees Values (3, 'Pam', 'Female', 5500) Insert Into Employees Values (4, 'Sara', 'Female', 4000) Insert Into Employees Values (5, 'Todd', 'Male', 3500) Insert Into Employees Values (6, 'Mary', 'Female', 5000) Insert Into Employees Values (7, 'Ben', 'Male', 6500) Insert Into Employees Values (8, 'Jodi', 'Female', 7000) Insert Into Employees Values (9, 'Tom', 'Male', 5500) Insert Into Employees Values (10, 'Ron', 'Male', 5000) Go NTILE function without PARTITION BY clause : Divides the 10 rows into 3 groups. 4 rows in first group, 3 rows in the 2nd & 3rd group. SELECT Name, Gender, Salary, NTILE(3) OVER (ORDER BY Salary) AS [Ntile] FROM Employees What if the specified number of groups is GREATER THAN the number of rows NTILE function will try to create as many groups as possible with one row in each group. With 10 rows in the table, NTILE(11) will create 10 groups with 1 row in each group. SELECT Name, Gender, Salary, NTILE(11) OVER (ORDER BY Salary) AS [Ntile] FROM Employees NTILE function with PARTITION BY clause : When the data is partitioned, NTILE function creates the specified number of groups with in each partition. The following query partitions the data into 2 partitions (Male & Female). NTILE(3) creates 3 groups in each of the partitions. SELECT Name, Gender, Salary, NTILE(3) OVER (PARTITION BY GENDER ORDER BY Salary) AS [Ntile] FROM Employees Link for all dot net and sql server video tutorial playlists https://www.youtube.com/user/kudvenkat/playlists?sort=dd&view=1 Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2015/10/ntile-function-in-sql-server.html
Views: 41419 kudvenkat
Start Oracle Enterprise Manager
 
08:18
In this video i'm going to show you how to start and stop Oracle Enterprise Manager and how to use for creating a table step by step.
Views: 18579 OCP Technology
How to Create an Oracle VirtualBox Virtual Machine and Recover Data from a VDI Disk 💻📦⚕️
 
08:02
👍 Watch how to create an Oracle VirtualBox virtual machine, and how to recover data from a virtual disk of such machine after a failure or when the virtual machine can’t start. Recovering Data of Oracle VM VirtualBox Virtual Machine (*.vdi, *.vmdk, *.vhd, *.hdd, *.qed, *.qcow) - https://hetmanrecovery.com/recovery_news/recovering-data-of-oracle-vm-virtualbox-virtual-machine.htm. VirtualBox official webpage: https://www.virtualbox.org/. Watch another video on our channel to see how to create a bootable USB drive to install Windows: https://www.youtube.com/watch?v=YUOLPBSgwI4. Watch another video by our channel to see how to make a clean installation of Windows: https://www.youtube.com/watch?v=lb7P2iATJwc. In this video, I want to show you one trick, just in case if for some reason your virtual machine is no longer working, and there are important files on its disks. I will show you how to recover them. Though Oracle VirtualBox is a virtual machine, real data can be saved there. As we have already said, all files stored in virtual machine disks are located in .vdi files of the virtual disk (in our case). Hetman Partition Recovery, the program for hard disk data recovery, has the function of mounting virtual disks and recovering data from such disks. You can download Hetman Partition Recovery here: https://hetmanrecovery.com/hard_drive_recovery/software.htm In order to get access to virtual machine files: 1. Run Hetman Partition Recovery and mount the virtual machine disk. If there are several of them, you can mount them all at once or one by one.  To mount a virtual disk with the help of Hetman Partition Recovery, click on Mount Disk in the quick access menu of the program. As a result, the window of choosing a virtual disk will open.  Go to the folder containing the virtual machine and choose the necessary virtual disk file.  Open 2. As you do that, the section “Mounted Disks” containing the list of mounted virtual disks will appear in the window, where all disks found by the application are shown. If you mount several disks, you will see the entire disk list there. 3. Scan the disk with the application by clicking on the disk in the disk manager 4. After the analysis, the application will show the directory tree of the scanned disk. 5. Find and recover the necessary files to a convenient location in your main operating system. By the way, you can use this method to move files from a virtual machine disk to the main operating system. The methods we have described for recovering data of an Oracle VM VirtualBox virtual machine are good for virtual machine regardless of their virtual disk format: *.vdi, *.vmdk, *.vhd, *.vhdx, *.hdd, *.qed, *.qcow and they will be absolutely similar for all of these virtual disk formats. In this video, we have used the *.vdi virtual disk format as an example. I also recommend watching our previous videos on VMWare Workstation and Microsoft Hyper-V virtual machines; you can find the links in the description of this video. How to create a VMWare virtual machine and recover data from a VMDK disk with VMFS https://www.youtube.com/watch?v=7IOkVnQfN0E. How to create a Microsoft Hyper V virtual machine and recover data from a VHDX disk https://www.youtube.com/watch?v=2FcU_3JGReI. That is all for now. If you liked this video, click the Like button below and subscribe to our channel to see more. We’ll be glad to answer any questions in comments. Thank you for watching and good luck! Playlist: Recovering Data Deleted From The Hard Disk of a Windows Computer or Laptop - https://www.youtube.com/playlist?list=PLWfvrWYvsWiJz-xwWNm8AnZSzoAzDq-Zp. Other videos: #OracleVirtualBox, #VirtualMachine, #VMDK, #DataRecovery, #vhd, #vdi.
Views: 4245 Hetman Recovery
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: 1447 Connor McDonald
Let's Learn SQL! Lesson 122: Creating SET and MULTISET Tables
 
04:02
Explore SQL with Tom Coffing of Coffing Data Warehousing! In this lesson, learn how to create a SET or MULTISET Table!
size of a database
 
04:10
Views: 253 Chris Morris
Automatic Task with Scheduler running jobs
 
14:36
Hi guys today im going to showing you to how to run automatic jobs in oracle very helpful. #AutomaticTaskwithScheduler Oracle database Unbeatable,Unbreakable Platform..
Views: 8686 Oracle World
SQL Server Data Compression
 
54:53
Have you heard of the data compression feature in Enterprise Editions of SQL Server 2008 and later? It promises great savings on storage space. But did you know it can also improve I/O performance and enhance SQL Server memory? It also has costs too, in particular, it costs additional CPU to compress data on the fly. But how much CPU is spent on data compression overhead? Is it too much to be worth your time? Or is it an acceptable cost for the big gains in storage space, I/O performance, and memory improvements? To find out all about this cool technology, join Kevin Kline (@kekline) and Melissa Connors (@melikanokaoi) for this case study webinar. They’ll show how data compression works, how to choose the tables and indexes to compress, and the positive and negative performance impact of implementing data compression. Attend this webinar to learn the important ways that data compression affects workloads.
Views: 2458 SentryOne
Maintenance Plan for Update Statistics Task in SQL Server
 
06:47
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg If your queries are executing slower, then it is time to update the statistics. It is recommended to update your statistics after you insert a larger amount of data into ascending or descending key columns because in such cases the statistics histogram might not have any information about the newly inserted values. This task is used to update SQL Server information about the data in the tables and indexes. This task resamples the distribution statistics of each index created on user tables in the database. The distribution statistics are used by SQL Server to optimize navigation through tables during the processing of Transact-SQL statements. To build the distribution statistics automatically, SQL Server periodically samples the data in the corresponding table for each index.This size of the sample is based on the number of rows in the table and the frequency of data modification. Use this option to perform an additional sampling using the specified percentage of data in the tables. SQL Server uses this information to create better query plans. This task executes the UPDATE STATISTICS statement.
Views: 1105 IT Port
Oracle tutorial : Collection in Oracle PL SQL -  Varray
 
06:57
Oracle tutorial : Collection in Oracle PL SQL Varray . oracle tutorial for beginners 1)Varray provide feature of data structure in Oracle. 2)It can store a fixed-size sequential collection of elements of the same type. 3)This is used to store the ordered collection of data. 4)According to its structure the varray consist of contiguous memory locations. 5)The address is start from lowest to highest. 6)It start to store element from lowest address to highest address. 7)The starting index for varray is 1. 8)This is an one-dimensional array. Syntax : CREATE OR REPLACE TYPE varray_type_name IS VARRAY(n) of element_type DECLARE CURSOR cur_employee is SELECT NAME FROM employee; type emp_list is varray (10) of employee.name%type; empname_list emp_list := emp_list(); mycount integer :=0; BEGIN FOR i IN cur_employee LOOP mycount := mycount + 1; empname_list.extend; empname_list(mycount) := i.name; dbms_output.put_line('Employee Nane -'||empname_list(mycount)); END LOOP; END; / https://techquerypond.com , https://techquerypond.wordpress.com https://twitter.com/techquerypond
Views: 1526 Tech Query Pond
SQL Server Tutorial 20:  Table, Index and Row Compression
 
10:32
How to use table, index and row compresson with SSMS or T-SQL. For more info, or a copy of the scripts used in this tutorial, please email me at [email protected]
Views: 3151 Johnny Deluca
Horizontal fragmentation in Hindi | Distributed Database Tutorials
 
04:54
Video Credit goes to Adwait sharma Notes coming soon visit our website for full course www.lastmomenttuitions.com NOTES FORM : https://goo.gl/1aQtNc Introduction to Distributed Database : https://goo.gl/JHdpz8 Design Issues in Distributed database : https://goo.gl/aHFe8k Architectures in Distributed database : https://goo.gl/ETL5Ku Fragmentation and correctness rules : https://goo.gl/nbhq5T Horizontal fragmentation : https://goo.gl/N1rvgR Vertical fragmentation : https://goo.gl/tmNxY8 Derived horizontal fragmentation : https://goo.gl/LJ7cvV Query processing cost : https://goo.gl/uUL9de Concurrency Control Protocol : https://goo.gl/XC6oc9 Locking Based Concurrency : https://goo.gl/nrCctM Dead Lock and its Prevention Techniques : https://goo.gl/Nm7Gr6 Dead Lock Detection Method : https://goo.gl/yZxue8 Two Phase commit Protocol: https://goo.gl/6fjYrM Three Phase commit protocol : https://goo.gl/bbFHqV Phases of Distributed Query Processing : https://goo.gl/zUetvK whatsapp: 7038604912 more videos coming soon subscribe karke rakho tab tak
Views: 16907 Last moment tuitions
How to Run an Existing Linux Partition in VirtualBox
 
05:54
This is just a tutorial showing the process. Before you attempt this, read the full instructions and all the warnings that come with it: http://lifehacker.com/how-to-dual-boot-and-virtualize-the-same-partition-on-y-493223329 Lifehacker: Tips and downloads for getting things done. http://lifehacker.com/
Views: 35567 Lifehacker
Let's Learn Teradata Lesson 39: Columnar Tables!
 
06:31
Explore Teradata with Tera-Tom of Coffing Data Warehousing! In this lesson, learn more about Columnar Tables!
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: 20339 TechBrothersIT
HOW TO SET THE PAGE SIZE IN SQL PLUS | SIMPLE WAY|
 
02:41
SEE HOW TO SET THE PAGE SIZE IN SHORT SIZE OF DATA| SQL PLUS
Views: 96 C 4 U
How To Set Up A Hard Drive RAID In Open Media Vault
 
03:04
When setting up a software RAID on Open Media Vault, it’s required to have at least three hard drives (or more) of roughly the same size, with ideally no partition tables, or data on it at the start. More info at https://www.addictivetips.com/ubuntu-linux-tips/hard-drive-raid-in-open-media-vault/
Views: 2715 AddictiveTipsTV
Page and Row Compression Deep Dive (DBA)
 
01:24:40
Bradley Ball, Pragmatic Works
Views: 793 PASStv
Using MX Linux 17 installer,  partitions,format,UEFI
 
05:48
The swap can be anywhere from 1GB up. I always use a 2GB swap. some say it needs to be at least the same size as your installed memory. 8GB memory = 8GB swap.
Views: 2668 Linux & Projects
Let's Learn SQL! Lesson 127: Setting the Data Block Size or Freespace Percent of a Table
 
02:56
Explore SQL with Tom Coffing of Coffing Data Warehousing! In this lesson, learn how to set a table's data block size or freespace percent!
VirtualBox - How to Resize a Partition Using Gparted in Knoppix
 
12:13
1) Download Partition Software Knoppix Gparted - www.knoppix.net 2) My How to Resize the Virtual Hard Drive for VirtualBox Video https://www.youtube.com/watch?v=EQETHOXaY_I Demostrates how to resize a Partition for Linux and Windows using the Live Boot CD Knoppix and the Gparted Utility
Views: 9990 CodeCowboyOrg
08 08 Invisible Indexes
 
03:27
ORACLE
Views: 136 oracle ocm
How to Create or resize partition after install linux 2018
 
05:13
How to Create or resize partition after install ubuntu or linux with Gparted Live .
Views: 9326 Learning Zone