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

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

Last week we asked a puzzle SQL SERVER – Puzzle to Win Print Book – Functions FIRST_VALUE and LAST_VALUE with OVER clause and ORDER BY . This puzzle got very interesting participation. The details of the winner is listed here. In this puzzle we received two very important feedback. This puzzle…

SQL SERVER – Introduction to LEAD and LAG – Analytic Functions Introduced in SQL Server 2012

November 15, 2011

SQL Server 2012 introduces new analytical function LEAD() and LAG(). These functions accesses data from a subsequent row (for lead) and previous row (for lag) in the same result set without the use of a self-join . It will be very difficult to explain this in words so I will…

SQLAuthority News – A Real Story of Book Getting ‘Out of Stock’ to A 25% Discount Story Available

November 14, 2011

Personal, SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQLAuthority Book Review

As many of my readers may know, I have recently written a few books. Right now I’d like to talk about SQL Server Interview Questions and Answers (http://bit.ly/sqlinterviewbook ), my newest release. What inspired me to write this book was similar to my motivations for my previous titles – I…

SQL SERVER – CSVExpress and Quick Data Load

November 13, 2011

SQL Utility

One of the newest ETL tools is CSVexpress.com. This is a program that can quickly load any CSV file into ODBC compliant databases uses data integration. For those of you familiar with databases and how they operate, the question that comes to mind might be what use this program will…

SQL SERVER – Puzzle to Win Print Book – Functions FIRST_VALUE and LAST_VALUE with OVER clause and ORDER BY

November 11, 2011

Some time an interesting feature and smart audience makes total difference at places. From last two days, I have been writing on SQL Server 2012 feature FIRST_VALUE and LAST_VALUE. Please read following post before I continue today as this question is based on the same. Introduction to FIRST_VALUE and LAST_VALUE…

SQL SERVER – OVER clause with FIRST _VALUE and LAST_VALUE – Analytic Functions Introduced in SQL Server 2012 – ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING

November 10, 2011