SQL Tips and Tricks Archives - Page 341 of 536 - 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…