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

Sunday, December 29, 2024

MS-SQL Server - General Discussion (Volume II)

General Discussion (Volume II)

Read more »
Posted by अमित विजय श्याम वैद (रजवाड़ा हिन्दू) {हक़ से आजादी मिला आराम} Blog at 11:45 PM 1 comment:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Tuesday, December 24, 2024

MS-SQL Server - Healthy, Wealthy and Wise & Problems Un-Plugged

Hello,

Read more »
Posted by अमित विजय श्याम वैद (रजवाड़ा हिन्दू) {हक़ से आजादी मिला आराम} Blog at 11:45 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Thursday, December 19, 2024

MS-SQL Server - Sector, Durability, Group by Clause & RDBMS

Sector

Read more »
Posted by अमित विजय श्याम वैद (रजवाड़ा हिन्दू) {हक़ से आजादी मिला आराम} Blog at 11:45 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: SQL Support

Wednesday, December 18, 2024

MS-SQL Server - Select Syntax, Diversity of GUID & Azure Cloud

Syntax

Read more »
Posted by अमित विजय श्याम वैद (रजवाड़ा हिन्दू) {हक़ से आजादी मिला आराम} Blog at 11:45 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: SQL Support

Sunday, December 15, 2024

MS-SQL Server - General Discussion

हां नमस्कार,

Read more »
Posted by अमित विजय श्याम वैद (रजवाड़ा हिन्दू) {हक़ से आजादी मिला आराम} Blog at 11:45 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: May be Dream

Friday, December 13, 2024

MS-SQL Server - Be Healthy.....

Be Healthy.....

Read more »
Posted by अमित विजय श्याम वैद (रजवाड़ा हिन्दू) {हक़ से आजादी मिला आराम} Blog at 11:45 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Wednesday, November 27, 2024

MS-SQL Server - Zobiaper (ज़ोबायपर)

Zobiaper (ज़ोबायपर)

Read more »
Posted by अमित विजय श्याम वैद (रजवाड़ा हिन्दू) {हक़ से आजादी मिला आराम} Blog at 11:45 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Monday, November 18, 2024

MS-SQL Server - भूतल / Baseline

भूतल / Baseline

Read more »
Posted by अमित विजय श्याम वैद (रजवाड़ा हिन्दू) {हक़ से आजादी मिला आराम} Blog at 11:45 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Saturday, October 19, 2024

MS SQL Server - Black Bird 96

Black Bird 96

Read more »
Posted by अमित विजय श्याम वैद (रजवाड़ा हिन्दू) {हक़ से आजादी मिला आराम} Blog at 11:45 PM 1 comment:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Monday, October 7, 2024

MS-SQL Server - मोर यानि ज्यादा (Part II)

Important key items

Read more »
Posted by अमित विजय श्याम वैद (रजवाड़ा हिन्दू) {हक़ से आजादी मिला आराम} Blog at 11:45 PM 37 comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Friday, October 4, 2024

MS-SQL Server - आड़ जासन of Performance

Well Performance आड़ जासन in regards to SQL Server is nothing but.....

Read more »
Posted by अमित विजय श्याम वैद (रजवाड़ा हिन्दू) {हक़ से आजादी मिला आराम} Blog at 11:45 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Monday, September 30, 2024

MS-SQL Server - FT_IFTS_SHARED_MEMORY, HADR_DATABASE_WAIT_FOR_RECOVERY & Cyclic Best Redundancy, SOS_PROCESS_AFFINITY_MUTEX

Cyclic Best Redundancy

Read more »
Posted by अमित विजय श्याम वैद (रजवाड़ा हिन्दू) {हक़ से आजादी मिला आराम} Blog at 11:45 PM 2 comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Saturday, September 21, 2024

MS-SQL Server - Relationships (Foreign Keys), Run job duration in minutes & IO_COMPLETION

Run job duration in minutes & IO_COMPLETION.

Read more »
Posted by अमित विजय श्याम वैद (रजवाड़ा हिन्दू) {हक़ से आजादी मिला आराम} Blog at 11:45 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Friday, September 13, 2024

MS-SQL Server - COALESCE, Waits (DISABLE_VERSIONING, DEBUG, ENABLE_VERSIONING & QPJOB_WAITFOR_ABORT)

COALESCE

Read more »
Posted by अमित विजय श्याम वैद (रजवाड़ा हिन्दू) {हक़ से आजादी मिला आराम} Blog at 11:45 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Thursday, September 12, 2024

MS-SQL Server - Griffin Architecture

Griffin

Read more »
Posted by अमित विजय श्याम वैद (रजवाड़ा हिन्दू) {हक़ से आजादी मिला आराम} Blog at 11:45 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Sunday, September 8, 2024

MS-SQL Server - जिलक ट्रिज

जिलक ट्रिज 

Read more »
Posted by अमित विजय श्याम वैद (रजवाड़ा हिन्दू) {हक़ से आजादी मिला आराम} Blog at 11:45 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Monday, September 2, 2024

MS-SQL Server - गंध R

गंध R

Read more »
Posted by अमित विजय श्याम वैद (रजवाड़ा हिन्दू) {हक़ से आजादी मिला आराम} Blog at 11:45 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Friday, August 30, 2024

MS-SQL Server - Web edition, Linked Server Permissions & Fixed Roles of Database

Web edition, Linked Server Permissions & Fixed Roles of Database

Read more »
Posted by अमित विजय श्याम वैद (रजवाड़ा हिन्दू) {हक़ से आजादी मिला आराम} Blog at 11:45 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Tuesday, August 20, 2024

MS-SQL Server - Partitioned Table & Brackets around columns

Partitioned Table

Read more »
Posted by अमित विजय श्याम वैद (रजवाड़ा हिन्दू) {हक़ से आजादी मिला आराम} Blog at 11:45 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Sunday, August 18, 2024

MS-SQL Server - Count Distinct

Count Distinct

Read more »
Posted by अमित विजय श्याम वैद (रजवाड़ा हिन्दू) {हक़ से आजादी मिला आराम} Blog at 11:45 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: SQL Support

Saturday, August 10, 2024

MS-SQL Server - Ceemak (सीमक)

Ceemak in regards to SQL Server is nothing but....

Read more »
Posted by अमित विजय श्याम वैद (रजवाड़ा हिन्दू) {हक़ से आजादी मिला आराम} Blog at 11:45 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Friday, July 19, 2024

MS-SQL Server - Gap in the Identity

Gap in the Identity

Read more »
Posted by Anonymous at 11:45 PM 1 comment:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Saturday, July 13, 2024

MS-SQL Server - SQL Advanced Threat Protection

SQL Advanced Threat Protection

Read more »
Posted by Anonymous at 12:15 AM 1 comment:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Thursday, July 11, 2024

MS-SQL Server - Analytic functions

Analytic functions

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

Friday, July 5, 2024

MS-SQL Server - Send Messages to Teams, Change Tracking SQL Server & Transaction Log Shrink after Backup

Specify Fill Factor for an Index - SQL Server

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

Sunday, June 30, 2024

MS-SQL Server - Advice

Advice

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

Saturday, June 29, 2024

MS-SQL Server - Divide by Zero Error, FT_IFTS_SHARED_MEMORY & ScenarioEngine

Divide by Zero Error, FT_IFTS_SHARED_MEMORY & ScenarioEngine

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

Thursday, June 20, 2024

MS-SQL Server - अनमोल भावना

अनमोल भावना

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

Wednesday, June 12, 2024

MS-SQL Server - Roorkee

Roorkee

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

Tuesday, June 4, 2024

MS-SQL Server - मन से बनो जरा स्ट्रिक्ट

मन से बनो जरा स्ट्रिक्ट

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

Thursday, May 30, 2024

MS-SQL Server - Shortcuts and Best Practice for High Availability

Shortcuts and Best Practice for High Availability

Read more »
Posted by Anonymous at 11:45 PM 1 comment:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Friday, May 24, 2024

MS-SQL Server - ख्यालड़ी

ख्यालड़ी 

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

Sunday, May 12, 2024

MS-SQL Server - Indexes N FILESTREAM_WORKITEM_QUEUE

Indexes N FILESTREAM_WORKITEM_QUEUE

Read more »
Posted by Anonymous at 11:45 PM 1 comment:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Wednesday, May 8, 2024

MS-SQL Server - रफ्तार

रफ्तार
Read more »
Posted by Anonymous at 11:45 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Thursday, April 11, 2024

MS-SQL Server - Logs, Versions, GUID, Shared Memory & LOOP

Logs, Versions, GUID, Shared Memory & LOOP

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

Tuesday, April 2, 2024

MS-SQL Server - Input Buffer

Input Buffer

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

Sunday, March 3, 2024

MS-SQL Server - Ambiguous, ASYNC_NETWORK_IO, XIO_EDS_RWLOCK, HADR_AR_UNLOAD_COMPLETED

Ambiguous, ASYNC_NETWORK_IO, XIO_EDS_RWLOCK, HADR_AR_UNLOAD_COMPLETED

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

Monday, February 12, 2024

MS-SQL Server - KSOURCE_WAKEUP, INSTANCE_LOG_RATE_GOVERNOR

KSOURCE_WAKEUP, INSTANCE_LOG_RATE_GOVERNOR

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

Monday, February 5, 2024

MS-SQL Server - मोर यानि ज्यादा

मोर यानि ज्यादा

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

Monday, January 29, 2024

MS-SQL Server - Database Space Allocation, Status-112, TCP Port 1433

Database Space Allocation, Status-112, TCP Port 1433


Read more »
Posted by Anonymous at 11:45 AM 1 comment:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

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
  • 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

  • MS-SQL Server - मोर यानि ज्यादा (Part III)
  • MS-SQL Server - मोर यानि ज्यादा (Part II)
  • MS-SQL Server - मोर यानि ज्यादा
  • MS-SQL Server - Visiting Error Logs
  • MS-SQL Server - MIG On Idea
  • MS-SQL Server - Modifying Scheduled Jobs
  • MS-SQL Server - Divides one number by another, Physical Joins, SQLSORT_NORMMUTEX and Cycle error log
  • MS-SQL Server - भूतल / Baseline
  • MS-SQL Server - UCS_TRANSPORT_STREAM_CHANGE & Key Problem of GUID N Network
  • MS-SQL Server - General Discussion

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 श्याम वैद 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 (32)
    • ►  June (7)
    • ►  May (3)
    • ►  April (3)
    • ►  March (5)
    • ►  February (2)
    • ►  January (12)
  • ▼  2024 (40)
    • ▼  December (6)
      • MS-SQL Server - General Discussion (Volume II)
      • MS-SQL Server - Healthy, Wealthy and Wise & Proble...
      • MS-SQL Server - Sector, Durability, Group by Claus...
      • MS-SQL Server - Select Syntax, Diversity of GUID &...
      • MS-SQL Server - General Discussion
      • MS-SQL Server - Be Healthy.....
    • ►  November (2)
      • MS-SQL Server - Zobiaper (ज़ोबायपर)
      • MS-SQL Server - भूतल / Baseline
    • ►  October (3)
      • MS SQL Server - Black Bird 96
      • MS-SQL Server - मोर यानि ज्यादा (Part II)
      • MS-SQL Server - आड़ जासन of Performance
    • ►  September (6)
      • MS-SQL Server - FT_IFTS_SHARED_MEMORY, HADR_DATABA...
      • MS-SQL Server - Relationships (Foreign Keys), Run ...
      • MS-SQL Server - COALESCE, Waits (DISABLE_VERSIONIN...
      • MS-SQL Server - Griffin Architecture
      • MS-SQL Server - जिलक ट्रिज
      • MS-SQL Server - गंध R
    • ►  August (4)
      • MS-SQL Server - Web edition, Linked Server Permiss...
      • MS-SQL Server - Partitioned Table & Brackets aroun...
      • MS-SQL Server - Count Distinct
      • MS-SQL Server - Ceemak (सीमक)
    • ►  July (4)
      • MS-SQL Server - Gap in the Identity
      • MS-SQL Server - SQL Advanced Threat Protection
      • MS-SQL Server - Analytic functions
      • MS-SQL Server - Send Messages to Teams, Change Tra...
    • ►  June (5)
      • MS-SQL Server - Advice
      • MS-SQL Server - Divide by Zero Error, FT_IFTS_SHAR...
      • MS-SQL Server - अनमोल भावना
      • MS-SQL Server - Roorkee
      • MS-SQL Server - मन से बनो जरा स्ट्रिक्ट
    • ►  May (4)
      • MS-SQL Server - Shortcuts and Best Practice for Hi...
      • MS-SQL Server - ख्यालड़ी
      • MS-SQL Server - Indexes N FILESTREAM_WORKITEM_QUEUE
      • MS-SQL Server - रफ्तार
    • ►  April (2)
      • MS-SQL Server - Logs, Versions, GUID, Shared Memor...
      • MS-SQL Server - Input Buffer
    • ►  March (1)
      • MS-SQL Server - Ambiguous, ASYNC_NETWORK_IO, XIO_E...
    • ►  February (2)
      • MS-SQL Server - KSOURCE_WAKEUP, INSTANCE_LOG_RATE_...
      • MS-SQL Server - मोर यानि ज्यादा
    • ►  January (1)
      • MS-SQL Server - Database Space Allocation, Status-...
  • ►  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 (11) 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 (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 (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) Wishlist (1) Workbench (1)

Contributors

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

Total Page views

Simple theme. Powered by Blogger.