SQL Scripts Archives - Page 219 of 318 - SQL Authority with Pinal Dave

SQL SERVER – Automated Type Conversion using Expressor Studio

November 30, 2010

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

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 – 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 – 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 – SQL Server Performance Series Hyderabad / Pune – Nov/Dec 2010

November 18, 2010

Pinal Dave

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

SQL Scripts

Just a quick note that SQL Server Performance Tuning and Optimizations Seminar series which I am offering at Hyderabad and Pune are almost all sold out. Read the details of the earlier successful seminar conducted at Colombo, Sri Lanka over here. Hyderabad Nov 27-28, 2010 (Last 3 Seats Left) Best…

SQL SERVER – Information Related to DATETIME and DATETIME2

November 15, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime, SQL Scripts

I recently received interesting comment on the blog regarding workaround to overcome the precision issue while dealing with DATETIME and DATETIME2. I have written over this subject earlier over here. SQL SERVER – Difference Between GETDATE and SYSDATETIME SQL SERVER – Difference Between DATETIME and DATETIME2 – WITH GETDATE SQL…

SQL SERVER – FIX ERROR 3702 Cannot drop database “MyDBName” because it is currently in use

November 14, 2010

Pinal Dave

SQL

SQL Error Messages, SQL Scripts, SQL Server

I often go to do various seminars and presentations at various organizations. During presentations I often create and drop various databases for the demonstration’s purpose. Recently in one of the presentations, I tried to remove my recently created database, I got following error 3702 which is related to user cannot drop database.