Earlier this year, I wrote an article series where I talked about developer’s life and compared it with Superhero. Let us explore the article.
SQL SERVER – How to Force New Cardinality Estimation or Old Cardinality Estimation
After reading my initial two blog posts on New Cardinality Estimation, I received quite a few questions. Once I receive this question, I felt I should have clarified it earlier few things when I started to write about cardinality. Before continuing this blog, if you have not read it before…
Read MoreSQL SERVER – Backing Up and Recovering the Tail End of a Transaction Log – Notes from the Field #042
[Notes from Pinal]: The biggest challenge which people face is not taking backup, but the biggest challenge is to restore a backup successfully. I have seen so many different examples where users have failed to restore their database because they made some mistake while they take backup and were not…
Read MoreSQL SERVER – Cardinality Estimation and Performance – SQL in Sixty Seconds #072
Yesterday I wrote blog post based on my latest Pluralsight course on learning SQL Server 2014. I discussed newly introduced cardinality estimation in SQL Server 2014 and how it improves the performance of the query. The cardinality estimation logic is responsible for quality of query plans and majorly responsible for improving…
Read MoreSQL SERVER – Simple Demo of New Cardinality Estimation Features of SQL Server 2014
SQL Server 2014 has new cardinality estimation logic/algorithm. The cardinality estimation logic is responsible for quality of query plans and majorly responsible for improving performance for any query. This logic was not updated for quite a while, but in the latest version of SQL Server 2104 this logic is re-designed.…
Read MoreSQL SERVER – Learn SQL Server 2014 Online in a Day – My Latest Pluralsight Course
Click here watch SQL Server 2014 Administration New Features. SQL Server 2014 was released earlier this year and it has been extremely popular in Microsoft world. Here is the announcement for everyone, who have been asking me to build a tutorial around SQL Server 2014. I have authored latest Pluralsight…
Read MoreSQL SERVER – Convert Seconds to Hour : Minute : Seconds Format
Here is another question I received via email. “Hi Pinal, I have a unique requirement. We measure time spent on any webpage in measure of seconds. I recently have to build a report over it and I did few summations based on group of web pages. Now my manager wants…
Read More