Knowledge Sharing

Pages

  • Cloud
  • AI-ML
  • Finance
  • Fabric
  • SQL Arch.
  • Performance
  • PostgreSQL
  • Demo
  • Scripts

How to Use Performance Monitor in Windows 2008

Read more »
1 comment:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

What Is IAM PAGES In SQL Server


Read more »
4 comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Clustered Index on View Doesnt Replicates Default : Replication in SQL Server


Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

How To Find Which Users Are Available on Server without Accessing Sql Server


Read more »
1 comment:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Setup Doesnot Start For Sql Server Service Pack Upgrade

Read more »
1 comment:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Which SP_configure Options Require Reboot In SQL Server


Read more »
1 comment:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Non-SysAdmins have been denied permission to run DTS Execution job steps without a proxy account. The step failed.


Read more »
2 comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

How To List All Pages of Table in SQL Server

Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Table Belongs To Which Database In SQL Server

Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

When My SQL Login Password Last Reset


Read more »
3 comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Sleeping Sessions From Last 30 Mins In SQL Server


Read more »
1 comment:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

When Column Was Added In Table In SQL Server


Read more »
1 comment:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

SQL Server Replication DEMO: Generate Snapshot Of New Article Only

Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

SQL Server PDW: Row Size Exceeds Defined Maximum DMS Row Size


Read more »
1 comment:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

How To Find Statistics For Table \ Column In SQL Server Database


Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Query To Find Statistics For Specific Column In SQL Server Database

         
Read more »
1 comment:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Query To Find Statistics For Specific Table

   
Read more »
1 comment:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Replication Job Failing: The application failed to initialize properly (0xc0000142).

 
Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

SQL Server Memory related Query's


Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Calling XP_CMDSHELL Within Cursor Is Not Completing task (Copying Files Using SQL Server)

Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Large Pages In SQL Server

Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Log Shipping In SQL Server : Day 1


Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

What is Work (.wrk) file in SQL Server


Read more »
3 comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

What is TUF File In SQL Server



Read more »
2 comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Find All Files In Specific Folder Using T- SQL

Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Restore Database Procedure From Multiple Backup Location


Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Procedure To Shrink Log Files Of Specific Database


Read more »
1 comment:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

The credentials you provided for the SQL Server Agent service are invalid. To continue, provide a valid account and password for the SQL Server Agent service.


Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Error: The setting 'IACCEPTSQLSERVERLICENSETERMS' specified is not recognized; in SQL SERVER 2008


Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

What Is The Difference Between TCP/IP And Named Pipes; Interview Question



Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

What Is Statistics In SQL Server


Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Find List Of Index For Tables In Sql Server



Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Which SQL Server 2014 Edition Should Be Used

Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Difference Between SQL Server 2014 Editions


Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

SQL Server 2014 Offer Below Editions

Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Detailed Blocking Information With Query Information In Sql Server

Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Sleeping Sessions From Last 30 mins In Sql Server

Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

TOP 5 CPU-CONSUMING STATEMENTS In Sql Server

Read more »
1 comment:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

How To Find Current Running Transaction In Sql Server

Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Ad hoc update to system catalogs is not supported; sp_configure 'allow updates'


Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Spatial Data Implementation In Sql Server Demo


Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Last Queries Executed On Sql Server


Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

What Is Dirty Reads In SQL Server


Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

List of Windows Operating System Errors


Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Error: Microsoft SQL Server Management Studio is unable to access replication components because replication is not installed on this instance of SQL Server


Replication Setup Error 1
Replication Setup Error 2

Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Error: SQL Server replication requires the actual server name to make a connection to the server. Connections through a server alias, IP address, or any other alternate name are not supported. Specify the actual server

Replication Setup Error 1
Replication Setup Error 2

Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

When My SQL login Password Last Reset in SQL Server


Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Does Changes Due To Rebuilding \ Reorganize Index Is Saved in Differential or Log backup

Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

When Table Data Is Last Accessed And Modified in SQL Server

Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

INCORRECT : "Differential backup can only restore over last full backup" In SQL Server

Read more »
5 comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Executing SQL Server Scripts From Command Line With Append Output File


Read more »
3 comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

How To Manage ( Start \ Stop \ Pause \ Stop ) SQL Server Services From The Command Line


Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Backup \ Restore Scripts For Litespeed in SQL Server


Read more »
7 comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Frequently Used Queries In Sql Server


Read more »
8 comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

When Table Is Last Updated And Modified In SQL Server

Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

How To Setup Merge Replication With Download Only / One Direction in SQL 2014 : Demo

Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Complexities : Merge Replication With Download Only / Unidirection



Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

FOR XML could not serialize the data for node because it contains a character (0x0000) which is not allowed in XML. To retrieve this data using FOR XML, convert it to binary, varbinary or image data type and use the BINARY BASE64 directive.

Read more »
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Categories

AI-ML (24) Accounting (1) Analytics (19) Audit (7) Automation (3) Azure (17) Cloud (19) Column Store Index (3) Connectivity (6) Data science (3) Dead Lock (5) Demo (36) Difference Between (15) Docker (1) Fabric (6) Finance (6) Firewall (2) GCP (11) High Availability (3) Hive (3) Indexes (15) Interview Questions (7) Java (1) Kubernetes (4) ML (1) MYSQL (1) Machine Learning (3) MariaDB (1) Memory (7) Must Read (3) Non SQL (3) OS (4) PDW (5) Partition (2) Performance Issues (18) Performance Scripts (3) PostgreSQL (7) Power Shell (4) Protocols (4) Python (3) Quick Audit (2) R (2) RabbitMQ (1) Registry Query (1) Regression (2) Replication (21) Robocopy (1) SPN (2) SQL Architecture (34) SQL Internals (14) Scripts (87) Sql Cluster (5) Statistics (8) Tableau (1) Third Party Tool (3) Tips & Tricks SQL Server (5) Trace flags (2) Ubuntu (3) Visual Studio (1) What is ? (7) XP_CMDSHELL (3) hadoop (2) litespeed (1)

Total Pageviews

Followers

Archive

  • ►  2024 (32)
    • ►  September (4)
    • ►  August (3)
    • ►  July (3)
    • ►  June (5)
    • ►  March (1)
    • ►  February (6)
    • ►  January (10)
  • ►  2023 (4)
    • ►  December (2)
    • ►  February (1)
    • ►  January (1)
  • ►  2022 (11)
    • ►  December (1)
    • ►  November (1)
    • ►  September (2)
    • ►  April (3)
    • ►  January (4)
  • ►  2021 (1)
    • ►  January (1)
  • ►  2020 (13)
    • ►  May (8)
    • ►  March (2)
    • ►  February (2)
    • ►  January (1)
  • ►  2019 (15)
    • ►  December (3)
    • ►  November (1)
    • ►  October (1)
    • ►  September (1)
    • ►  July (2)
    • ►  June (1)
    • ►  May (1)
    • ►  March (4)
    • ►  February (1)
  • ►  2018 (36)
    • ►  December (1)
    • ►  November (1)
    • ►  October (3)
    • ►  September (2)
    • ►  August (5)
    • ►  July (4)
    • ►  June (6)
    • ►  May (8)
    • ►  March (1)
    • ►  February (2)
    • ►  January (3)
  • ►  2017 (45)
    • ►  December (12)
    • ►  November (11)
    • ►  October (3)
    • ►  September (4)
    • ►  July (1)
    • ►  June (2)
    • ►  February (5)
    • ►  January (7)
  • ►  2016 (12)
    • ►  October (1)
    • ►  August (5)
    • ►  July (1)
    • ►  January (5)
  • ▼  2015 (58)
    • ▼  December (1)
      • How to Use Performance Monitor in Windows 2008
    • ►  November (17)
      • What Is IAM PAGES In SQL Server
      • Clustered Index on View Doesnt Replicates Default ...
      • How To Find Which Users Are Available on Server wi...
      • Setup Doesnot Start For Sql Server Service Pack Up...
      • Which SP_configure Options Require Reboot In SQL S...
      • Non-SysAdmins have been denied permission to run D...
      • How To List All Pages of Table in SQL Server
      • Table Belongs To Which Database In SQL Server
      • When My SQL Login Password Last Reset
      • Sleeping Sessions From Last 30 Mins In SQL Server
      • When Column Was Added In Table In SQL Server
      • SQL Server Replication DEMO: Generate Snapshot Of ...
      • SQL Server PDW: Row Size Exceeds Defined Maximum D...
      • How To Find Statistics For Table \ Column In SQL S...
      • Query To Find Statistics For Specific Column In SQ...
      • Query To Find Statistics For Specific Table
      • Replication Job Failing: The application failed to...
    • ►  October (11)
      • SQL Server Memory related Query's
      • Calling XP_CMDSHELL Within Cursor Is Not Completin...
      • Large Pages In SQL Server
      • Log Shipping In SQL Server : Day 1
      • What is Work (.wrk) file in SQL Server
      • What is TUF File In SQL Server
      • Find All Files In Specific Folder Using T- SQL
      • Restore Database Procedure From Multiple Backup Lo...
      • Procedure To Shrink Log Files Of Specific Database
      • The credentials you provided for the SQL Server Ag...
      • Error: The setting 'IACCEPTSQLSERVERLICENSETERMS' ...
    • ►  September (1)
      • What Is The Difference Between TCP/IP And Named Pi...
    • ►  August (1)
      • What Is Statistics In SQL Server
    • ►  June (4)
      • Find List Of Index For Tables In Sql Server
      • Which SQL Server 2014 Edition Should Be Used
      • Difference Between SQL Server 2014 Editions
      • SQL Server 2014 Offer Below Editions
    • ►  May (5)
      • Detailed Blocking Information With Query Informati...
      • Sleeping Sessions From Last 30 mins In Sql Server
      • TOP 5 CPU-CONSUMING STATEMENTS In Sql Server
      • How To Find Current Running Transaction In Sql Server
      • Ad hoc update to system catalogs is not supported;...
    • ►  April (4)
      • Spatial Data Implementation In Sql Server Demo
      • Last Queries Executed On Sql Server
      • What Is Dirty Reads In SQL Server
      • List of Windows Operating System Errors
    • ►  March (2)
      • Error: Microsoft SQL Server Management Studio is u...
      • Error: SQL Server replication requires the actual ...
    • ►  January (12)
      • When My SQL login Password Last Reset in SQL Server
      • Does Changes Due To Rebuilding \ Reorganize Index ...
      • When Table Data Is Last Accessed And Modified in S...
      • INCORRECT : "Differential backup can only restore ...
      • Executing SQL Server Scripts From Command Line Wi...
      • How To Manage ( Start \ Stop \ Pause \ Stop ) SQL ...
      • Backup \ Restore Scripts For Litespeed in SQL Server
      • Frequently Used Queries In Sql Server
      • When Table Is Last Updated And Modified In SQL Server
      • How To Setup Merge Replication With Download Only ...
      • Complexities : Merge Replication With Download On...
      • FOR XML could not serialize the data for node bec...
  • ►  2014 (100)
    • ►  December (14)
    • ►  November (11)
    • ►  October (3)
    • ►  September (9)
    • ►  August (12)
    • ►  July (8)
    • ►  June (6)
    • ►  May (5)
    • ►  April (3)
    • ►  February (22)
    • ►  January (7)
  • ►  2013 (22)
    • ►  December (4)
    • ►  September (4)
    • ►  August (4)
    • ►  June (2)
    • ►  May (2)
    • ►  April (4)
    • ►  March (1)
    • ►  January (1)
  • ►  2012 (10)
    • ►  October (1)
    • ►  September (2)
    • ►  July (2)
    • ►  June (5)
  • ►  2011 (3)
    • ►  July (1)
    • ►  June (2)
  • ►  2010 (1)
    • ►  February (1)

Who am I

  • Mohammed Adil
  • Saurabh Sinha
Powered by Blogger.