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 MoreSQL SERVER – Convert Old Syntax of RAISEERROR to THROW
I have been quite a few comments on my Facebook page and here is one of the questions which instantly caught my attention. “We have a legacy application and it has been a long time since we are using SQL Server. Recently we have upgraded to the latest version of…
Read MoreSQL SERVER – Validating If Date is Last Day of the Year, Month or Day
Here is one more question I recently received in an email- “Pinal, is there any ready made function which will display if the given date is the last day or the year, month or day? For example, if a date is the last day of the Year and last day…
Read MoreSQL SERVER – Script to Find First Day of Current Month
Earlier I wrote a blog post about SQL SERVER – Query to Find First and Last Day of Current Month and it is a very popular post. In this post, I convert the datetime to Varchar and later on use it. However, SQL Expert Michael Usov has made a good…
Read More