Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – Transaction and Local Variables – Swap Variables – Update All At Once Concept

October 20, 2008

SQL Scripts, SQL Server, SQL Server Security, SQL Transactions

This article is inspired from two sources. Let us learn today about how to swap variables by updating everything at once concepts.

1) My year old article – SQL SERVER – Effect of TRANSACTION on Local Variable – After ROLLBACK and After COMMIT
2) Discussion with SQL Server MVP – Jacob Sebastian – SQLAuthority News – Author Visit – SQL Hour at Patni Computer Systems

I usually summarize my article at the end, but this time let me summarize first and we will understand the article next.

SQL SERVER – Introduction to CLR – Simple Example of CLR Stored Procedure

October 19, 2008

Pinal Dave

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

CLR, Software Development, SQL Scripts, SQL Stored Procedure, SQL Utility

CLR is abbreviation of Common Language Runtime. In SQL Server 2005 and later version of it database objects can be created which are created in CLR. Stored Procedures, Functions, Triggers can be coded in CLR. CLR is faster than T-SQL in many cases. CLR is mainly used to accomplish task…

SQL SERVER – Retrieve – Select Only Date Part From DateTime – Best Practice – Part 2

October 18, 2008

Pinal Dave

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

Best Practices, SQL DateTime, SQL Function, SQL Scripts

A year ago I wrote post about SQL SERVER – Retrieve – Select Only Date Part From DateTime – Best Practice where I have discussed two different methods of getting datepart from datetime. Method 1: SELECT DATEADD(D, 0, DATEDIFF(D, 0, GETDATE())) Method 2: SELECT CONVERT(VARCHAR(10),GETDATE(),111) I have summarized my post…

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

October 17, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Joins, SQL Scripts

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…