SQL Tips and Tricks Archives - Page 168 of 536 - SQL Authority with Pinal Dave

SQL SERVER – Simple Demo of New Cardinality Estimation Features of SQL Server 2014

August 19, 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.…

SQL SERVER – Learn SQL Server 2014 Online in a Day – My Latest Pluralsight Course

August 18, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQL Video, SQLAuthority News

SQL Training

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…

SQL SERVER – Convert Seconds to Hour : Minute : Seconds Format

August 17, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime

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…

SQL SERVER – Convert Old Syntax of RAISEERROR to THROW

August 16, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

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…

SQL SERVER – Validating If Date is Last Day of the Year, Month or Day

August 15, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime

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…

SQL SERVER – Script to Find First Day of Current Month

August 14, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime, SQL Function

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…

SQL SERVER – Finding Out What Changed in a Deleted Database – Notes from the Field #041

August 13, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Server Security

[Note from Pinal]: This is a 41th episode of Notes from the Field series. The real world is full of challenges. When we are reading theory or book, we sometimes do not realize how real world reacts works and that is why we have the series notes from the field,…

SQL SERVER – Simple Demo of New Cardinality Estimation Features of SQL Server 2014

SQL SERVER – Learn SQL Server 2014 Online in a Day – My Latest Pluralsight Course

SQL SERVER – Convert Seconds to Hour : Minute : Seconds Format

SQL SERVER – Convert Old Syntax of RAISEERROR to THROW

SQL SERVER – Validating If Date is Last Day of the Year, Month or Day

SQL SERVER – Script to Find First Day of Current Month

SQL SERVER – ​Finding Out What Changed in a Deleted Database – Notes from the Field #041

SQL SERVER – Finding Out What Changed in a Deleted Database – Notes from the Field #041