May Discount: Comprehensive Database Performance Health Check | Testimonials

SQL SERVER – @@IDENTITY vs SCOPE_IDENTITY() vs IDENT_CURRENT – Retrieve Last Inserted Identity of Record

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
, ,
SELECT @@IDENTITY It returns the last IDENTITY value produced on a connection, regardless of the table that produced the value, and regardless of the scope of the statement that produced the value. @@IDENTITY will return the last identity value entered into a table in your current session. While @@IDENTITY is…
Read More

SQL SERVER – SQL Commandments – Suggestions, Tips, Tricks

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
, , , , , , , , , , , , ,
Few days ago, while searching for something on web site, I came across a very good article of 25 SQL Commandments. I really enjoyed reading it. It was for Oracle, I re-wrote it for SQL Server. First 18 points are taken from original article and last 2 I added to…
Read More

SQL SERVER – Script to Determine Which Version of SQL Server 2000-2005 is Running

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
,
To determine which version of SQL Server 2000/2005 is running, connect to SQL Server 2000/2005 by using Query Analyzer, and then run the following code: SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition') The results are: The product version (for example, 8.00.534). The product level (for example, “RTM” or “SP2”). The edition…
Read More

SQL SERVER – UDF – Function to Convert Text String to Title Case – Proper Case

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
, ,
Following function will convert any string to Title Case. I have this function for long time. I do not remember that if I wrote it myself or I modified from original source. Run Following T-SQL statement in query analyzer: SELECT dbo.udf_TitleCase('This function will convert this string to title case!') The…
Read More
Menu