The VLF Trap

While working on one of the migration there is something which I discovered so sharing all what I know about VLF’s and how we can ensure that we don’t get into VLF trap:  Few issues which you can see if there are too many VLF’s:   In cluster failover the database takes long time to…

0

SQL2014PerformanceImprovements

There have been many new changes which have been incorporated into SQL 2014 which would be the game changer in terms of the adoptability of SQL server. Some of the new noticeable changes which we have in SQL 2014 are : ϠNew cardinality estimate : ₰Cardinality estimate is totally re-written. ₰Database compatibility level should be…

0

SQL2014PerformanceImprovements

There have been many new changes which have been incorporated into SQL 2014 which would be the game changer in terms of the adoptability of SQL server. Some of the new noticeable changes which we have in SQL 2014 are : ϠNew cardinality estimate : ₰Cardinality estimate is totally re-written. ₰Database compatibility level should be…

0

Going Online

Almost closing to six years of happy time in MS, I’ve decided to share the knowledge which I’ve acquired over the period. As of now, I’ll start with SQL server related blogs which I’ve been associated from day one.  Planning to start with the blog on SQL server 2014 …… here we go

0