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

SQLAuthority News – Download SQL Server 2005 Service Pack 3 – CTP

October 29, 2008

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

The CTP version of SQL Server 2005 Service Pack 3 (SP3) is now available. You can use these packages to upgrade any of the following SQL Server 2005 editions: Enterprise Enterprise Evaluation Developer Standard Workgroup For a summary list of What’s new in SQL Server 2005 SP3 CTP, review the…

SQL SERVER – INNER JOIN using LEFT JOIN statement – Performance Analysis

October 25, 2008

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Joins, SQL Scripts

Just a day ago, while I was working with JOINs I find one interesting observation, which has prompted me to create following example. Before we continue further let me make very clear that INNER JOIN should be used where it can not be used and simulating INNER JOIN using any…

SQLAuthority News – Running SQL Server 2008 in a Hyper-V Environment Best Practices and Performance Considerations

October 22, 2008

Pinal Dave

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

Best Practices, Database, SQL Download, SQL White Papers

Hyper-V in Windows Server 2008 is a powerful virtualization technology that can be used by corporate IT to consolidate under-utilized servers, lowering TCO and maintaining or improving Quality of Service. Through a series of test scenarios that are representative of SQL Server application fundamentals, this document provides best practice recommendations…

SQL SERVER – Fix : Error : Incorrect syntax near. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the stored procedure sp_dbcmptlevel

October 21, 2008

Pinal Dave

SQL Tips and Tricks

SQL Error Messages, SQL Scripts, SQL Server, SQL Server Security, SQL Stored Procedure

I have seen developers confused many times when they receive the following error message. Incorrect syntax near. Let us learn.

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

October 20, 2008

Pinal Dave

SQL Tips and Tricks

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…