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

Friday, March 31, 2023

MS-SQL Server - Update Statistics

Update Statistics

Read more »
Posted by Anonymous at 3:45 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Update Statistics

MS-SQL Server - Determination

Determination


Read more »
Posted by Anonymous at 11:45 AM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Determination

MS-SQL Server - My Urgent Items

My Urgent Items

Read more »
Posted by Anonymous at 11:45 AM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

MS-SQL Server - String_Agg

Aggregate Functions

Read more »
Posted by Anonymous at 11:45 AM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Aggregate functions

Thursday, March 30, 2023

MS-SQL Server - Show Table

Show Table

Read more »
Posted by Anonymous at 6:30 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Show Tables

MS-SQL Server - MAH of OS! Why?

MAH of OS! Why?

Read more »
Posted by Anonymous at 11:45 AM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: MAH of OS

MS-SQL Server - Ghorak

Ghorak

Read more »
Posted by Anonymous at 11:45 AM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Ghorak

Wednesday, March 29, 2023

MS-SQL Server - Race Conditions and Deadlocks

Race Conditions and Deadlocks

Read more »
Posted by Anonymous at 4:15 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Deadlocks, Race Conditions

MS-SQL Server - SANSQL And AD

SANSQL And AD

Read more »
Posted by Anonymous at 11:45 AM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: SANSQL

MS-SQL Server - Dhurbi

Dhurbi

Read more »
Posted by Anonymous at 11:45 AM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Configuration Manager, Dhurbi

MS-SQL Server - Thank God I am Busy!

Thank God I am Busy!

Read more »
Posted by Anonymous at 11:45 AM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Tuesday, March 28, 2023

MS-SQL Server - Communication

Communication

Read more »
Posted by Anonymous at 5:45 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Communication

Monday, March 27, 2023

MS-SQL Server - Why I Need Filestream Storage?

Why I Need Filestream Storage?

Read more »
Posted by Anonymous at 4:45 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Enable Filestream storage, Filestream

MS-SQL Server - अतिरिक्त सेवाएं

May be Dream but a story to learn.

Read more »
Posted by Anonymous at 11:45 AM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: May be Dream, Powershell

Sunday, March 26, 2023

MS-SQL Server - Ganga


Ganga

Read more »
Posted by Anonymous at 10:23 PM 1 comment:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Ganga

MS-SQL Server - Query JOANS

Query JOANS

Read more »
Posted by Anonymous at 4:45 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Query JOANS

MS-SQL Server - Allocating Space for Job History

Allocating Space for Job History

Read more »
Posted by Anonymous at 4:45 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Msdb database

MS-SQL Server - Patching

Patching

Read more »
Posted by Anonymous at 11:45 AM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Patching and Upgrade

MS-SQL Server - Lakshya (A Target)

Lakshya (A Target)

Read more »
Posted by Anonymous at 11:45 AM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Lakshya

Saturday, March 25, 2023

MS-SQL Server - First Well Key Role

First Well Key Role

Read more »
Posted by Anonymous at 8:29 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Database Role

MS-SQL Server - Best Working DBA

Best Working DBA

Read more »
Posted by Anonymous at 6:04 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: SQL Server hangs or hung
Newer Posts Older Posts Home
View mobile version
Subscribe to: Posts (Atom)

विरंक

Well VIRUNQ in regards to SQL Server is nothing but "View Running Queries"
SQL Server से कितना कुछ बटोरा, अब मेरे पास SQL सर्वर है आप भी हमें कोई अच्छी सी क्वेरी दे सकते हैँ! amitvaid2024 att- gmail dot -com

विप्नल (आश्चर्य or Amazement) SQL Server में बहुत कुछ है जिसे देख कर विप्नल होता है! इसकी थोड़ी सी व्याख्या इस प्रकार है

निश्चला (अर्थात स्थिर) हमने अपनी डिमांड समझी "दीज़ आर चूज़िंग बैतर टेक्निक विच इज़ क्विक" और वो बड़ा लैवल पाया जो निश्चल है! मोर यानि ज्यादा का गर्म कथन / A Quote चुनिंदा बड़ै बिज़नेस वालों के कुल इकत्तीस टिप्स By शतैवमश्या एक और प्रहार

मैने जब मेरे प्रयासों के घोड़े दौड़ाए तो बगैर कठिनाई प्रतियोगियों के सामने वो लेवल achieve किया जिसके घनिष्ठ स्वर में एक मुकाम हासिल हुआ और हर बार लड़ने के मायने मिले, फिर आपकी ये एकाग्रता कहीं व्यर्थ नहीं जाती है!

Literature / साहित्य Microsoft SQL Server literature includes official documentration and core programming books covering T-SQL, performance tuning, and database administration.

I am a fan of SQL Server.


Initial Step
White Paper
Source: Microsoft

{ SQL Server parallelism is controlled by two primary settings: max degree of parallelism (MAXDOP) and cost threshold for parallelism. ॐ शांति }

Last Deleated History [LDH]

Click Here for More

SQL Forum

  • Question Form
  • Datenbankunterstützung

Top Labels / Tags

  • DBA Support
  • SQL Support

My Wish

  • Wishlist

Favorite Blogs & Sites

  • SQL DBA

DBA Projects

  • BHP Billiton
  • Driscolls
  • GE Money
  • NBC Universal
  • Santander
  • SGT University
  • Sinclair Knight Merz
  • State Street
  • Telstra

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

  • मोर यानि ज्यादा (Part V)
  • MS-SQL Server - मोर यानि ज्यादा (Part III)
  • MS-SQL - Server - मोर यानि ज्यादा (Part VI)
  • MS-SQL Server - Ubber Hood
  • MS-SQL Server - मोर यानि ज्यादा (Part II)
  • MS-SQL Server - Virtual Machine, Switch Table & Prerequisites for FC
  • MS-SQL Server - मोर यानि ज्यादा (Part IV)
  • MS-SQL Server - MIG On Idea
  • MS-SQL Server - Analysis of Optimization, Joins, Endpoints, Well-Known Text (WKT) & ENCRYPTBYASYMKEY
  • MS-SQL Server - मोर यानि ज्यादा

About Author

This blog is a journey of SQL Server Professional.
Questo blog racconta il viaggio di 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. Ammit Vaid S.
Average Study 5th Class from Govt. School, New Delhi
(not Pandit by Profession/Religion)
NickName Goldy (Gooli)
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

  • ▼  2026 (20)
    • ▼  October (2)
      • MS-SQL Server - Logical and Physical Reads & Slips...
      • MS-SQL Server - Say NO to Server Side Traace, Bloc...
    • ►  September (2)
    • ►  August (1)
    • ►  July (4)
    • ►  April (2)
    • ►  March (4)
    • ►  February (4)
    • ►  January (1)
  • ►  2025 (52)
    • ►  December (1)
    • ►  November (1)
    • ►  October (4)
    • ►  September (2)
    • ►  August (9)
    • ►  July (3)
    • ►  June (7)
    • ►  May (3)
    • ►  April (3)
    • ►  March (5)
    • ►  February (2)
    • ►  January (12)
  • ►  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)
    • ►  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) DBA Support (14) 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) Last Deleated History [LDH] (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 (20) 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) SQL Support (4) SSIS (4) 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) Wishlist (1) Workbench (1)

Contributors

  • Sheetal Vaid
  • अमित विजय मुंशी राम वैद (रजवाड़ा हिन्दू) {हक़ से आजादी मिला आराम} Blog

Total Page views

Simple theme. Powered by Blogger.