All Articles - SQL Authority with Pinal Dave

SQL SERVER – Challenge – Puzzle – Why does RIGHT JOIN Exists

November 28, 2010

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

I had interesting conversation with the attendees of the my SQL Server Performance Tuning course. I was asked if LEFT JOIN can do the same task as RIGHT JOIN by reserving the order of the tables in join, why does RIGHT JOIN exists? The definitions are as following: Left Join…

SQL SERVER – Puzzle – Challenge – Error While Converting Money to Decimal

November 27, 2010

Pinal Dave

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

SQL Error Messages, SQL Scripts

Earlier I wrote SQL SERVER – Challenge – Puzzle – Usage of FAST Hint and I did receive some good comments. Here is another question to tease your mind. Run following script and you will see that it will thrown an error. DECLARE @mymoney MONEY; SET @mymoney = 12345.67; SELECT CAST(@mymoney…

SQL SERVER – Challenge – Puzzle – Usage of FAST Hint

November 26, 2010

Pinal Dave

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

I was recently working with various SQL Server Hints. After working for a day on various hints, I realize that for one hint, I am not able to come up with good example. The hint is FAST. Let us look at the definition of the FAST hint from the Book…

SQL SERVER – Concat Function in SQL Server – SQL Concatenation

November 25, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL String

Earlier this week, I was delivering Advanced BI training on the subject of “SQL Server 2008 R2”. I had a great time delivering the session. During the session, we talked about SQL Server 2012 Denali. Suddenly one of the attendees suggested his displeasure for the product. He said, even though,…

SQLAuthority News – What’s New in SQL Server “Denali”

November 24, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

I was today doing SQL Server Advanced Training at Bangalore and I had few attendees asked me if I can give them review of the SQL Server Denali. I had not downloaded Denali on my work computer so I could not do demonstration of the same. However, I promised to…

SQLAuthority News – SQLPASS Nov 8-11, 2010-Seattle – An Alternative Look at Experience

November 23, 2010

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

SQL PASS, SQLAuthority Author Visit

I recently attended most prestigious SQL Server event SQLPASS between Nov 8-11, 2010 at Seattle. I have only one expression for the event – Best Summit Ever This year the summit was at its best. Instead of writing about my usual routine or the event, I am going to write…

SQLAuthority News – Statistics and Best Practices – Virtual Tech Days – Nov 22, 2010

November 22, 2010

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks, SQLAuthority News

MVP, SQL Joins, SQL Statistics

I am honored that I have been invited to speak at Virtual TechDays on Nov 22, 2010 by Microsoft. I will be speaking on my favorite subject of Statistics and Best Practices. This exclusive online event will have 80 deep technical sessions across 3 days – and, attendance is completely…

SQL SERVER – Change Database Access to Single User Mode Using SSMS

November 21, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Management Studio

I have previously written about how using T-SQL Script we can convert the database access to single user mode before backup. I was recently asked if the same can be done using SQL Server Management Studio. Yes! You can do it from database property (Write click on database and select…

SQLAuthority News – Book Review – Beginning T-SQL 2008 by Kathi Kellenberger

November 20, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQLAuthority Book Review

Beginning T-SQL 2008 by Kathi Kellenberger Amazon Link Detail Review: Beginning T-SQL 2008 is one of the best books on the market if you are just beginning to work with Microsoft SQL, or have a little bit of experience and need to learn more quickly. Each chapter of the book…

SQLAuthority News – Blog Stats Revealed

November 19, 2010

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

I often receive praises, questions, suggestions and skeptical emails regarding my blog stats. Let me put everything aside and open up my stats page for all. I use wordpress.com and stats are maintained by them. Every month, I will put the blog stats on the following page for every one’s…