SQL Puzzle Archives - Page 25 of 28 - SQL Authority with Pinal Dave

SQL SERVER – Question – How to Convert Hex to Decimal

February 1, 2010

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

In one of the recent projects, I realize the bottleneck of the query was an inline function which was converting Hex to Decimal. I optimized the inline function and reduced the query running time to one-tenth of the original running time. Later, I was eager to find out the script…

SQL SERVER – Size of Index Table – A Puzzle to Find Index Size for Each Index on Table

November 18, 2009

Pinal Dave

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

SQL Index, SQL Scripts, SQL Stored Procedure

It is very easy to find out some basic details of any table using the following Stored Procedure. USE AdventureWorks GO EXEC sp_spaceused [HumanResources.Shift] GO Above query will return following resultset The above SP provides basic details such as rows, data size in table, and Index size of all the…

SQLAuthority News – First Editorial – T-SQL Challenges Beginners

October 14, 2009

Pinal Dave

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

I would like to welcome all of you to very first editorial for T-SQL Challenges for Beginners. T-SQL Challenges began with the aim to help community to come out of regular mind set of just reading articles online. There is plenty of reading material available online, but there are very…

SQL SERVER – Interesting Observation – Execution Plan and Results of Aggregate Concatenation Queries

September 29, 2009

Pinal Dave

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

SQL Index, SQL View

Working with SQL Server has never seems to be monotonous – no matter how long one has worked with it. Quite often, I come across some excellent comments that I feel like acknowledging them as blog posts. Recently, I wrote an article on SQL SERVER – Execution Plan and Results…

SQL SERVER – Interesting Observation – Index on Index View Used in Similar Query

September 24, 2009

Pinal Dave

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

SQL Index, SQL Scripts, SQL White Papers

Recently, I was working on an optimization project for one of the large organizations. While working on one of the queries, we came across a very interesting observation. We found that there was a query on the base table and when the query was run, it used the index, which…

SQL SERVER – Execution Plan and Results of Aggregate Concatenation Queries Depend Upon Expression Location

September 20, 2009

Pinal Dave

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

SQL Documentation

I was reading the blog of Ward Pond, and I came across another note of Microsoft. I really found it very interesting. The given explanation was very simple; however, I would like to rewrite it again. Let us execute the following script. This script inserts two values ‘A’ and ‘B’…

SQL SERVER – Discussion – Effect of Missing Identity on System – Real World Scenario

August 11, 2009

Pinal Dave

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

Database, DBA, SQL Constraint and Keys, SQL Index

About a week ago, SQL Server Expert, Imran Mohammed, provided a script, which will list all the missing identity values of a table in a database. In this post, I asked my readers if any could write a similar or better script. The results were interesting. While no one provided…