Profile cover photo
Profile photo
Rajeev Chaudhary
1 follower
1 follower
About
Posts

Post has attachment

Post has attachment
Availability Groups - Performance Impact of Synchronous vs Asynchronous
  I was struggling to define performance impact of Synchronous AG vs Asynchronous AGs in simple terms so DBAs and application teams could have an easy conversation about it. I searched internet and could not find any article that talks about it holistically...
Add a comment...

Post has attachment
Add a comment...

Post has attachment
**
Log Backup, Checkpoint, and Log_Reuse_Wait Value Testing Environment: SQL 2014 Recently, I encountered an issue of log_reuse_wait column not changing even after taking log backup. The database was not replicated or mirrored. So, I decided to do some testing...
Rajeev Chaudhary
Rajeev Chaudhary
360sqldba.com
Add a comment...

Post has attachment
Add a comment...

Post has attachment

Post has attachment
Vertical Partitioned Views
Testing environment: SQL 2014 Developer Edition Recently, a friend brought up a requirement he was trying to
find solution for. Scenario : A table
having a large varchar column besides many other columns with more than a
billion rows. Total table size touch...
Add a comment...

Post has attachment
How to Reinitialize Single Article in SQL Publication
Add a comment...

Post has attachment
How to Reinitialize Single Article in Publication
Testing environment : SQL 2014 Developer Edition Recently, I had a task to enable copy of non-clustered
indexes in transactional replication. It is an option “Copy nonclustered
indexes” in Properties of Article of publication. Screen shot of this property
i...
Add a comment...

Post has attachment
SQL Error Log Shows Random User/SPID Stopping My Trace.
Add a comment...
Wait while more posts are being loaded