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

SQLAuthority News – SafePeak’s SQL Server Performance Contest – Winners

November 28, 2011

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

SafePeak, the unique automated SQL performance acceleration and performance tuning software vendor, announced the winners of their SQL Performance Contest 2011. The contest quite unique: the writer of the best / most interesting and most community liked “performance story” would win an expensive gadget. The judges were the community DBAs…

SQL SERVER – Powershell – Get a List of Fixed Hard Drive and Free Space on Server

November 27, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Powershell, SQL Scripts, SQL Stored Procedure

Earlier I have written this article SQL SERVER – Get a List of Fixed Hard Drive and Free Space on Server. I recently received excellent comment by MVP Ravikanth. He demonstrated that how the same can be done using Powershell. It is very sweet and quick solution. Here is the…

SQL SERVER – Get Directory Structure using Extended Stored Procedure xp_dirtree

November 26, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Stored Procedure

Many years ago I wrote article SQL SERVER – Get a List of Fixed Hard Drive and Free Space on Server where I demonstrated using undocumented Stored Procedure to find the drive letter in local system and available free space. I received question in email from reader asking if there any…

SQL SERVER – DVM sys.dm_os_sys_info Column Name Changed in SQL Server 2012

November 25, 2011

Pinal Dave

SQL Tips and Tricks

SQL DMV, SQL Server

SQL SERVER – DVM sys.dm_os_sys_info Column Name Changed in SQL Server. Let us learn about it in today’s blog post.

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 – 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,…

SQL SERVER – Puzzle to Win Print Book – Explain Value of PERCENTILE_CONT() Using Simple Example

November 21, 2011

Pinal Dave

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

SQL Function, SQL Scripts

From last several days I am working on various Denali Analytical functions and it is indeed really fun to refresh the concept which I studied in the school. Earlier I wrote article where I explained how we can use PERCENTILE_CONT() to find median over here SQL SERVER – Introduction to PERCENTILE_CONT()…