Tag Archives: traceflag

Knowledge share 2014-11

Traceflag 3226: In my production environment, we take transaction log backups every 10 minutes for all 40+ databases. There are thousands or Successful backup messages in my logs which is very annoying. SQL Server 2008 introduced traceflag 3226 to disable … Continue reading

Posted in knowledge, SQL | Tagged , , , , , , | Leave a comment

Knowledge Share 2014-04

In SQL Server 2014, you can have 8 secondary replicas, it was 4 in SQL 2012 Ref: What’s New (DB Engine) SQL Server 2014 – http://msdn.microsoft.com/en-us/library/bb510411%28v=sql.120%29.aspx#DataFiles What is Cardinality Estimation? This is new feature in SQL Server 2014: The cardinality … Continue reading

Posted in knowledge, Productivity, SQL, sql2014 | Tagged , , , , , , , | Leave a comment

SQL Server Deadlocks

I had been talking about deadlocks few hundreds of times, worked on it few tens of times, questioned in most of the interviews. I will give an attempt to document Deadlock basics in this Blog! By Wiki definition, deadlock is … Continue reading

Posted in Productivity, Script, SQL, SQL Query | Tagged , , , , | Leave a comment