SQL Function Archives - Page 29 of 52 - SQL Authority with Pinal Dave

SQL SERVER – Target Recovery Time of a Database – Advance Option in SQL Server 2012

December 27, 2011

Recently I was going over few advanced options of SQL Server 2012 in database properties and I found a new option in the property screen. Properties screen of SQL Server 2008 R2 Properties screen of SQL Server 2012 I got little curious and decided to learn what does this new…

SQL SERVER – A Quick Trick about SQL Server 2012 CONCAT Function – PRINT

December 21, 2011

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

SQL Function, SQLAuthority Book Review

Yesterday I posted A Quick Trick about SQL Server 2012 CONCAT function and the very first comment in few minutes of Vinod Kumar. He suggested that this function should be also used with the PRINT statement as well. While I was having conversation with him – Jacob Sebastian sent me message…

SQL SERVER – A Quick Trick about SQL Server CONCAT function

December 20, 2011

Pinal Dave

SQL Video

SQL Function, SQL Scripts, SQL Server, SQLAuthority Book Review

Just a day before I was presenting at Virtual Tech Days and I wanted to demonstrate the current time to audience using SQL Server Management Studio, I ended up a quick error. If any of you ever tried to concat multiple values of different datatype this should not be surprise to you.

SQL SERVER – Effect of SET NOCOUNT on @@ROWCOUNT

December 2, 2011

Pinal Dave

SQL Tips and Tricks

SQL Function, SQL Scripts, SQL Server

Today I had very interesting experience when I was presenting on SQL Server. While I was presenting the session when I ran query SQL Server Management Studio returned message like (8 row(s) affected) and (2 row(s) affected) etc. After a while at one point, I started to prove usage of @@ROWCOUNT function.

SQL SERVER – Solution to Puzzle – Simulate LEAD() and LAG() without Using SQL Server 2012 Analytic Function

November 24, 2011

Pinal Dave

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

SQL Function, SQL Scripts

Earlier I wrote a series on SQL Server Analytic Functions of SQL Server 2012. During the series to keep the learning maximum and having fun, we had few puzzles. One of the puzzle was simulating LEAD() and LAG() without using SQL Server 2012 Analytic Function. Please read the puzzle here…

SQL SERVER – 2012 – Summary of All the Analytic Functions – MSDN and SQLAuthority

November 23, 2011

Pinal Dave

SQL

SQL Function, SQL Server

SQL Server 2012 (RC0 Available here) has introduced new analytic functions. These functions were long awaited and I am glad that they are now here. Before when any of this function was needed, people used to write long T-SQL code to simulate these functions. But now there’s no need of doing so. Having available native function also helps performance as well readability.

SQL SERVER – Introduction to PERCENTILE_DISC() – Analytic Functions Introduced in SQL Server 2012

November 22, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts

SQL Server 2012 introduces new analytical function PERCENTILE_DISC(). The book online gives following definition of this function: Computes a specific percentile for sorted values in an entire rowset or within distinct partitions of a rowset in Microsoft SQL Server 2012 Release Candidate 0 (RC 0). For a given percentile value P,…