Home
Search results “Find oracle locked objects”
How to Get locked Objects in SQL Server
 
08:38
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg Generally, There are two ways to get what are the objects are Locked. First way with SP_LOCK, We can get the Locked Object details in a Particular Session Or SQL Server Engine. Second way is Used with DMV, Sys.dm_trans_lock it returns the Locked Objects with Some more data's when compared to SP_LOCK. Both are explained with Simplest Example in this Video. To Get Locked Objects ----------------------------------- Select S2.host_name, S1.Resource_type, (Case when S1.resource_type IN ('RID', 'PAGE') then s5.name when S1.resource_type IN ('DATABASE') then s6.name else S4.Name end) Name, S1.resource_associated_entity_id, S1.request_mode, S1.request_type, S1.request_status, S1.request_session_id, ISNULL(S3.rows , 0) Rows From Sys.dm_tran_locks S1 Inner join Sys.dm_exec_sessions S2 on S1.request_session_id = S2.session_id left join sys.partitions S3 on S1.resource_associated_entity_id = S3.partition_id left join sys.objects s5 on s3.object_id = S5.object_id left join sys.objects S4 on (case when S1.resource_type = 'OBJECT' THEN S1.resource_associated_entity_id else null End) = S4.object_id left join sys.sysdatabases s6 on S1.resource_database_id = s6.dbid Where S1.resource_database_id = DB_ID() With Requested SQL Server Statement ------------------------------------------------------------- Select S1.*, S2.text From sys.sysprocesses S1 cross apply sys.dm_exec_sql_text (Sql_handle) S2 Where spID = SessionID
Views: 297 IT Port
How to find Oracle Database locked session using Oracle Enterprise Manager 12C
 
02:09
Video tutorial on how to find Oracle Database locked session using Oracle Enterprise Manager 12C. For more Database Administration articles and scripts go to www.aodba.com & www.verticablog.com More Articles, Scripts and How-To Papers on http://www.aodba.com
Views: 5154 AO DBA
How to lock objects in Redgate SQL Source Control
 
02:26
Microsoft MVP Alessandro Alpi explains how to use the database object locking feature in Redgate SQL Source Control. SQL Source Control is an add-on for SSMS that lets you version control your database changes using your existing version control system. Find out more and try SQL Source Control for free http://www.red-gate.com/sql-source-control).
Views: 1178 Redgate Videos
Resetting Your Oracle Database Password with Oracle SQL Developer
 
02:43
Resetting your Oracle Database user password just got a LOT easier in version 4.2 of SQL Developer. In this video, the product manager shows you JUST how much easier.
Views: 23016 Jeff Smith
Toad for Oracle Schema browser how you will get the detail of database object ,log on schema
 
06:35
Toad for Oracle Schema browser how you will get the detail of database object ,log on schema,others schema,user
Views: 8408 Abinash Sahoo
Batman Arkham Knight - Bleake Island - All Riddle Locations & Solutions
 
06:33
There are 11 Riddles on Bleake Island. Batman Arkham Knight has 315 Riddler Collectibles in total (179 Trophies, 40 Riddles, 6 Bomb Rioters, 90 Breakable Objects). Find all of their locations to complete Riddler's challenges and to lock him up in GCPD. This will earn you the "Riddle Me That" trophy / achievement. It's also required for 100% game completion and to initiate the full Knightfall Protocol. You can interrogate Riddler Informants on the streets of Gotham to unlock the collectible locations on your world map. Riddler informants are highlighted in green color. Instead of killing them you must press Triangle (PS4) / Y (XB1) to interrogate them. It's recommended that you beat the story first before collecting anything! This is to ensure that you have all the required gadgets and can access all areas. You can keep track of your progress in the Riddle Section of your world map. There you can see which objects you have found in each area. Please note that all 90 breakable objects together count only as 18 of the 243 Riddler challenges (every fifth one counts as one complete challenge). The Riddler trophies are green question mark items that you must pick up (usually locked away in rooms that require certain gadgets). The Riddles are little Puzzles and require you to scan certain objects in the world from a specific distance. The bomb rioters are thugs with bomb implants and you must shoot them with an electric charge. The breakable objects need to be destroyed with your batmobile. Overview of Collectibles by Area: Bleake Island = 37 Trophies, 11 Riddles, 3 Riot Bombers, 15 Breakable Objects Miagani Island = 38 Trophies, 10 Riddles, 3 Bomb Rioters, 15 Breakable Objects Founders' Island = 41 Trophies, 10, Riddles, 0 Bomb Rioters , 15 Breakable Objects Stagg Enterprises Airships = 21 Trophies, 3 Riddles, 0 Bomb Rioters, 15 Breakable Objects Panessa Studios = 21 Trophies, 3 Riddles, 0 Bomb Rioters, 15 Breakable Objects Arkham Knight HQ = 21 Trophies, 3 Riddles, 0 Bomb Rioters, 15 Breakable Objects All Riddler Collectibles Playlist: https://www.youtube.com/playlist?list=PLRr5L69yg_kGj9roh6fYVG49GbPKMYb20 TIMELINE: #1 - 0:05 #2 - 0:42 #3 - 1:06 #4 - 1:57 #5 - 2:41 #6 - 3:31 #7 - 4:00 #8 - 4:27 #9 - 4:55 #10 - 5:31 #11 - 5:52 Helped you out? Support this channel: http://www.powerpyx.com/help/ SUBSCRIBE: http://www.youtube.com/subscription_center?add_user=powerpyx ~~~~~~~~~~~~~~~~~~~~~~~~~~ Follow PowerPyx: http://www.powerpyx.com http://www.youtube.com/PowerPyx http://www.facebook.com/PowerPyx http://www.twitter.com/PowerPyx ~~~~~~~~~~~~~~~~~~~~~~~~~
Views: 589243 PowerPyx
Batman Arkham Knight - Bleake Island - All Riddler Trophy Locations
 
28:12
There are 37 Riddler Trophies on Bleake Island. Batman Arkham Knight has 315 Riddler Collectibles in total (179 Trophies, 40 Riddles, 6 Bomb Rioters, 90 Breakable Objects). Find all of their locations to complete Riddler's challenges and to lock him up in GCPD. This will earn you the "Riddle Me That" trophy / achievement. It's also required for 100% game completion and to initiate the full Knightfall Protocol. You can interrogate Riddler Informants on the streets of Gotham to unlock the collectible locations on your world map. Riddler informants are highlighted in green color. Instead of killing them you must press Triangle (PS4) / Y (XB1) to interrogate them. It's recommended that you beat the story first before collecting anything! This is to ensure that you have all the required gadgets and can access all areas. You can keep track of your progress in the Riddle Section of your world map. There you can see which objects you have found in each area. Please note that all 90 breakable objects together count only as 18 of the 243 Riddler challenges (every fifth one counts as one complete challenge). The Riddler trophies are green question mark items that you must pick up (usually locked away in rooms that require certain gadgets). The Riddles are little Puzzles and require you to scan certain objects in the world from a specific distance. The bomb rioters are thugs with bomb implants and you must shoot them with an electric charge. The breakable objects need to be destroyed with your batmobile. Overview of Collectibles by Area: Bleake Island = 37 Trophies, 11 Riddles, 3 Riot Bombers, 15 Breakable Objects Miagani Island = 38 Trophies, 10 Riddles, 3 Bomb Rioters, 15 Breakable Objects Founders' Island = 41 Trophies, 10, Riddles, 0 Bomb Rioters , 15 Breakable Objects Stagg Enterprises Airships = 21 Trophies, 3 Riddles, 0 Bomb Rioters, 15 Breakable Objects Panessa Studios = 21 Trophies, 3 Riddles, 0 Bomb Rioters, 15 Breakable Objects Arkham Knight HQ = 21 Trophies, 3 Riddles, 0 Bomb Rioters, 15 Breakable Objects All Riddler Collectibles Playlist: https://www.youtube.com/playlist?list=PLRr5L69yg_kGj9roh6fYVG49GbPKMYb20 TIMELINE: #1 - 0:05 #2 - 0:32 #3 - 0:57 #4 - 1:20 #5 - 1:56 #6 - 3:28 #7 - 4:16 #8 - 5:33 #9 - 5:58 #10 - 6:33 #11 - 6:59 #12 - 8:06 #13 - 8:25 #14 - 9:49 #15 - 10:49 #16 - 11:24 #17 - 11:44 #18 - 12:03 #19 - 12:52 #20 - 13:17 #21 - 14:34 #22 - 15:07 #23 - 15:46 #24 - 16:19 #25 - 16:57 #26 - 18:03 #27 - 18:33 #28 - 18:57 #29 - 19:18 #30 - 20:25 #31 - 21:25 #32 - 21:55 #33 - 23:28 #34 - 25:14 #35 - 26:01 #36 - 26:31 #37 - 27:10 Helped you out? Support this channel: http://www.powerpyx.com/help/ SUBSCRIBE: http://www.youtube.com/subscription_center?add_user=powerpyx ~~~~~~~~~~~~~~~~~~~~~~~~~~ Follow PowerPyx: http://www.powerpyx.com http://www.youtube.com/PowerPyx http://www.facebook.com/PowerPyx http://www.twitter.com/PowerPyx ~~~~~~~~~~~~~~~~~~~~~~~~~
Views: 1608072 PowerPyx
Create new connection with new user in Oracle SQL Developer
 
10:28
This video shows you how to create a new connection using a new user account (other than the system user account) in Oracle SQL Developer, so that you have a clean workspace without all the clutter of system tables. It is NOT a general introduction to using Oracle SQL Developer.
Views: 360008 Chitu Okoli
Querying some V dollar views
 
11:05
#Oracle #V$Views Querying V$ performance views
Views: 1059 Hemant K Chitale
Oracle DBA Justin - How to manually expire a user account's password in an Oracle database
 
04:35
How to manually expire a user account's password in an Oracle database
Views: 2523 jbleistein11
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: 7083 BhagyaRaj Katta
0608 How to Resolve Lock Conflicts
 
00:57
ORACLE
Views: 100 oracle ocm
Informatica : Resolving Lock Conflicts Between Objects
 
08:08
How will you resolve lock conflicts between informatica objects?
Views: 420 Mandar Gogate
SQL tutorial 42: How to Unlock user using SQL Developer By Manish Sharma RebellionRider
 
04:32
In this tutorial you will learn how to unlock account using SQL Developer. Using the steps used in this tutorial you can unlock any user account such as HR,OE,Scott in oracle database. Another part of user management in Oracle Database. Keep watching Enjoy SQLing Celebrating 1000 subscribers. Thanks a lot guys for all your love and support. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Website: www,Rebellionrider.com Blog: http://bit.ly/unlock-user-using-sql-developer Previous Tutorial: How to unlock user using SQL Alter User command http://youtu.be/sMqq9MSVmQo Tutorial 38: http://youtu.be/GS4udgR44Ls Links of how to create user tutorial Create user using SQL Developer http://youtu.be/GS4udgR44Ls Create user using Create user command http://youtu.be/4QbK2Y-1LZw Create user using EM http://youtu.be/zGjh-Bb3HrI ------------------------------------------------------------------------- -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the first one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at [email protected] Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 23112 Manish Sharma
Update - Locks in SQL Server - Part 4
 
07:48
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg Update (U) locks prevent a common form of deadlock. In a repeatable read or serializable transaction, the transaction reads data, acquiring a shared (S) lock on the resource (page or row), and then modifies the data, which requires lock conversion to an exclusive (X) lock. If two transactions acquire shared-mode locks on a resource and then attempt to update data concurrently, one transaction attempts the lock conversion to an exclusive (X) lock. The shared-mode-to-exclusive lock conversion must wait because the exclusive lock for one transaction is not compatible with the shared-mode lock of the other transaction; a lock wait occurs. The second transaction attempts to acquire an exclusive (X) lock for its update. Because both transactions are converting to exclusive (X) locks, and they are each waiting for the other transaction to release its shared-mode lock, a deadlock occurs. To avoid this potential deadlock problem, update (U) locks are used. Only one transaction can obtain an update (U) lock to a resource at a time. If a transaction modifies a resource, the update (U) lock is converted to an exclusive (X) lock. Isolation Level - https://youtu.be/ESET4zuNLoM Script for Active_Locks Function --------------------------------------------------- Create Function Active_locks () returns table return select Top 10000000 case dtl.request_session_id when -2 then 'orphaned distributed transaction' when -3 then 'deferred recovery transaction' else dtl.request_session_id end as spid, db_name(dtl.resource_database_id) as databasename, so.name as lockedobjectname, dtl.resource_type as lockedresource, dtl.request_mode as locktype, es.login_name as loginname, es.host_name as hostname, case tst.is_user_transaction when 0 then 'system transaction' when 1 then 'user transaction' end as user_or_system_transaction, at.name as transactionname, dtl.request_status from sys.dm_tran_locks dtl join sys.partitions sp on sp.hobt_id = dtl.resource_associated_entity_id join sys.objects so on so.object_id = sp.object_id join sys.dm_exec_sessions es on es.session_id = dtl.request_session_id join sys.dm_tran_session_transactions tst on es.session_id = tst.session_id join sys.dm_tran_active_transactions at on tst.transaction_id = at.transaction_id join sys.dm_exec_connections ec on ec.session_id = es.session_id cross apply sys.dm_exec_sql_text(ec.most_recent_sql_handle) as st where resource_database_id = db_id() order by dtl.request_session_id
Views: 578 IT Port
How to manager Oracle database locks and deadlocks with Oracle Enterprise Manager 12C
 
02:21
Video tutorials on How to manager Oracle database locks and deadlocks with Oracle Enterprise Manager 12C For more Database Administration articles and scripts go to www.aodba.com & www.verticablog.com More Articles, Scripts and How-To Papers on http://www.aodba.com
Views: 3360 AO DBA
Oracle Database 12c Tutorial  2: How To Unlock HR schema in Oracle Database 12c
 
07:18
Learn how to unlock HR user / Schema in Oracle Database 12c. Step by step procedure of unlocking the HR Schema in Oracle 12c By Manish Sharma a.k.a RebellionRider ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/how-to-unlock-hr-user-in-oracle-database-12c Previous Tutorial ► Tut 60: How To Install 12c On Windows 7: http://youtu.be/T-rCbe1MMG4 ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at [email protected] Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 85720 Manish Sharma
Destiny 2 - WOW! DREAMING CITY SECRETS!
 
13:31
Destiny 2 Forsaken! Dreaming City Secrets! Ascendant Challenge! How to Open Chests! All Supers! Spider Bounty! Power Gear! ✅ Check out Razer's awesome gear: http://rzr.to/gQsQG ✅ FOLLOW ME ON TWITTER: https://twitter.com/MoreConsole ✅ FOLLOW ME ON TWITCH: http://www.twitch.tv/moreconsole/profile ✅ FOLLOW ME ON FACEBOOK: https://www.facebook.com/pages/Destiny-Fans/590719657610614?ref=hl Check out this Destiny 2 Database for every single item in the game: https://light.gg/ #loot
Views: 425612 MoreConsole
Video Tutorial: How to Monitor OracleDB ACTIVE/INACTIVE Sessions on WebLogic?
 
05:24
Case: Monitoring ACTIVE/INACTIVE Oracle Database Sessions on WebLogic? I have prepared a short screencast tutorial about monitoring DB sessions on WebLogic. It can be extended by adding machine, inst_id fields from gv$session and gv$sqlarea. Read Blog Post: http://blog.wlsdm.com/how-to-monitor-oracledb-active-inactive-sessions-on-weblogic/ WebLogic contains lots of inbox JDBC MBeans to monitor DB transactions. The most important ones are; ActiveConnectionsCurrentCount @ JDBCDataSourceRuntimeMBean ActiveConnectionsAverageCount @ JDBCDataSourceRuntimeMBean WaitingForConnectionCurrentCount @ JDBCDataSourceRuntimeMBean ConnectionDelayTime @ JDBCDataSourceRuntimeMBean FailedReserveRequestCount @ JDBCDataSourceRuntimeMBean LeakedConnectionCount @ JDBCDataSourceRuntimeMBean
Python SQLite Tutorial: Complete Overview - Creating a Database, Table, and Running Queries
 
29:49
In this Python SQLite tutorial, we will be going over a complete introduction to the sqlite3 built-in module within Python. SQLite allows us to quickly get up and running with databases, without spinning up larger databases like MySQL or Postgres. We will be creating a database, creating a table, insert, select, update, and delete data. Let's get started... The code from this video can be found at: https://github.com/CoreyMSchafer/code_snippets/tree/master/Python-SQLite If you enjoy these videos and would like to support my channel, I would greatly appreciate any assistance through my Patreon account: https://www.patreon.com/coreyms Or a one-time contribution through PayPal: https://goo.gl/649HFY If you would like to see additional ways in which you can support the channel, you can check out my support page: http://coreyms.com/support/ Equipment I use and books I recommend: https://www.amazon.com/shop/coreyschafer You can find me on: My website - http://coreyms.com/ Facebook - https://www.facebook.com/CoreyMSchafer Twitter - https://twitter.com/CoreyMSchafer Google Plus - https://plus.google.com/+CoreySchafer44/posts Instagram - https://www.instagram.com/coreymschafer/ #Python
Views: 173939 Corey Schafer
All "Weakest Curse" Ascendant Chest Locations! - (Destiny 2 Forsaken)
 
11:27
Here's a guide for all the hidden ascendant chests in the Dreaming City during the Weakest Curse week. Once you open all of these chests, you unlock a Triumph. To access those hidden platforms you need to consume a Tincture of Queensfoil, found in world and region chests or purchased from the secret skull vendors. If you want an easy way to get Queensfoil, watch this video here: https://www.youtube.com/watch?v=FxeXQJjL--E TIMESTAMPS: Chest 1 - 0:29 Chest 2 - 1:09 Chest 3 - 2:46 Chest 4 - 3:41 Chest 5 - 4:32 Chest 6 - 5:16 Chest 7 - 6:26 Chest 8 - 7:15 Chest 9 - 8:57 Chest 10 - 10:15 This was recorded on an Xbox. Why are there so many random words below?? Youtube only allows a limited number of tags to be attached to a video. Instead of using the usual tag field, I write out the tags below. Destiny 2 d2 all hidden tincture tinctures of queensfoil ascendant plane vision buff portal taken blight challenge bounty tier ii iii i quesst step secret vendor skull ahamkara hidden lost sector wanted enemy bounty locations weekly spider vendor ghost fragments edz pathfinder's crash excavation site xii the pit widow's walk quarry drain titan nessus mercury pariah's refuge mindbender secret treasure chest key ancient's haunt methane's flush ascendant realm boss fight baron battle hive dreadnaught ship tomb ship adventure cryo cryo-pod pod heroic how to turn event trigger cabal hive boss ogre baron captain arc orb vent cell ghost fragment wanted bounty destiny redux gear solstice of heroes tricks tips oracle chest ship heroic world record upgrade black spindle hammer event map strike nightfall prestige raid whisper the worm secret quest exotic loot guide strategy how to get weapons armor legendary public mission campaign story emote new news cheese glitch easy easiest fast quick farm orbs loadout forsaken dlc collection tokens class supers level date release ninja pups element orb farm exploit mods component new news random rolls weapon baryon bough awoken ace of spades banshee slot slots how to acquire stack hoard quick easy easiest secret quest mission event public location collectible guide collections shaders buy material planet planetary glimmer legendary shards engram engrams exotic rare uncommon masterwork core tier hand cannon sniper shotgun fusion rifle catalyst armsweek cayde spider vendor variks petra dreaming city blind well last wish details gear armor year 1 year 2 delete save d1 emblem returning bow house of wolves curse of osiris dark below warmind dlc september changes patch update taken king ttk is it worth it speedrun tutorial speed everything we know you should fashion video game map pvp mode breakthrough gambit strikes scoring bounties prepare prep head start level up 600 light power damage total buff buffs best easter egg trials of the nine faction rally iron banner vendor supers warlock titan hunter is it good auto features modifiers chest dead ghosts sword grimoire triumph titles story raid boss encounters worlds first bungie destinygame huge release date time lore queen prince cutscenes game movie dismantle bright dust eververse store annual pass ornaments season 4 get early shader delete deletion august 28th update 2.0 prison bosses escape rewards blessing of light live right now 15 10 20 big changes huge amazing best ward of dawn rally barricade rift healing empowering tractor cannon special ammo xbox console blood cleaver art ace of spades awoken raid last wish
Views: 192389 Ninja Pups
How to Unlock or  Lock Oracle Sample Schema User Account after Installation
 
04:51
How to easy Unlock Oracle Sample Schema User Account after installation. For more interesting vids subscribe @ http://www.youtube.com/subscription_center?add_user=rctvids
Views: 2865 RCT vids
BluePrism - Environmental Locking || Reality & Useful
 
23:06
Hi Friends, Today we will discuss about Environmental locking I am creating a notepad and write data into notepad with two process/bots. In this case first bot should lock the file until it releases. After releasing the first process second process picks and write the data. --------------------------------------------------------------------------------- Let's prepare the data to write into notepad 1. I have a collection having initial records 20 2. I am using loop stage to get each record from collection 3. Write record data into notepad using Action stage 'Utility - File Management' 'Append text to File' U must provide the filename and content of the file Let's run and check the data 4. We got the data in notepad and I deleted it. Till Now we didn't implemented the Locking machenism. will using Action 'Environmental Locking' internal VBO is available to use it We have three operation in that Acquire Lock - to lock the file access Query lock - Check wheather the lock is held to the file or not. Release lock - to unlock the file access 5. First we need to check the file is having lock or not. we used Query lock and passed the lock name to verify it. and it returns held lock or not and comments held lock is boolean either true or false. 6. using decision stage will lock the file or wait for release lock 7. In false case we need to lock the file using Acquire lock 8. Once the Bot work is done we need to release the lock Let's test it 9. The given file has no lock at first, So, the process started with locking system after finished it will release the lock. 10. How we know the file is locked and the process is waiting to release the lock for further steps For this we will create another process or business object and copy same code into that and run the two bots and check it. So I have same logic in Object and process Let's run and check both First process taken the lock that's why second process is wait to release the lock and keep on checking it First process done it's work and released the lock So that second process started working on it See we have two sets written in notepad. Thanks for watching video
Views: 9714 Reality & Useful
Destiny 2: Tincture of Queensfoil Guide! - Secret Chests! Ascendant Challenge! | Forsaken
 
10:48
Guide to what the Tincture of Queensfoil does, and how to use it to unlock secret areas and secret chests in the Dreaming City! As well as how to complete the Ascendant Challenge Bounty! → BEST NEW FORSAKEN SUPERS: https://www.youtube.com/watch?v=HxD2mij_mb8 → SAVE ON ASTRO PRODUCTS: https://astro.family/Kackis Guide for how to use the Tincture of Queensfoil legendary consumable in the Dreaming City to unlock secret areas, secret chests, and how to complete the Ascendant Challenge Bounty from Petra to get powerful gear! --- Official Merch: TBA --- My Twitter: https://twitter.com/RickKackis --- My Twitch Channel: http://www.twitch.tv/kackishd/profile
Views: 391705 KackisHD
SQL Server DBA Tutorial 143-How to Find out How Much Memory is Allocated to SQL Server Instance
 
06:51
In this video you will learn how to find how much memory is allocated to SQL Server instances using various methods. Methods include by viewing SQL Server memory configuration via SSMS, using SQL Server dynamics system view and how to configure SQL Server Minimum (min) and Maximum (Max) memory using SQL Server Memory Configuration. Blog post link for the video with script http://sqlage.blogspot.com/2015/04/how-to-find-out-how-much-memory-is.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: 8730 TechBrothersIT
How to find all the tables with Identity Column in SQL Server Database- SQL Server Tutorial Part 45
 
09:42
SQL Server / TSQL Tutorial Scenario: How to find all the tables with Identity Column in SQL Server Database How would you find all the tables in a SQL Server Database which has identity Column? Link to scripts used in the video http://www.techbrothersit.com/2016/02/how-to-find-all-tables-with-identity.html Check out our website for Different SQL Server, MSBI tutorials and interview questions such as SQL Server Reporting Services(SSRS) Tutorial SQL Server Integration Services(SSIS) Tutorial SQL Server DBA Tutorial SQL Server / TSQL Tutorial ( Beginner to Advance) http://www.techbrothersit.com/
Views: 1835 TechBrothersIT
Missing Index Hints in SQL Server Management Studio by Amit Bansal
 
16:24
In this video, you will learn why you should not blindly follow the SSMS Missing Index Hints. Video resources including presentation, demo files, code snippets and more learning material is available on http://www.dataplatformgeeks.com/ (Join for free and access all the resources) Connect With The Speaker (Amit Bansal) -Follow on Twitter: https://twitter.com/A_Bansal -Follow on FaceBook at http://www.facebook.com/amit.r.bansal -Follow on LinkedIN: http://www.linkedin.com/in/amitbansal2010 -Facebook Page: https://www.facebook.com/AmitRSBansal/ Connect with SQLMaestros: http://sqlmaestros.com/ -http://www.twitter.com/SQLMaestros -https://www.facebook.com/SQLMaestros -Email us: [email protected] Have technical questions? Join the largest SQL group on FB www.facebook.com/groups/theSQLGeeks Our LinkedIn group https://www.linkedin.com/groups/6753546 DataPlatformGeeks (DPG) Community Join the fastest growing community of data & analytics professionals Why Join DPG? http://www.dataplatformgeeks.com/ -Attend all events hosted by DPG, including SQLMaestros Special Events -Get access to free videos, labs, magazines and host of learning resources -Download all events & conference material -Learn new skills. Sharpen existing skills -Be part of Asia’s Largest Data/Analytics Community -Opportunity to be a regional mentor & speaker at our events -Immense technical & professional development Do you know about Data Platform Summit? http://www.DPS10.com
Views: 1246 SQLMaestros
SQL script to insert into many to many table
 
14:52
Text Article http://csharp-video-tutorials.blogspot.com/2017/02/sql-script-to-insert-into-many-to-many.html Slides http://csharp-video-tutorials.blogspot.com/2017/02/sql-script-to-insert-into-many-to-many_6.html SQL Server Interview Questions and Answers text articles & slides http://csharp-video-tutorials.blogspot.com/2014/05/sql-server-interview-questions-and.html SQL Server Interview Questions and Answers playlist https://www.youtube.com/playlist?list=PL6n9fhu94yhXcztdLO7i6mdyaegC8CJwR 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 how to insert data into a table that has many-to-many relationship Create table Students ( Id int primary key identity, StudentName nvarchar(50) ) Go Create table Courses ( Id int primary key identity, CourseName nvarchar(50) ) Go Create table StudentCourses ( StudentId int not null foreign key references Students(Id), CourseId int not null foreign key references Courses(Id) ) Go Students - Id column is identity column Courses - Id column is identity column StudentCourses - StudentId and CourseId columns are foreign keys referencing Id column in Students and Courses tables As you can see, StudentCourses is a bridge table that has many to many relationship with Students and Courses tables. This means a given student can be enrolled into many courses and a given course can have many students enrolled. Below is the question asked in an interview for SQL Server Developer role. Write a SQL script to insert data into StudentCourses table. Here are the rules that your script should follow. 1. There will be 2 inputs for the script Student Name - The name of the student who wants to enroll into a course Course Name - The name of the course the student wants to enroll into 2. If the student is already in the Students table, then use that existing Student Id. If the student is not already in the Students table, then a row for that student must be inserted into the Students table, and use that new student id. 3. Along the same lines, if the course is already in the Courses table, then use that existing Course Id. If the course is not already in the Courses table, then a row for that course must be inserted into the Courses table, and use that new course id. 4. There should be no duplicate student course enrollments, i.e a given student must not be enrolled in the same course twice. For example, Tom must not be enrolled in C# course twice. Answer : To avoid duplicate student course enrollments create a composite primary key on StudentId and CourseId columns in StudentCourses table. With this composite primary key in place, if someone tries to enroll the same student in the same course again we get violation of primary key constraint error. Alter table StudentCourses Add Constraint PK_StudentCourses Primary Key Clustered (CourseId, StudentId) Here is the SQL script that inserts data into the 3 tables as expected Declare @StudentName nvarchar(50) = 'Sam' Declare @CourseName nvarchar(50) = 'SQL Server' Declare @StudentId int Declare @CourseId int -- If the student already exists, use the existing student ID Select @StudentId = Id from Students where StudentName = @StudentName -- If the course already exists, use the existing course ID Select @CourseId = Id from Courses where CourseName = @CourseName -- If the student does not exist in the Students table If (@StudentId is null) Begin -- Insert the student Insert into Students values(@StudentName) -- Get the Id of the student Select @StudentId = SCOPE_IDENTITY() End -- If the course does not exist in the Courses table If (@CourseId is null) Begin -- Insert the course Insert into Courses values(@CourseName) -- Get the Id of the course Select @CourseId = SCOPE_IDENTITY() End -- Insert StudentId & CourseId in StudentCourses table Insert into StudentCourses values(@StudentId, @CourseId) If required, we can very easily convert this into a stored procedure as shown below. Create procedure spInsertIntoStudentCourses @StudentName nvarchar(50), @CourseName nvarchar(50) as Begin Declare @StudentId int Declare @CourseId int Select @StudentId = Id from Students where StudentName = @StudentName Select @CourseId = Id from Courses where CourseName = @CourseName If (@StudentId is null) Begin Insert into Students values(@StudentName) Select @StudentId = SCOPE_IDENTITY() End If (@CourseId is null) Begin Insert into Courses values(@CourseName) Select @CourseId = SCOPE_IDENTITY() End Insert into StudentCourses values(@StudentId, @CourseId) End Use the following statement to execute the stored procedure Execute spInsertIntoStudentCourses 'Tom','C#'
Views: 89118 kudvenkat
Sequence object in SQL Server 2012
 
12:22
create sequence in sql server In this video we will discuss sequence object in SQL Server. Sequence object Introduced in SQL Server 2012 Generates sequence of numeric values in an ascending or descending order Text version of the video http://csharp-video-tutorials.blogspot.com/2015/10/sequence-object-in-sql-server-2012.html Slides http://csharp-video-tutorials.blogspot.com/2015/10/sequence-object-in-sql-server-2012_26.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 Creating the Incrementing Sequence : The following code create a Sequence object that starts with 1 and increments by 1 CREATE SEQUENCE [dbo].[SequenceObject] AS INT START WITH 1 INCREMENT BY 1 Generating the Next Sequence Value : Now we have a sequence object created. To generate the sequence value use NEXT VALUE FOR clause SELECT NEXT VALUE FOR [dbo].[SequenceObject] Output : 1 Every time you execute the above query the sequence value will be incremented by 1. I executed the above query 5 times, so the current sequence value is 5. Retrieving the current sequence value : If you want to see what the current Sequence value before generating the next, use sys.sequences SELECT * FROM sys.sequences WHERE name = 'SequenceObject' Alter the Sequence object to reset the sequence value : ALTER SEQUENCE [SequenceObject] RESTART WITH 1 Select the next sequence value to make sure the value starts from 1 SELECT NEXT VALUE FOR [dbo].[SequenceObject] Using sequence value in an INSERT query : CREATE TABLE Employees ( Id INT PRIMARY KEY, Name NVARCHAR(50), Gender NVARCHAR(10) ) -- Generate and insert Sequence values INSERT INTO Employees VALUES (NEXT VALUE for [dbo].[SequenceObject], 'Ben', 'Male') INSERT INTO Employees VALUES (NEXT VALUE for [dbo].[SequenceObject], 'Sara', 'Female') -- Select the data from the table SELECT * FROM Employees Creating the decrementing Sequence : The following code create a Sequence object that starts with 100 and decrements by 1 CREATE SEQUENCE [dbo].[SequenceObject] AS INT START WITH 100 INCREMENT BY -1 Specifying MIN and MAX values for the sequence : Use the MINVALUE and MAXVALUE arguments to specify the MIN and MAX values respectively. Step 1 : Create the Sequence object CREATE SEQUENCE [dbo].[SequenceObject] START WITH 100 INCREMENT BY 10 MINVALUE 100 MAXVALUE 150 Step 2 : Retrieve the next sequence value. The sequence value starts at 100. Every time we call NEXT VALUE, the value will be incremented by 10. SELECT NEXT VALUE FOR [dbo].[SequenceObject] If you call NEXT VALUE, when the value reaches 150 (MAXVALUE), you will get the following error The sequence object 'SequenceObject' has reached its minimum or maximum value. Restart the sequence object to allow new values to be generated. Recycling Sequence values : When the sequence object has reached it's maximum value, and if you want to restart from the minimum value, set CYCLE option ALTER SEQUENCE [dbo].[SequenceObject] INCREMENT BY 10 MINVALUE 100 MAXVALUE 150 CYCLE At this point, whe the sequence object has reached it's maximum value, and if you ask for the NEXT VALUE, sequence object starts from the minimum value again which in this case is 100. To improve performance, the Sequence object values can be cached using the CACHE option. When the values are cached they are read from the memory instead of from the disk, which improves the performance. When the cache option is specified you can also specify the size of th cache , that is the number of values to cache. The following example, creates the sequence object with 10 values cached. When the 11th value is requested, the next 10 values will be cached again. CREATE SEQUENCE [dbo].[SequenceObject] START WITH 1 INCREMENT BY 1 CACHE 10 Using SQL Server Graphical User Interface (GUI) to create the sequence object : 1. Expand the database folder 2. Expand Programmability folder 3. Right click on Sequences folder 4. Select New Sequence Next video : Difference between SEQUENCE and IDENTITY in SQL Server
Views: 36373 kudvenkat
Configuring the Oracle Social Network Desktop Client (Release 10)
 
01:10
Learn how to download and configure the Oracle Social Network Desktop Client. ================================= For more information, see http://www.oracle.com/goto/oll 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.
Oracle Database Tutorial-W1-10-Implementing Oracle Database Security
 
12:32
Welcome to www.TrainerBD.com ‘s Free Oracle Video Tutorial download section. Here you will find a lot of free Oracle tutorial videos. e.g. Oracle Database 10g Tutorial, Oracle DBA 11g Tutorial, Oracle SQL Tutorial, Oracle PLSQL Tutorial, Oracle Forms 6i Tutorial, Oracle Forms Developer Tutorial, Oracle Fusion Middleware Tutorial, Oracle Apex Tutorial etc. Other training institutes will charge a lot money for this training. But www.TrainerBD.com offers this Oracle Training In Bangladesh for 100% free through these Oracle Tutorial Videos. Do you want to free download the Oracle Video Tutorials? Click http://goo.gl/kcYHWk These Oracle Tutorial Videos will teach you skills that directly align with real-life IT job. It shows the hands-on approach to the Oracle database, Oracle SQL, Oracle PLSQL, Oracle Developer Suite and Oracle 11g Fusion Middleware. You will learn Oracle SQL, Oracle PLSQL, Oracle Developer Suite FORMS, REPORTS and Oracle Database Administration, Oracle installation tricks with Oracle Database performance tuning in these Oracle Tutorial Videos series. You’ll discover professional tips and techniques for brilliant and distinctive software as an Oracle Developer and/or Oracle Database Administrator. Here you will learn about Oracle Forms 6i, Oracle Developer Suite 10g along with Oracle 11g Fusion Middleware and the migration process of Oracle Forms and Reports. At the end of these Oracle Tutorial videos a real life project will be completed in Oracle Forms Developer Suite. Later the whole project will be migrated to Oracle 11g Fusion Middleware. During this oracle Tutorial Videos In bangla, Muhammad Abdullah Al Noor (http://goo.gl/DUmKSk) (Skype: ensoftbd, Dial: 017 9072 1177) used some practice sheets in pdf. This pdf(s) will help you keep pace with his on screen actions and verbal instructions. Click here and submit this form: https://goo.gl/uUBj5f to get the pdf(s).   If you have problem downloading the Free Oracle tutorial videos where you can download 100% free “Oracle Training In Bangladesh” sessions, Please go through the following steps: 1- Click here : http://en.savefrom.net/?rmode=false 2- Copy and paste the Youtube video url in the Box. 3- Click Download. 4- Click MP4 480p. for Optimum Resolution Video. Download mpcstar, If you have problem viewing the Free Oracle Tutorial Videos In Bangla for beginners. You can download MPCSTAR by clicking here: http://www.mpcstar.com/download.php TrainerBD.com offer the most affordable Oracle Training in Bangladesh. Click: http://goo.gl/OYI9lF to learn Oracle Made Easy. Oracle Tutorial Videos for Beginners.Join this Facebook Group to get Life time support in Oracle : https://goo.gl/uUBj5f Get Oracle E-books in pdf by submitting this form: https://goo.gl/uUBj5f To Learn Oracle From TrainerBD.com Click Here : http://goo.gl/7pJjhV Oracle Tutorial Group (Facebook):- https://www.facebook.com/groups/Oracletutorialvideos https://www.facebook.com/groups/oracletutorialtechtunes TrainerBD.com Offers the most affordable (BDT. 15,000/-) Oracle Training in Mirpur, Dhaka, Bangladesh. Learn Oracle, Be an Oracle Developer and/or Database Administrator. Click http://goo.gl/OYI9lF to learn Oracle. Search Terms:- oracle video tutorial free download oracle applications tutorial oracle 11g tutorial free download oracle sql tutorial oracle 10g tutorial oracle form builder tutorial oracle forms 10g tutorial oracle 10g tutorial for beginners oracle database 10g tutorial sql oracle oracle for beginners oracle 10g tutorial oracle tutorials for beginners oracle dba tutorial for beginners pdf oracle forms developer tutorial toad for oracle tutorial oracle fusion middleware tutorial oracle forms 6i tutorial oracle sql tutorial oracle 11g tutorial oracle tutorial pdf free download oracle dba tutorial for beginners oracle application express tutorial oracle tutorial for beginners oracle database tutorial oracle apex tutorial oracle sql tutorial sql tutorial oracle 11g tutorial oracle 10g tutorial oracle dba tutorial oracle tutorial for beginners
Views: 253 TrainerBD .com
Intent - Locks in SQL Server - Part 6
 
06:10
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg The Database Engine uses intent locks to protect placing a shared (S) lock or exclusive (X) lock on a resource lower in the lock hierarchy. Intent locks are named intent locks because they are acquired before a lock at the lower level, and therefore signal intent to place locks at a lower level. Intent locks serve two purposes: --------------------------------------------------- a) To prevent other transactions from modifying the higher-level resource in a way that would invalidate the lock at the lower level. b) To improve the efficiency of the Database Engine in detecting lock conflicts at the higher level of granularity. if a transaction has an exclusive lock on a row, SQL Server places an intent lock on the table. When another transaction requests a lock on a row in the table, SQL Server knows to check the rows to see if they have locks. If a table does not have intent lock, it can issue the requested lock without checking each row for a lock Isolation Level - https://youtu.be/ESET4zuNLoM Script for Active_Locks Function --------------------------------------------------- Create Function Active_locks () returns table return select Top 10000000 case dtl.request_session_id when -2 then 'orphaned distributed transaction' when -3 then 'deferred recovery transaction' else dtl.request_session_id end as spid, db_name(dtl.resource_database_id) as databasename, so.name as lockedobjectname, dtl.resource_type as lockedresource, dtl.request_mode as locktype, es.login_name as loginname, es.host_name as hostname, case tst.is_user_transaction when 0 then 'system transaction' when 1 then 'user transaction' end as user_or_system_transaction, at.name as transactionname, dtl.request_status from sys.dm_tran_locks dtl join sys.partitions sp on sp.hobt_id = dtl.resource_associated_entity_id join sys.objects so on so.object_id = sp.object_id join sys.dm_exec_sessions es on es.session_id = dtl.request_session_id join sys.dm_tran_session_transactions tst on es.session_id = tst.session_id join sys.dm_tran_active_transactions at on tst.transaction_id = at.transaction_id join sys.dm_exec_connections ec on ec.session_id = es.session_id cross apply sys.dm_exec_sql_text(ec.most_recent_sql_handle) as st where resource_database_id = db_id() order by dtl.request_session_id
Views: 738 IT Port
ORA 28002 - The password will expire within 7 days.[PeopleSoft Troubleshoot #3]
 
05:07
! In this video we will discuss about an error message - “ORA-28002 The password will expire within 7 days. Cannot logon to the database” SQL queries discussed in the video: Select account_status, profile from dba_users where username = 'PEOPLE'; Select * from dba_profiles where profile = 'DEFAULT' and resource_name = 'PASSWORD_LIFE_TIME'; Alter profile Default Limit Password_Life_Time UNLIMITED; Alter User People Identified by peop1e; Alter user SYSADM Identified by Fscm1234; Please visit following link for more troubleshoot blogs for PeopleSoft: http://peoplesofttutorial.com/blog/
Lock Manager
 
03:21
Locks are placed on certain objects in Savance Enterprise to prevent multiple users from editing at the same time. This training video covers how these locks are managed.
Views: 303 SavanceEnterprise
Difference between sequence and identity in SQL Server
 
05:29
sql server identity vs sequence In this video we will discuss the difference between SEQUENCE and IDENTITY in SQL Server This is continuation to Part 134. Please watch Part 134 from SQL Server tutorial before proceeding. Sequence object is similar to the Identity property, in the sense that it generates sequence of numeric values in an ascending order just like the identity property. However there are several differences between the 2 which we will discuss in this video. Identity property is a table column property meaning it is tied to the table, where as the sequence is a user-defined database object and is not tied to any specific table meaning it's value can be shared by multiple tables. Example : Identity property tied to the Id column of the Employees table. CREATE TABLE Employees ( Id INT PRIMARY KEY IDENTITY(1,1), Name NVARCHAR(50), Gender NVARCHAR(10) ) Example : Sequence object not tied to any specific table CREATE SEQUENCE [dbo].[SequenceObject] AS INT START WITH 1 INCREMENT BY 1 This means the above sequence object can be used with any table. Example : Sharing sequence object value with multiple tables. Step 1 : Create Customers and Users tables CREATE TABLE Customers ( Id INT PRIMARY KEY, Name NVARCHAR(50), Gender NVARCHAR(10) ) GO CREATE TABLE Users ( Id INT PRIMARY KEY, Name NVARCHAR(50), Gender NVARCHAR(10) ) GO Step 2 : Insert 2 rows into Customers table and 3 rows into Users table. Notice the same sequence object is generating the ID values for both the tables. INSERT INTO Customers VALUES (NEXT VALUE for [dbo].[SequenceObject], 'Ben', 'Male') INSERT INTO Customers VALUES (NEXT VALUE for [dbo].[SequenceObject], 'Sara', 'Female') INSERT INTO Users VALUES (NEXT VALUE for [dbo].[SequenceObject], 'Tom', 'Male') INSERT INTO Users VALUES (NEXT VALUE for [dbo].[SequenceObject], 'Pam', 'Female') INSERT INTO Users VALUES (NEXT VALUE for [dbo].[SequenceObject], 'David', 'Male') GO Step 3 : Query the tables SELECT * FROM Customers SELECT * FROM Users GO Output : Notice the same sequence object has generated the values for ID columns in both the tables To generate the next identity value, a row has to be inserted into the table, where as with sequence object there is no need to insert a row into the table to generate the next sequence value. You can use NEXT VALUE FOR clause to generate the next sequence value. Example : Generating Identity value by inserting a row into the table INSERT INTO Employees VALUES ('Todd', 'Male') Example : Generating the next sequence value using NEXT VALUE FOR clause. SELECT NEXT VALUE FOR [dbo].[SequenceObject] Maximum value for the identity property cannot be specified. The maximum value will be the maximum value of the correspoding column data type. With the sequence object you can use the MAXVALUE option to specify the maximum value. If the MAXVALUE option is not specified for the sequence object, then the maximum value will be the maximum value of it's data type. Example : Specifying maximum value for the sequence object using the MAXVALUE option CREATE SEQUENCE [dbo].[SequenceObject] START WITH 1 INCREMENT BY 1 MAXVALUE 5 CYCLE option of the Sequence object can be used to specify whether the sequence should restart automatically when the max value (for incrementing sequence object) or min value (for decrementing sequence object) is reached, where as with the Identity property we don't have any such option to automatically restart the identity values. Example : Specifying the CYCLE option of the Sequence object, so the sequence will restart automatically when the max value is exceeded CREATE SEQUENCE [dbo].[SequenceObject] START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 5 CYCLE Text version of the video http://csharp-video-tutorials.blogspot.com/2015/10/difference-between-sequence-and.html Slides http://csharp-video-tutorials.blogspot.com/2015/10/difference-between-sequence-and_27.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: 35160 kudvenkat
Exclusive - Locks in SQL Server - Part 5
 
05:50
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg Exclusive (X) locks prevent access to a resource by concurrent transactions. With an exclusive (X) lock, no other transactions can modify data Repeatable read and Higher Isolation level transactions can’t read that locked data and Rest of the levels can read. No Lock hints Can read this data. Isolation Level - https://youtu.be/ESET4zuNLoM Script for Active_Locks Function --------------------------------------------------- Create Function Active_locks () returns table return select Top 10000000 case dtl.request_session_id when -2 then 'orphaned distributed transaction' when -3 then 'deferred recovery transaction' else dtl.request_session_id end as spid, db_name(dtl.resource_database_id) as databasename, so.name as lockedobjectname, dtl.resource_type as lockedresource, dtl.request_mode as locktype, es.login_name as loginname, es.host_name as hostname, case tst.is_user_transaction when 0 then 'system transaction' when 1 then 'user transaction' end as user_or_system_transaction, at.name as transactionname, dtl.request_status from sys.dm_tran_locks dtl join sys.partitions sp on sp.hobt_id = dtl.resource_associated_entity_id join sys.objects so on so.object_id = sp.object_id join sys.dm_exec_sessions es on es.session_id = dtl.request_session_id join sys.dm_tran_session_transactions tst on es.session_id = tst.session_id join sys.dm_tran_active_transactions at on tst.transaction_id = at.transaction_id join sys.dm_exec_connections ec on ec.session_id = es.session_id cross apply sys.dm_exec_sql_text(ec.most_recent_sql_handle) as st where resource_database_id = db_id() order by dtl.request_session_id
Views: 318 IT Port
sql lock
 
01:00:44
Views: 73 man-han Tsai
BluePrism - Login Agent || Reality & Useful
 
12:32
Hi Friends, Now we will discuss about Login Agent ----------------------------------------------------------------------- It referes the Machine operations like Lock the screen, reading machine name, and checking the machine is logged in or is locked few more operations are existed in the Login Agent. ----------------------------------------------------------------------- Download Link: Login Agent VBO http://jmp.sh/9n2eLmH We will go one by one 1. I created a Business Object and we will check is logged in or is locked the screen using Login Agent. I got the True for is logged, means I am logged into the account in my machine. 2. will check for screen lock Obviously the screen is not locked that's why we got False. Let's try to lock the screen Ya, The system is locked, may be you cannot see because it depends on recording software. You try it will work. 3. We will get the username or machine name using Get Credentials Name ohh, I got internal exception saying that "Internal : Environment variable not defined" Because the Action 'Get Credential Name' expecting the environment variable to read the name. let's create the expected environement variable and named with 'Login Format String' and value for this variable is {0} I am going to create this variable in environment variables along with the value and the type is Text. Now we will run the bot. Wow, I got the name of login account what else we have we have few more change password and logout Try from your side these will work. No additional configurations required for those Change Password and Logout. Thank You for watching Video
Views: 6903 Reality & Useful
Hide database window, Hide menu, Disable shortcut menu, Disable Special Keys : MS Access
 
08:10
Make database more secure by hiding database window, hiding menu, disabling shortcut menu, disabling Access Special Keys see related How To: http://www.iaccessworld.com/hide-navigation-pane-full-menu-shortcut-menu/
Views: 134200 Nana Sara
SQL Server DBA Tutorial 88-Detailed Overview of Model Database in SQL Server
 
18:48
In this video you will learn about Model DataBase. Model Database is system Database in SQL Server that is used as templdate when we create New Database in SQL Server. In this video you will learn following Items 1--How to Create Objects such as Tables, Views, Functions those we want to Create By default in any newly Create Database by using Model Database 2--What are the restrictions on Model Database 3--What Settings/Configurations are used in TempDB from Model Database 4--Does Create Database Statement take all the settings/Configurations of Model Database 5--Does GUI ( Graphical User Interface) copy the setting from Model for New Database Create Process Blog post link for the video: http://sqlage.blogspot.com/2015/03/detailed-overview-of-model-database-in.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: 6561 TechBrothersIT
Oracle GoldenGate - Part 6
 
26:08
In this video, you will learn Oracle GoldenGate Initial Load concepts. To download complete set of videos, visit http://www.metamanager.com
Views: 4379 metamanager
MSSQL - Understanding Isolation Level By Example (Serializable)
 
08:46
Example SQL Statements below used in the video, you can Copy and Paste for Transaction Isolation Level of Serializable, Read Committed, Read Uncommitted, Repeatable Read --===================================== -- Windows/Session #1 --===================================== SELECT @@SPID IF EXISTS (SELECT 1 FROM sys.tables WHERE name = 'SampleTable') DROP TABLE SampleTable CREATE TABLE [SampleTable] ( [Id] [int] IDENTITY(1,1) NOT NULL, [Name] [varchar](100) NULL, [Value] [varchar](100) NULL, [DateChanged] [datetime] DEFAULT(GETDATE()) NULL, CONSTRAINT [PK_SampleTable] PRIMARY KEY CLUSTERED ([Id] ASC) ) INSERT INTO SampleTable(Name, Value) SELECT 'Name1', 'Value1' UNION ALL SELECT 'Name2', 'Value2' UNION ALL SELECT 'Name3', 'Value3' SELECT * FROM SampleTable BEGIN TRAN INSERT INTO SampleTable(Name, Value) VALUES('Name4', 'Value4') --UPDATE SampleTable SET Name = Name + Name --UPDATE SampleTable SET Name = Name + Name WHERE Name = 'Name1' UPDATE SampleTable SET Name = Name + Name WHERE ID = 2 DELETE FROM SampleTable WHERE ID = 4 WAITFOR DELAY '00:0:10' COMMIT TRAN --===================================== -- Windows/Session #2 --===================================== --------------------------------------------------- -- This window/session is default READ COMMITTED -- --------------------------------------------------- SELECT @@SPID BEGIN TRAN SELECT * FROM SampleTable WAITFOR DELAY '00:00:10' SELECT * FROM SampleTable WAITFOR DELAY '00:00:10' SELECT * FROM SampleTable ROLLBACK SELECT b.name, c.name, a.* FROM sys.dm_tran_locks a INNER JOIN sys.databases b ON a.resource_database_id = database_id INNER JOIN sys.objects c ON a.resource_associated_entity_id = object_id --===================================== -- Windows/Session #3 --===================================== ----------------------------------------------------- -- This window/session is REPEATABLE READ -- ----------------------------------------------------- SELECT @@SPID SET TRANSACTION ISOLATION LEVEL REPEATABLE READ BEGIN TRAN SELECT * FROM SampleTable WAITFOR DELAY '00:00:10' SELECT * FROM SampleTable WAITFOR DELAY '00:00:10' SELECT * FROM SampleTable COMMIT TRAN --===================================== -- Windows/Session #4 --===================================== ----------------------------------------------------- -- This window/session is SERIALIZABLE -- ----------------------------------------------------- SELECT @@SPID SET TRANSACTION ISOLATION LEVEL SERIALIZABLE BEGIN TRAN SELECT * FROM SampleTable WAITFOR DELAY '00:00:10' SELECT * FROM SampleTable WAITFOR DELAY '00:00:10' SELECT * FROM SampleTable COMMIT TRAN
Views: 13447 CodeCowboyOrg
GOD OF WAR 1 Walkthrough - Complete Game
 
05:21:13
God of War Gameplay Walkthrough Complete Game for Playstation 2 , Playstation 3 This God of War Gameplay Walkthrough will also include a full Review and the Ending. GOD-OF-WAR 1Remastered►http://bit.ly/2S8OTEN SUBSCRIBE►http://bit.ly/291hmppA-New-Beginning Twitter ►http://bit.ly/293LdPtA-New-Beginning Facebook ►http://bit.ly/292t8QRA-New-Beginning Gameplay : God of War is a third-person single player video game viewed from a fixed camera perspective. The player controls the character Kratos in combo-based combat, platforming, and puzzle game elements, and battles foes who primarily stem from Greek mythology, including undead soldiers, harpies, minotaurs, Medusa and her Gorgons, cyclopes, wraiths, Sirens, satyrs, centaurs, cerberuses, and boss opponents—the Hydra and a giant minotaur known as Pandora's Guardian. Platforming elements require the player to climb walls and ladders, jump across chasms, swing on ropes, and balance across beams to proceed through sections of the game. Some puzzles are simple, such as moving a box so that the player can use it as a jumping-off point to access a pathway unreachable with normal jumping, but others are more complex, such as finding several items across different areas of the game to unlock one door. Throughout the game world, the player finds chests colored green, blue, or red, and each chest contains orbs of the corresponding color. Green orbs replenish the player's health, blue orbs replenish magic allowing further usage, and red orbs provide experience for upgrading weapons and magic—allowing new, more powerful attacks—and replenishing the Rage meter, which, if full, allows for the usage of the Rage of the Gods ability. Red orbs are also collected by killing foes and destroying certain inanimate objects. The player can also find Gorgon Eyes and Phoenix Feathers in unmarked chests. The Eyes and Feathers increase the length of the Health and Magic Meters, respectively; finding eighteen of an item maximizes a meter and in turn, the player's power. Characters include: The protagonist of the game is Kratos (voiced by Terrence C. Carson), a Spartan warrior who serves the Olympian Gods. Other characters include a host of Greek gods, such as Athena (Carole Ruggier), the Goddess of Wisdom and Kratos' ally and mentor; Ares (Steven Blum), the God of War and main antagonist; Poseidon (Fred Tatasciore), the God of the Sea; Aphrodite (Carole Ruggier), the Goddess of Love and Sexuality; Zeus (Paul Eiding), the King of the Gods; Artemis (Claudia Black), the Goddess of the Hunt; and Hades (Nolan North), the God of the Underworld. Several of the gods aid Kratos with magic or weapons. Minor characters include the Oracle of Athens (Susan Blakeslee), the gravedigger (Paul Eiding), the body burner (Christopher Corey Smith), and the boat captain (Keith Ferguson). Other characters appear in flashbacks, including Kratos' wife Lysandra (Gwendoline Yeo), his child Calliope, the Barbarian King, and a Village Oracle (Susan Blakeslee). The game is narrated by Linda Hunt. If you enjoyed the video, please hit the LIKE button! It really helps
Views: 7381059 theGamerKratos
ASMR │Rainbow Glitter │Make-Up Show & Tell │Happy Pride 🌈
 
17:02
Hello everyone!!! It's Pride Month! I am currently in California at VidCon and so I am unable to attend some of the Pride events in my hometown in Canada. Producing this video is a way to celebrate it! For those of you celebrating it, I send you so much love and glitter! And where are all my bisexuals people at?! I've been wanting to do this video for a very long time but the timing was always off. Please be advised that this video is not sponsored at all. In addition, when it comes to special effects makeup or brands that you normally wouldn't find at places like Sephora, it's harder to find out if they're cruelty free - I believe this brand does not test on animals. As previously mentioned in other of my makeup videos, I try my best to update my information, but always double check to be sure. :) Now let's talk a bit about the technical aspects of the video. I've recently acquired a ring light and this is my first video using it. What do you think? Does it make the video look sharper? I am still adjusting it, and this is why some of the camera angles were different - I was trying to maximize the space of the Pink Room lol. And last but not least, regarding skin undertones, I am sharing with you again, Justine Leconte's video on the subject. She explains it so well! https://www.youtube.com/watch?v=hw_ie... Thank you, Somni Rosae 🌹 ===================================================== www.somnirosae.com ===================================================== Find more of my ASMR work available on iTunes, Spotify and other audio platforms ===================================================== SOCIAL MEDIA Instagram https://www.instagram.com/somnirosae/ Twitter https://twitter.com/somniasmr?lang=en ===================================================== SOMNI FEATURED IN... Avalable on iTunes as well Twenty Thousand Hertz https://www.20k.org/episodes/asmr Skincare Talk Radio "ASMR & Skin Health" http://skincaretalkradio.cieloscent.c... La Noche de las Luciérnagas (In Spanish) (Night of the Fireflies) https://www.ivoox.com/noche-luciernag... ===================================================== CHANNEL INTRO https://videohive.net/item/particle-d... Please note the licence does not include the rose, which is a picture taken by the asmrtist. ===================================================== MUSIC Chris Zabrieski, Cylinder One. Used under the Attribution Licence http://freemusicarchive.org/music/Chr... ===================================================== Although the volume on the ads can’t be controlled by the creator, ads can support content creators. You may skip them but please consider before blocking them entirely 🙏 ===================================================== LEARNING SPANISH? Check out my playlist, “Castellano Corner”, which contains videos from other ASMRtists, Vloggers and more whose native language is Spanish and show off the beauty of the language. They’ll take your Spanish to the next level! https://www.youtube.com/watch?v=4Sk6P... ===================================================== WHAT IS ASMR? https://en.wikipedia.org/wiki/Autonom... ===================================================== NON-ENGLISH RESOURES ABOUT ASMR https://asmruniversity.com/2018/01/21... 💜 #asmr
Views: 23648 Somni Rosae
Lock and unlock a shared resource: Information design tool 4.x
 
03:02
Visit us at http://www.sap.com/LearnBI to view our full catalog of interactive SAP BusinessObjects BI Suite tutorials.
Views: 3697 SAP Analytics
SQL Server DBA Tutorial 115-How to Create Linked server in SQL Server
 
13:46
In this video you will learn how to create Linked Server in SQL Server using SQL Server Management studio as well as T-SQL Script. It also explains best practices of creating Linked servers in SQL Server, when it is best idea to create linked server, requirement of remote synonyms to have Linked server created. Security best practices of Linked server and how to create linked server using other providers such as ODBC, SSAS and SQL Server client 11.0. blog post link for this video: http://sqlage.blogspot.com/2015/03/how-to-create-linked-server-in-sql.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: 74958 TechBrothersIT
Identifying and Fixing Performance Problems using Execution Plans
 
01:07:21
Check Out Our Performance Tuning Blog - http://blog.pragmaticworks.com/topic/performance-tuning This session will demonstrate how SQL Server execution plans can be used to identify problems with the database design, or the TSQL code, and address those problems. The session takes the user through various common issues such as poor or missing indexes, badly written code and generally bad query performance, demonstrating how to identify the issues involved using execution plans. The session will then demonstrate different methods for addressing the issues and show how the fixed query’s execution plans differ. Multiple methods for accessing execution plans including graphical, DMV’s, and trace events are demonstrated. All this is meant to lay a foundation for a general troubleshooting approach to empower the attendee to make their own queries run faster and more consistently.
Views: 213 Pragmatic Works
Install SQL Developer and unlock the oracle Hr Schema
 
06:36
Shows how to Install and configure SQL developer, unlock the Hr schema and alter oracle database privileges/roles
Views: 8863 Victor
Bounty "Challenge: Secret Secrets" - How To Complete (Week 1) [Destiny 2 Forsaken]
 
02:15
Destiny 2 Forsaken - Challenge Secret Secrets Bounty Completion Guide. Just a quick video showing how to complete this bounty from Petra and the hidden objectives. -THIS CHANGES DEPENDING ON THE CURSE WEEK- See links below for each one: Curse Weakest: https://www.youtube.com/watch?v=F_j3wgX4rJk Curse Stronger: https://www.youtube.com/watch?v=-SqLbqxBwVI Curse Strongest: https://www.youtube.com/watch?v=PWPMlAazBeM You need the Tincture of Queensfoil for the Ascendance buff, and you then need to loot two of the chests that are visible while Ascendant. There are multiple different chests in the map, these were just two close to the initial Dreaming City spawn. Region chests also count if you have looted them already. Challenge: Secret Secrets "The Dreaming city is rich with secrets. Seek them out and be enlightened." - Techeun Kalli. Hidden objectives completed 0/2 Tincture of Queensfoil Vendor / Trade-in Location: https://www.youtube.com/watch?v=zpOqkIqcCxA My PC setup is nothing too crazy at all, but the specs are: i7-8700, GTX 1070, 16GB DDR4-3000 Ram, 256GB SSD, 2TB HDD. Allows me to run max settings at constant 60FPS while recording. Which is about all I need for now :) ================== LINKS/SOCIAL: ================== YouTube: https://www.youtube.com/esoterickk Twitter: https://twitter.com/esoterickk Twitch: https://www.twitch.tv/esoterickk1 Patreon: https://www.patreon.com/esoterickk Donations: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=6ZEYB3DRHKK22 (Disclaimer: Any funds received as a donation or tip are not in exchange for goods or services. They will provide no additional perks and are purely as a means to help support the channel. I am very thankful for your viewership and I do appreciate if you do decide to tip, but it is by no means required. Before tipping or donating, please consider that your tips/donations are non-refundable).
Views: 184685 Esoterickk