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

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

July 3, 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 a Stored Procedure? A stored procedure is a named group of SQL statements that have been…

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

July 2, 2011

Pinal Dave

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 1) General Questions on SQL SERVER What is RDBMS? Relational Data Base Management Systems (RDBMS) are database management…

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

July 1, 2011

Pinal Dave

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

Click here to get free chapters (PDF) in the mailbox List of all the Interview Questions and Answers Series blogs Posts covering interview questions and answers always make for interesting reading. Some people like the subject for their helpful hints and thought provoking subject, and others dislike these posts because…

SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Complete Downloadable List – Day 0 of 31

July 1, 2011

Pinal Dave

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

SQL Documentation, SQL Download

This blog post is running list of the blog posts in the series of Interview Questions and Answers. At the end of the 31st day of the month, a FREE PDF will be posted here which can be downloadable for offline review. SQL SERVER – Interview Questions and Answers –…

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…

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