Home
Search results “Oracle date range partition”
Creating range partition in Oracle 12c - Part 1
 
11:32
Partition makes a table access faster in case of very large table. In this tutorial we have tried to demonstrate the range partition on date.
Views: 137 Subhroneel Ganguly
What is the RANGE PARTITION in Oracle ?
 
14:10
Hi guys in my today scenario I'm going to explain with you What is the RANGE PARTITION in Oracle, Oracle database #RANGEPARTITIONUnbeatable,Unbreakable Platform..
Views: 7088 Oracle World
part 4 date range partition
 
02:33
date range paritition data warehousing range partition
exchange Partition , Move partition in oracle
 
08:42
exchange Partition , Move partition in oracle Possible operations with partitions 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 Add Drop Rename Split Move ( Moving from Tablespace to tablespace) Exchange (Table to Table(non Partitioned table)) not partitioned only exchanging data (p)
Views: 1158 TechLake
AskTom TV - densification of data in date ranges
 
05:16
A video to help you understand the "thought process" behind answering AskTom questions. In this episode, we look at how to fill in the blanks with a range of dates. Original question: https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:9536337800346137139 blog: https://connor-mcdonald.com ========================================­­­­============== Copyright © 2017 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: 489 Connor McDonald
Oracle Tutorial || Oracle|Adv Sql | Interval Partition Part - 1 by basha
 
33:26
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......
KISS series on Partitioning: 03 Multi column range partitioning
 
05:16
Welcome to the KISS video series on Partitioning, where we take a more developer-centric look at how partitioning can make our applications more successful. In this session, we look at range partitioning on multiple columns Scripts: https://livesql.oracle.com/apex/livesql/file/content_ERYV6B909XK196IAKLBUQIJSN.html blog: https://connor-mcdonald.com ========================================­­============== Copyright © 2017 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: 890 Connor McDonald
What is the LIST PARTITION in Oracle ?
 
07:56
Hi guys in my today scenario I'm going to explain with you What is the LIST PARTITION in Oracle, #LISTPARTITIONinOracle Oracle database Unbeatable,Unbreakable Platform..
Views: 3540 Oracle World
Oracle Partitioning
 
01:35
http://www.oracle.com/database/real-application-testing.html ... Uses real workloads—Replays real workloads, not synthetic or artificial loads Comprehensive—100% coverage for entire change lifecycle ... Scalable—Requires similar effort for small and large changes ... Predictable—Transfers exact resolution of changes from testing to production ... Cost efficient—Reduces testing effort by up to 80%...
Views: 21147 Claudio Lichtenthal
RANGE PARTITION in Oracle
 
14:10
what is RANGE PARTITION in Oracle
Views: 35 Gees info
MySQL Partitioning
 
16:27
In the tenth episode of 'Getting Started With MySQL' Series, we get to walk through the different types of Table Partitioning (such as RANGE, LIST and HASH) in MySQL Database. Most importantly we get some idea on what benefit we get out of partitioning a Database Table.
Views: 8513 Rajesh Rajasekharan
AskTom TV - Reference Partitioning
 
06:44
blog: https://connor-mcdonald.com Options for how to populate the data in reference partitioned tables efficiently.
Views: 223 Connor McDonald
01 Overview of table Partition in oracle
 
07:26
Partitioning enhances the performance, manageability, and availability of a wide variety of applications and helps reduce the total cost of ownership for storing large amounts of data. Partitioning allows tables, indexes, and index-organized tables to be subdivided into smaller pieces, enabling these database objects to be managed and accessed at a finer level of granularity. Oracle provides a rich variety of partitioning strategies and extensions to address every business requirement. Moreover, since it is entirely transparent, partitioning can be applied to almost any application without the need for potentially expensive and time consuming application changes. Partitioning allows a table, index, or index-organized table to be subdivided into smaller pieces, where each piece of such a database object is called a partition. Each partition has its own name, and may optionally have its own storage characteristics. From the perspective of a database administrator, a partitioned object has multiple pieces that can be managed either collectively or individually. This gives the administrator considerable flexibility in managing partitioned objects. However, from the perspective of the application, a partitioned table is identical to a non-partitioned table; no modifications are necessary when accessing a partitioned table using SQL queries and DML statements. Partitioning Key ======================== Each row in a partitioned table is unambiguously assigned to a single partition. The partitioning key is comprised of one or more columns that determine the partition where each row will be stored. Oracle automatically directs insert, update, and delete operations to the appropriate partition through the use of the partitioning key. When to Partition a Table ========================== Here are some suggestions for when to partition a table: Tables greater than 2 GB should always be considered as candidates for partitioning. Tables containing historical data, in which new data is added into the newest partition. A typical example is a historical table where only the current month's data is updatable and the other 11 months are read only. When the contents of a table need to be distributed across different types of storage devices. When to Partition an Index ============================= Here are some suggestions for when to consider partitioning an index: Avoid rebuilding the entire index when data is removed. Perform maintenance on parts of the data without invalidating the entire index. Reduce the impact of index skew caused by an index on a column with a monotonically increasing value. Partitioned Index-Organized Tables =================================== Partitioned index-organized tables are very useful for providing improved performance, manageability, and availability for index-organized tables. For partitioning an index-organized table: ============================================ Partition columns must be a subset of the primary key columns Secondary indexes can be partitioned (both locally and globally) OVERFLOW data segments are always equi-partitioned with the table partitions See Also: Oracle Database Concepts for more information about index-organized tables System Partitioning System partitioning enables application-controlled partitioning without having the database controlling the data placement. The database simply provides the ability to break down a table into partitions without knowing what the individual partitions are going to be used for. All aspects of partitioning have to be controlled by the application. For example, an insertion into a system partitioned table without the explicit specification of a partition will fail. System partitioning provides the well-known benefits of partitioning (scalability, availability, and manageability), but the partitioning and actual data placement are controlled by the application. See Also: Oracle Database Data Cartridge Developer's Guide for more information about system partitioning Partitioning for Information Lifecycle Management Information Lifecycle Management (ILM) is concerned with managing data during its lifetime. Partitioning plays a key role in ILM because it enables groups of data (that is, partitions) to be distributed across different types of storage devices and managed individually.
Views: 7018 OnLinE ReSoUrCe
Dates, Times and Intervals in Oracle - The INTERVAL Datatype
 
06:22
This video clip, on the INTERVAL Data Type, is taken from my www.pluralsight.com course "Introduction to Dates, Times and Intervals in Oracle". Click here to learn more about this course: http://www.pluralsight.com/courses/intro-dates-times-intervals-oracle?utm_source=youtube&utm_medium=video&utm_campaign=authordemo.
Views: 1453 sheepsqueezersYT
Using Rownum to find out Nth record from First, Last and within a range in a table.
 
04:59
Using Rownum to find the first nth record and last nth record and in between record in emp table. This is the most frequesntly questions ever asked in interviews.
Views: 3277 Kiranjit Parida
Composite Partitioning in Oracle
 
12:14
This video is the 6th Video in the series partitioning in oracle. It explains the different composite partitioning approaches and in what scenario they should be used with real project use case explanations.
Views: 2411 Tech Coach
How to Convert a Non-Partitioned Table to Partitioned using Oracle Database 12c R2
 
05:02
Oracle Database 12c Release 2 New Feature! Learn how to convert a non-partitioned table to a partitioned table - Online! This new method - using ALTER TABLE MODIFY - is much simpler than DBMS_REDEFINITION. In this free tutorial from SkillBuilders and Oracle Certified Master DBA John Watson you'll see a demonstration of converting the table and the impact on the underlying table and indexes. See all our free Oracle Database Tutorials at http://www.skillbuilders.com/free-oracle-tutorials.
Views: 3135 SkillBuilders
What is the RANGE-HASH SUBPARTITIONS in Oracle ?
 
05:35
Hi guys in my today scenario I'm going to explain with you What is the RANGE-HASH SUB-PARTITIONS in Oracle,Oracle database #RANGE-HASHSUBPARTITIONS Unbeatable,Unbreakable Platform..
Views: 1409 Oracle World
part 2 range partition number
 
03:35
Range partition, table space, data warehousing, range partition using number
Views: 3591 Dr. Girija Narasimhan
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: 9070 Tech Coach
Dates, Times and Intervals in Oracle - The INTERVAL Year to Month Literal
 
04:38
This video clip, on the INTERVAL YEAR TO MONTH Literal, is taken from my www.pluralsight.com course "Introduction to Dates and Times in SQL Server". Click here to learn more about this course: http://www.pluralsight.com/courses/intro-dates-times-intervals-oracle?utm_source=youtube&utm_medium=video&utm_campaign=authordemo.
Views: 1831 sheepsqueezersYT
part 17 split partition
 
01:56
split partition, data warehousing, alter table
KISS series on Partitioning: 08 Converting ranges to interval partitions
 
04:30
Welcome to the KISS video series on Partitioning, where we take a more developer-centric look at how partitioning can make our applications more successful. In this session, we look at converting range partitioned tables to interval partitioned tables Scripts: https://livesql.oracle.com/apex/livesql/file/content_E7J2B8MNH9S7QPIC23E5PEAVI.html blog: https://connor-mcdonald.com ========================================­­============== Copyright © 2017 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: 383 Connor McDonald
part 12 truncate partition
 
01:55
Truncate partition, alter table, data warehousing
Oracle - Global is Local
 
05:42
Views: 64 IFBTA
Using Partition Wise Join
 
06:15
This video shows you the use of partition wise join in parallel processing. Copyright © 2012 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. 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 of merchantability, fitness for a particular purpose, and non-infringement.
LAST VALUE function in SQL Server
 
05:35
last_value function in sql server 2008 sql server last_value function returns incorrect data sql server last_value function example sql server last_value function with partition example LAST_VALUE function in SQL Server In this video we will discuss LAST_VALUE function in SQL Server. LAST_VALUE function Introduced in SQL Server 2012 Retrieves the last value from the specified column ORDER BY clause is required PARTITION BY clause is optional ROWS or RANGE clause is optional, but for it to work correctly you may have to explicitly specify a value Syntax : LAST_VALUE(Column_Name) OVER (ORDER BY Col1, Col2, ...) LAST_VALUE function not working as expected : In the following example, LAST_VALUE function does not return the name of the highest paid employee. This is because we have not specified an explicit value for ROWS or RANGE clause. As a result it is using it's default value RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW. SELECT Name, Gender, Salary, LAST_VALUE(Name) OVER (ORDER BY Salary) AS LastValue FROM Employees LAST_VALUE function working as expected : In the following example, LAST_VALUE function returns the name of the highest paid employee as expected. Notice we have set an explicit value for ROWS or RANGE clause to ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING This tells the LAST_VALUE function that it's window starts at the first row and ends at the last row in the result set. SELECT Name, Gender, Salary, LAST_VALUE(Name) OVER (ORDER BY Salary ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS LastValue FROM Employees LAST_VALUE function example with partitions : In the following example, LAST_VALUE function returns the name of the highest paid employee from the respective partition. SELECT Name, Gender, Salary, LAST_VALUE(Name) OVER (PARTITION BY Gender ORDER BY Salary ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS LastValue FROM Employees Text version of the video http://csharp-video-tutorials.blogspot.com/2015/10/lastvalue-function-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2015/10/lastvalue-function-in-sql-server_9.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 Full SQL Server Course https://www.youtube.com/playlist?list=PL4cyC4G0M1RQ_Rm52cQ4CcOJ_T_HXeMB4 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: 32865 kudvenkat
DateTime functions in SQL Server   Part 25
 
15:26
In this video we will learn about different DateTime data types, and different date time functions in sql server. We will also understand the difference between terms UTC (Coordinated Universal Time) and Time Zone offset. Text version of the video http://csharp-video-tutorials.blogspot.co.uk/2012/09/datetime-functions-in-sql-server-part-25.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-25-datetime-functions-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
Views: 200330 kudvenkat
Difference between rows and range
 
05:52
range vs rows in sql server difference between rows clause and range clause in sql server range clause vs rows clause in sql server sql server running total query running total example in sql server In this video we will discuss the difference between rows and range in SQL Server. This is continuation to Part 116. Please watch Part 116 from SQL Server tutorial before proceeding. Let us understand the difference with an example. We will use the following Employees table in this demo. SQL Script to create the Employees table Create Table Employees ( Id int primary key, Name nvarchar(50), Salary int ) Go Insert Into Employees Values (1, 'Mark', 1000) Insert Into Employees Values (2, 'John', 2000) Insert Into Employees Values (3, 'Pam', 3000) Insert Into Employees Values (4, 'Sara', 4000) Insert Into Employees Values (5, 'Todd', 5000) Go Calculate the running total of Salary and display it against every employee row The following query calculates the running total. We have not specified an explicit value for ROWS or RANGE clause. SELECT Name, Salary, SUM(Salary) OVER(ORDER BY Salary) AS RunningTotal FROM Employees So the above query is using the default value which is RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW This means the above query can be re-written using an explicit value for ROWS or RANGE clause as shown below. SELECT Name, Salary, SUM(Salary) OVER(ORDER BY Salary RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS RunningTotal FROM Employees We can also achieve the same result, by replacing RANGE with ROWS SELECT Name, Salary, SUM(Salary) OVER(ORDER BY Salary ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS RunningTotal FROM Employees What is the difference between ROWS and RANGE To understand the difference we need some duplicate values for the Salary column in the Employees table. Execute the following UPDATE script to introduce duplicate values in the Salary column Update Employees set Salary = 1000 where Id = 2 Update Employees set Salary = 3000 where Id = 4 Go Now execute the following query. Notice that we get the running total as expected. SELECT Name, Salary, SUM(Salary) OVER(ORDER BY Salary ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS RunningTotal FROM Employees The following query uses RANGE instead of ROWS SELECT Name, Salary, SUM(Salary) OVER(ORDER BY Salary RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS RunningTotal FROM Employees Notice we don't get the running total as expected. So, the main difference between ROWS and RANGE is in the way duplicate rows are treated. ROWS treat duplicates as distinct values, where as RANGE treats them as a single entity. All together side by side. The following query shows how running total changes 1. When no value is specified for ROWS or RANGE clause 2. When RANGE clause is used explicitly with it's default value 3. When ROWS clause is used instead of RANGE clause SELECT Name, Salary, SUM(Salary) OVER(ORDER BY Salary) AS [Default], SUM(Salary) OVER(ORDER BY Salary RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS [Range], SUM(Salary) OVER(ORDER BY Salary ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS [Rows] FROM Employees Text version of the video http://csharp-video-tutorials.blogspot.com/2015/10/difference-between-rows-and-range.html Slides http://csharp-video-tutorials.blogspot.com/2015/10/difference-between-rows-and-range_8.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: 33688 kudvenkat
Rows Unbounded Preceding, Following in SQL Server
 
11:35
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg From SQL Server 2012, This feature enabled to OVER BY Windowing Functions The ROWS limits the rows within a partition by specifying a fixed number of rows preceding or following the current row. Preceding and following rows are defined based on the ordering in the ORDER BY clause ROWS BETWEEN 1 PRECEDING AND CURRENT ROW – Aggregates 2 Between Last Row and Current Row ROWS BETWEEN CURRENT ROW AND 1 FOLLOWING – Aggregates 2 Current Row and Next Row ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW – Aggregates all Rows before Current Row with Current Row ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING – Aggregates all the Rows After Current Row With Current Row ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING – Aggregates all Rows
Views: 1332 IT Port
How to Code Oracle Analytic Functions
 
52:40
Many more free Oracle Database and SQL tutorials at http://skillbuilders.com/free-oracle-tutorials. SQL is a language that allows you to perform queries to answer a wide range of questions about your data. While standard SQL is quite powerful, there are many questions that it cannot answer at all or that it can only answer with complex and inefficient SQL workarounds. Questions about running totals, percent of total, and ranking within a group fall into this area. Also, more complex issues such as Top-N within a group and aggregates over a range also fall in this arena. These questions can be easily answered via a new class of SQL statements called Analytic Functions. This presentation will show you how to use Oracle's Analytic Function extensions to SQL to answer these questions simply and efficiently.
Views: 26094 SkillBuilders
part 7 model clause partition by
 
04:11
dimension by, partition by, model clause, sql model, data warehousing
PART 6 RANAME PARTITION
 
01:15
rename partition, data warehousing, alter table
part 15 move partition
 
01:58
move partition, alter table, data warehousing
T-SQL: Over() and Partition By
 
04:17
Show how to use OVER and PARTITION BY to get groups of data with aggregation.
Views: 6606 MidnightDBA
PART 7 MERGE PARTITION
 
01:54
merge partition, alter table, data warehousing
part 3 range alphabet
 
05:25
data warehousing, range partition, table space, create table
Oracle Tutorial || Oracle|Adv Sql | Interval Partition Part - 3 by basha
 
12:14
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......
part 8 drop partition
 
01:18
drop partition alter table data warehousing
part 16 default value add list partition
 
03:21
default value using list partition, alter table, data warehousing
Row Number function in SQL Server
 
07:24
sql server row_number example sql server row number by partition sql server row_number over partition by order by In this video we will discuss Row_Number function in SQL Server. This is continuation to Part 108. Please watch Part 108 from SQL Server tutorial before proceeding. Row_Number function Introduced in SQL Server 2005 Returns the sequential number of a row starting at 1 ORDER BY clause is required PARTITION BY clause is optional When the data is partitioned, row number is reset to 1 when the partition changes Syntax : ROW_NUMBER() OVER (ORDER BY Col1, Col2) Row_Number function without PARTITION BY : In this example, data is not partitioned, so ROW_NUMBER will provide a consecutive numbering for all the rows in the table based on the order of rows imposed by the ORDER BY clause. SELECT Name, Gender, Salary, ROW_NUMBER() OVER (ORDER BY Gender) AS RowNumber FROM Employees Please note : If ORDER BY clause is not specified you will get the following error The function 'ROW_NUMBER' must have an OVER clause with ORDER BY Row_Number function with PARTITION BY : In this example, data is partitioned by Gender, so ROW_NUMBER will provide a consecutive numbering only for the rows with in a parttion. When the partition changes the row number is reset to 1. SELECT Name, Gender, Salary, ROW_NUMBER() OVER (PARTITION BY Gender ORDER BY Gender) AS RowNumber FROM Employees Use case for Row_Number function : Deleting all duplicate rows except one from a sql server table. Discussed in detail in Part 4 of SQL Server Interview Questions and Answers video series. Text version of the video http://csharp-video-tutorials.blogspot.com/2015/09/rownumber-function-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2015/09/rownumber-function-in-sql-server_30.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: 79952 kudvenkat
AskTOM TV - SQL trace, SQL plus, SQL developer
 
05:12
A video to help you understand the "thought process" behind answering AskTom questions. In this episode, we look at how we can use SQL trace to diagnose what autotrace privileges we need in SQL Developer blog: https://connor-mcdonald.com ========================================­­­­============== Copyright © 2017 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: 1094 Connor McDonald
Merge Range - Partition in SQL Server - Part 4
 
05:40
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg Drops a partition and merges any values that exist in the partition into one of the remaining partitions. RANGE (boundary_value) must be an existing boundary value, into which the values from the dropped partition are merged. The filegroup that originally held boundary_value is removed from the partition scheme unless it is used by a remaining partition, or is marked with the NEXT USED property. Alter Partition Function Part_Function_Name Merge Range ()
Views: 163 IT Port
part 14 coalescing hash partition
 
01:40
coalescing hash partition, data warehousing,alter table
Views: 1058 Dr. Girija Narasimhan
TSQL: GROUP BY Quarter And Six Months/Half Year
 
05:19
This video is sponsored by FinTek Development. You can get the code on their sponsored post https://www.fintekdev.com/tsql-group-by-quarter-six-months-half-year/. Automating ETL: https://www.udemy.com/automatingetl/
Views: 1742 SQLInSix Minutes
part 11  modify parition drop values
 
02:15
alter table modify partition, drop values,