SQL Scripts Archives - Page 206 of 318 - SQL Authority with Pinal Dave

SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 11 of 31

July 11, 2011

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

Click here to get free chapters (PDF) in the mailbox Please read the Introductory Post before continue reading interview question and answers. List of all the Interview Questions and Answers Series blogs What is Difference between Table Aliases and Column Aliases? Do they Affect Performance? Usually, when the name of…

SQL SERVER – Two Puzzles – Answer and Win USD 25 Gift Card

June 30, 2011

Pinal Dave

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

SQL Scripts

Today I have two simple T-SQL Puzzle. You can answer them and win USD 25 Gift card. The gift card will be sent in email to winner. You will get choice of Gift Card brand based on your preference and country location. Puzzle 1: What will be the outcome and…

SQL SERVER – Find Details for Statistics of Whole Database

June 29, 2011

Pinal Dave

SQL Performance

SQL DMV, SQL Scripts, SQL Server, SQL Statistics

I was recently asked is there a single script which can provide all the necessary details about statistics for any database.

SQLAuthority News – Monthly list of Puzzles and Solutions on SQLAuthority.com

June 28, 2011

Pinal Dave

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

SQL Scripts

This month has been very interesting month for SQLAuthority.com we had multiple and various puzzles which everybody participated and lots of interesting conversation which we have shared. Let us start in latest puzzles and continue going down. There are few answers also posted on facebook as well. SQL SERVER –…

SQL SERVER – Puzzle Involving NULL – Resolve – Error – Operand data type void type is invalid for sum operator

June 27, 2011

Pinal Dave

SQL Puzzle

SQL NULL, SQL Operator, SQL Scripts, SQL Server

Today is Monday let us start this week with interesting puzzle. Yesterday I had also posted quick question here: SQL SERVER – T-SQL Scripts to Find Maximum between Two Numbers

SQL SERVER – T-SQL Scripts to Find Maximum between Two Numbers

June 26, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

There are plenty of the things life one can make it simple. I really believe in the same. I was yesterday traveling for community related activity. On airport while returning I met a SQL Enthusiast. He asked me if there is any simple way to find maximum between two numbers…

SQL SERVER – Selecting Domain from Email Address

June 18, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

Recently I came across a quick need where I needed to retrieve domain of the email address. The email address is in the database table. I quickly wrote following script which will extract the domain and will also count how many email addresses are there with the same domain address.…