Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – Get Common Records From Two Tables Without Using Join

October 17, 2008

I really enjoy answering questions which I receive from either comments or Email. My passion is shared by SQL Server Expert Imran Mohammed. He frequently SQL community members by answering their questions frequently and promptly. Sachin Asked: Following is my scenario, Suppose Table 1 and Table 2 has same column…

SQLAuthority News – Ahmedabad SQL Server User Group Meeting – October 2008

October 17, 2008

Pinal Dave

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

MVP, SQL User Group, SQLAuthority Author Visit

Tomorrow is third Saturday of the Month and every third Saturday we have Ahmedabad User Group Meeting. Our user group is growing and getting interesting. Everybody who attended last months User Group (UG) Meeting realized that how important it is to attend UG meetings. UG President Jacob Sebastian (SQL Server…

SQL SERVER – Downgrade Database to Previous Version

October 16, 2008

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Database, Software Development

Today I am writing on the topic which I do not like to write much. I enjoy writing usually positive or affirmative posts. Recently I got email from two different DBA where they upgraded to SQL Server 2005 trial version on their production server and now as their trial version…

SQL SERVER – Introduction and Example of UNION and UNION ALL

October 15, 2008

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Joins, SQL Scripts, SQL Union clause

It is very much interesting when I get request from blog reader to re-write my previous articles. I have received few request to rewrite my article SQL SERVER – Union vs. Union All – Which is better for performance? wi.th examples. I request you to read my previous article first…

SQL SERVER – Get Numeric Value From Alpha Numeric String – UDF for Get Numeric Numbers Only

October 14, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts, SQL String

SQL is great with String operations. Many times, I use T-SQL to do my string operation. Let us see User Defined Function, which I wrote few days ago, which will return only Numeric values from AlphaNumeric values. CREATE FUNCTION dbo.udf_GetNumeric (@strAlphaNumeric VARCHAR(256)) RETURNS VARCHAR(256) AS BEGIN DECLARE @intAlpha INT SET @intAlpha =…

SQLAuthority News – Book Review – Pro SQL Server 2005 Replication (Definitive Guide)

October 13, 2008

Pinal Dave

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

Database, DBA, SQL Backup and Restore, SQL Data Storage, SQL Replication, SQLAuthority Book Review

Pro SQL Server 2005 Replication (Definitive Guide) (Hardcover) by Sujoy Paul (Author) Link to Amazon Quick Review: This is good book for any novice developer to start in the world of database replication implementation and maintenance. Replication is important part of highly availability and one book covers all the concept…

SQLAuthority News – SQL Injection – SQL Joke, SQL Humor, SQL Laugh

October 12, 2008

Pinal Dave

SQLAuthority News

Best Practices, Database, DBA, SQL Humor, SQL Server Security

It has been a long time since I wrote about SQL Humor. Following is the cartoon sent to me by many (more than 10 times) so far by many users. I did not publish it till now as it has been quite popular and I believed many people had already seen it. However, recently by one of the quite big personality asked me why I have not included this in my blog, so I have finally decided to include that in my blog. Let us read humor about SQL Injection.