SQL Server Archives - Page 215 of 393 - SQL Authority with Pinal Dave

SQL SERVER – A Successful Performance Tuning Seminar – Hyderabad – Nov 27-28, 2010 – Next Pune

December 3, 2010

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

My recent SQL Server Performance Tuning Seminar in Colombo was oversubscribed with total of 35 attendees. You can read the details over here SQLAuthority News – SQL Server Performance Optimizations Seminar – Grand Success – Colombo, Sri Lanka – Oct 4 – 5, 2010. I had recently completed another seminar in…

SQLAuthority News – Community Tech Days – A SQL Legends in Ahmedabad – December 11, 2010

December 2, 2010

Pinal Dave

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

MVP

Ahmedabad is going to be fortunate city again on December 11. We are going to have SQL Server Legends present at the prestigious event of Community Tech Days in Ahmedabad. The venue details are as following: H K Hall, H K College Campus, Near Handloom House, Opp. Natraj Cinema, Ashram…

SQL SERVER – 3 Simple Puzzles – Need Your Suggestions

December 1, 2010

Pinal Dave

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…