Manish Kumar

Blogs

The curious case of CHAR(0)

By

Over the years I’ve seen quite a few strange things with SQL Server. This...

Transaction log Information gathering

By

Here are the different ways to know the tlog file related information sys.dm_db_log_stats –...

What's New in SQL 2019? at BRSSUG

By

Thanks to everyone who joined the BRSSUG for a night all about SQL Server...

Read the latest Blogs

Forums

Compare two databases

By Jai-SQL DBA

Hi ,   What are the parameters to compare two databases if migrated from...

DB goes into not sync / suspect after a manual failover

By Syed_SQLDBA

After the patching, one of the database goes into Not synchronizing / suspect state....

Identity column as Primary Key - good or bad?

By edwardwill

I'm building a web app to maintain some data, which is mostly flat but...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers