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

SQL SERVER – 3 Simple Puzzles – Need Your Suggestions

December 1, 2010

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

Last Month, I have posted three Simple Puzzles and I got very good response. I think there can be many interesting answers there. I would like to request all of you to take part the puzzles and provide your answer. I plant to consolidate answers and publish all the valid…

SQL SERVER – Automated Type Conversion using Expressor Studio

November 30, 2010

Pinal Dave

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

Database, SQL Scripts, SSIS

Recently I had an interesting situation during my consultation project. Let me share to you how I solved the problem using Expressor Studio. Consider a situation in which you need to read a field, such as customer_identifier, from a text file and pass that field into a database table. In…

SQL SERVER – DBA or DBD? – Database Administrator or Database Developer

November 29, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, DBA

Earlier this month, I had poll on this blog where I asked question – Are you a Database Administrator or Database Developer? The word DBA (Database Administrator) is very common but DBD (Database Developer) is not common at all. This made me think – what is the ratio of the…

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

November 28, 2010

Pinal Dave

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

SQL Scripts

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