Results for "sql server linked server"
9 / 141 posts
Dynamic Linked Server Management in SQL Server
Introduction In SQL Server, sometimes we need to connect with another database server. This is done using a Linked Server . But manually creating and deletin...
SQL Server Data Archiving System – Complete Guide with Real-World Approach
Introduction Database grow hota rehta hai — aur ek point ke baad performance slow hone lagti hai. Queries heavy ho jati hain, indexing inefficient ho jata ha...
SQL Server Configuration Manager
Introduction Jab hum Microsoft SQL Server install karte hain , tab kuch important tools automatically install ho jate hain. Unme se ek bahut important tool…
SQL Server Database Shrink Maintenance
Database shrink ka matlab hai database file (ya log file) ke size ko chhota karna by removing unused space . Matlab, agar tumhare DB me data delete ho gaya h...
SQL Server System Databases
Introduction SQL Server me jab hum kaam karte hain, to generally hum tables, queries aur user databases par focus karte hain. Lekin ek hidden backbone hota…
Model & Resource Database in SQL Server
Introduction SQL Server ke system databases me kuch aise hidden heroes hote hain jo directly dikhte nahi, lekin bahut powerful role play karte hain. Aaj hum...
Master Database in SQL Server
Introduction SQL Server me agar koi ek database sabse zyada critical hai, to wo hai: Master Database Ye SQL Server ka core brain hai. Agar master database …
SQL Server Administration – Management Tools Overview
Is section me hum mainly SQL Server ke management tools aur system databases ko samjhenge. SQL Server Management Tools Jab aap Microsoft SQL Server install…
TempDB in SQL Server
Introduction SQL Server me ek aisa database hai jo har query, har process aur almost har operation me involve hota hai. Ye ek temporary w…