SQL DBA Support by T. Amit Vaid S. - Knowledge Centre for DBAs

Pages

  • Home
  • SQL Performance
  • About Us
  • TempDB
  • © Copyright
  • Memory
  • QUERIES BANQ
  • Missing Notification
  • Contact Me

Wednesday, April 12, 2023

MS-SQL Server - Gain Your Knowledge on JRH

Gain Your Knowledge on JRH


Joins


https://learn.microsoft.com/en-us/sql/relational-databases/performance/joins?view=sql-server-ver16


{Table Hints - RowLock &

Holdlock}


https://learn.microsoft.com/en-us/sql/t-sql/queries/hints-transact-sql-query?view=sql-server-ver16



Best Regards



T. Amit Vaid S.


Posted by Anonymous at 11:45 AM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Joins, table Hints

No comments:

Post a Comment

Newer Post Older Post Home
View mobile version
Subscribe to: Post Comments (Atom)

Favorite Blogs & Sites

  • SQL DBA

DBA Projects

  • Avid Technology
  • BHP Billiton
  • Dish TV
  • Driscolls
  • Gartner
  • GE Money
  • Lawrence General
  • NBC Universal
  • Sinclair Knight Merz
  • State Street
  • Telstra
  • Torus

SQL DBA Support - Knowledge Centre for DBAs

Loading...

Contact Form

Name

Email *

Message *

Featured Post

MS-SQL Server - SANSQL And AD

Search This Blog

Popular Posts

  • MS-SQL Server - मोर यानि ज्यादा
  • MS-SQL Server - मोर यानि ज्यादा (Part II)
  • MS-SQL Server - Visiting Error Logs
  • MS-SQL Server - Modifying Scheduled Jobs
  • MS-SQL Server - MIG On Idea
  • MS-SQL Server - General Discussion
  • MS-SQL Server - General Discussion (Volume II)
  • MS-SQL Server - Divides one number by another, Physical Joins, SQLSORT_NORMMUTEX and Cycle error log
  • MS-SQL Server - Topics & Waittypes
  • MS-SQL Server - Topics

About Author

This blog is a journey of SQL Server Professional.


I usually work as a DBA and have been working for performance tuning and high availability features. You can find some of the articles from my own personal real time experience.

Regards,
T. Amit Vaid S.
Average Study 5th Class from Govt. School, New Delhi
(not Pandit by Profession/Religion)
NickName Goldy
Home Page

Eg. Calculation of DB Size If 55000 KB = 53.710 MB then If 6000 MB = 5.859 GB then

Written more than 50 DBA Scripts.

Followers

Blog Archive

  • ►  2025 (8)
    • ►  January (8)
  • ►  2024 (40)
    • ►  December (6)
    • ►  November (2)
    • ►  October (3)
    • ►  September (6)
    • ►  August (4)
    • ►  July (4)
    • ►  June (5)
    • ►  May (4)
    • ►  April (2)
    • ►  March (1)
    • ►  February (2)
    • ►  January (1)
  • ▼  2023 (315)
    • ►  November (3)
    • ►  October (12)
    • ►  September (9)
    • ►  August (1)
    • ►  July (9)
    • ►  June (30)
    • ►  May (70)
    • ▼  April (102)
      • MS-SQL Server - Azure Guidance for Sarbanes Oxley ...
      • MS-SQL Server - DBA Role to Monitor
      • MS-SQL Server - Make DB Read Only
      • MS-SQL Server - Alter Index {MaxDOP}
      • MS-SQL Server - Most Incoming Calls
      • MS-SQL Server - Ansi_Warnings
      • MS-SQL Server - विचार
      • MS-SQL Server - A Satisfied Client
      • MS-SQL Server - Core Basic Ornaments of Enterprise...
      • MS-SQL Server - Shrink, Pivot, Maintenance & Mark
      • MS-SQL Server - Generate GUID on Insert
      • MS-SQL Server - विचार
      • MS-SQL Server - विचार
      • MS-SQL Server - विचार का शिष्टाचार
      • MS- SQL Server - Tail-Log Backup
      • MS-SQL Server - CHIP-CAL (A Desired Configuration)
      • MS-SQL Server - Advertisement
      • MS-SQL Server - Restore & Opinion
      • MS-SQL Server - Technical Agenda
      • MS-SQL Server - Sharding & Character
      • MS-SQL Server - Color Illustration
      • MS-SQL Server - Jor Jemry & Joins
      • MS-SQL Server - A Core Points of SQL Azure
      • MS-SQL Server - चित्र (A Design from Architecture)
      • MS-SQL Server - SSIS एक तारा (Part 2)
      • MS-SQL Server - Backup Retention Policy
      • MS-SQL Server - Ghada (A Kalash, Full of Unique Th...
      • MS-SQL Server - विचार
      • MS-SQL Server - Import Export, OEM & CREAM Alerts
      • MS-SQL Server - An English Vision
      • MS-SQL Server - DEV, TRI & Purchase
      • MS-SQL Server - Dhai (A Numeric 2.5)
      • MS-SQL Server - Fantastic Old Driver
      • MS-SQL Server - OLE DB
      • MS-SQL Server - ReOrganize
      • MS-SQL Server - MUSHK & OLTP
      • MS-SQL Server - Business Intelligence Tips (PEARL,...
      • MS-SQL Server - विश्वास
      • MS-SQL Server - Cost Base of Editions - Aim of Art...
      • MS-SQL Server - SSIS एक तारा
      • MS-SQL Server - Should-Kani
      • MS-SQL Server - Best Seller Industry
      • MS-SQL Server - See Bak & Diff
      • MS-SQL Server - DNS Server
      • MS-SQL Server - अनदेखा (एक जुनून)
      • MS-SQL Server - MIG On Idea
      • MS-SQL Server - धाक (A REPUTATION)
      • MS-SQL Server - UJAJWA & Logs
      • MS-SQL Server - Dense Rank
      • MS-SQL Server - Truncate, Delete & TAT
      • MS-SQL Server - क्रम & छोर of Database
      • MS-SQL Server - Lokyash and EndPoints
      • MS-SQL Server - A Basic Side
      • MS-SQL Server - SHLIVA, Slab & Ultimate Pivot
      • MS-SQL Server - DT-CITL & परिदृश्य
      • MS-SQL Server - Memory Leak / High & Cu-Updates
      • MS-SQL Server - GoFrag 'Resume Performance'
      • MS-SQL Server - Article for Utility and Unique Ind...
      • MS-SQL Server - Attribute & JEAVE & WaitTypes
      • MS-SQL Server - A PK Mandatory
      • MS-SQL Server - Exam for Tuning & Tracing
      • MS-SQL Server - For Tune 6000 Series
      • MS-SQL Server - Spatial, Rank, Locks & Ondemand eBook
      • MS-SQL Server - Gain Your Knowledge on JRH
      • MS-SQL Server - Fast & SSIS
      • MS-SQL Server - प्राचीन आर
      • MS-SQL Server - Neash-Adro
      • MS-SQL Server - Hex and Tune-art
      • MS-SQL Server - M-J-M
      • MS-SQL Server - Reason DB
      • MS-SQL Server - Ponk - ABC
      • MS-SQL Server - Manclute Practical
      • MS-SQL Server - विचार - Devotion
      • MS-SQL Server - Voisy Network Team
      • MS-SQL Server - Dhab & Raid
      • MS-SQL Server - Victory for Sure
      • MS-SQL Server - Opposite
      • MS-SQL Server - Materialised View & MTA
      • MS-SQL Server - A Divine Technology
      • MS-SQL Server - Partitioned Table and Indexes
      • MS-SQL Server - Understand Hangs
      • MS-SQL Server - SME-Aligned Index
      • MS-SQL Server - Architecture of Flush Cache
      • MS-SQL Server - Backup One Liner
      • MS-SQL Server - Linked Server & ROBO
      • MS-SQL Server - A HAS MAZIK
      • MS-SQL Server - Basic Business
      • MS-SQL Server - विचार - Truth vs Lie
      • MS-SQL Server - Language
      • MS-SQL Server - NEANJ
      • MS-SQL Server - Replication Waittype & HostName
      • MS-SQL Server - Restore Headeronly
      • MS-SQL Server - Index Update
      • MS-SQL Server - I 'BA' Meant
      • MS-SQL Server - Basic Help of RKJ
      • MS-SQL Server - अंतर
      • MS-SQL Server - Re-CLAIM Space
      • MS-SQL Server - Basic Help on 'Workbench'
      • MS-SQL Server - Always Encrypted
      • MS-SQL Server - How? You Ask Me!
    • ►  March (55)
    • ►  February (7)
    • ►  January (17)
  • ►  2022 (47)
    • ►  December (41)
    • ►  November (6)
  • ►  2011 (1)
    • ►  June (1)

Labels/Tags

A Divine Technology (1) acid properties (1) aggregate (1) Aggregate functions (1) alter Index (1) Always Encrypted (1) Architect (1) architecture (2) Assessment Questions (1) Attribute (1) Backup (1) Bak (1) best practices (1) Best seller industry (1) BI Talk or BAAT (1) Business (1) Business in Standard Edition (1) collation settings (1) Communication (1) Compiler (1) configuration (1) Configuration Manager (1) CPU high (1) cumulative updates (1) Cycle Error Log (1) Database Role (1) Datatypes (1) Deadlocks (1) Delete (1) Dense Rank (1) Determination (1) Devotion (1) Dhaak (1) Dhab (1) Dhai (1) Dhurbi (1) diff (1) Distribution Database (1) DNS Server (1) drop table (1) duplicate records (1) eBook (1) Enable Filestream storage (1) Enable Trace (1) Exam for Tuning & Tracing (1) Failover Cluster (1) fatal errors (1) Filestream (1) flush cache (1) Ganga (1) Ghorak (1) Group by clause (1) Hang (1) Help (3) Hex (1) high availability (1) hostname (1) hotfixes (1) index reorganize (1) Index Update (1) isolation level (1) Isolation levels (1) Joins (2) jor jemry (1) Karta a worker (1) Lakshya (1) Language (1) latch (1) LCK_M_RIn_U (1) linked server (1) Lock Escalation (1) logshipping (1) Logspace (1) MAH of OS (1) Manclute (1) Materialized view (1) maxdop (1) May be Dream (17) mirroring (1) Msdb database (1) MTA Certification (1) Mushk (1) NEANJ (1) Neash-adro (1) Network Issues (1) numeric datatype (1) OLEDB (1) OLTP (1) Opposite (1) parameters (1) Partitioned tables (1) Patching and Upgrade (1) PCI compliance (1) Pearl (1) Peer to Peer Replication (1) performance (1) Pivot (1) Ponk (1) Powershell (1) Query JOANS (1) Race Conditions (1) Raid Level (1) Rank (1) Re-Claim Space (1) Reason DB (1) recommendations (1) Redundancy with Replication (1) remove column (1) Reorganize (1) Replication (1) Replication prerequisites (1) Restore Headeronly (1) Retry Attempts (1) Robocopy (1) Sample database (1) SANSQL (1) Scenario (1) SHLEIVA (1) Show Tables (1) Slab (1) Spatial (1) SQL Environment (1) SQL Profiler (1) SQL Server Agent (1) SQL Server FAQs (1) SQL Server hangs or hung (1) SQL server practical (1) SSIS (2) t-sql functions (1) table Hints (1) TABLOCKX (1) tail log backup (1) Tail-log backup (1) tech antons (1) Technical Reason for Indexing (1) timestamp autoupdate (1) Total vs Target Memory (1) Transactions (1) trn (1) Truncate table (1) Ujajwa (1) Unique index (1) Update Statistics (2) Victory for Sure (1) Vishwas (1) VM Hang (1) Voice Network Team (1) Workbench (1)

About Me

Amit Vaids Blog
I usually work as a DBA and have been working for performance tuning and high availability features. You can find some of the articles from my own personal real time experience.
View my complete profile

Total Page views
Simple theme. Powered by Blogger.