Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – 2005 TOP Improvements/Enhancements

May 2, 2007

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

SQL Server 2005 introduces two enhancements to the TOP clause. 1) User can specify an expression as an input to the TOP keyword. 2) User can use TOP in modification statements (INSERT, UPDATE, and DELETE). Explanation : User can specify an expression as an input to the TOP keyword. In…

SQL SERVER – User Defined Functions (UDF) to Reverse String – UDF_ReverseString

May 1, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts, SQL String

UDF_ReverseString UDF_ReverseString User Defined Functions returns the Reversed String starting from certain position. First parameters takes the string to be reversed. Second parameters takes the position from where the string starts reversing. Script of UDF_ReverseString function to return Reverse String. CREATE FUNCTION UDF_ReverseString ( @StringToReverse VARCHAR(8000), @StartPosition INT ) RETURNS…

SQL SERVER – Copy Column Headers in Query Analyzers in Result Set

May 1, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Best Practices

Copy Column Headers in Query Analyzers in Result Set. In Query Analyzer go to Menu >> Tools >> Options >> Results Select Default results Target: Results to Text Results output format:(*): Tab Delimited Print column headers(*): Checkbox ON(check) [youtube=http://www.youtube.com/watch?v=BL5GO-jH3HA] Reference : Pinal Dave (https://blog.sqlauthority.com)

SQLAuthority.com 100th Post – Gratitude Note to Readers

May 1, 2007

Pinal Dave

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

Hello All, I would like to express my deep gratitude to all of my readers for their emails, comments, suggestions and continuous support on the occasion of 101st post on this blog. I would like to extend my gratitude to my parents. In good times or trying times my parents…

SQL SERVER – Collate – Case Sensitive SQL Query Search

April 30, 2007

Pinal Dave

SQL Tips and Tricks

SQL Collation, SQL Scripts, SQL Search, SQL Server, SQL Utility

In this blog post we are going to learn about how to do Case Sensitive SQL Query Search.

If Column1 of Table1 has following values ‘CaseSearch, casesearch, CASESEARCH, CaSeSeArCh’, following statement will return you all the four records.

SQL SERVER – FIX : ERROR : Msg 3159, Level 16, State 1, Line 1 – Msg 3013, Level 16, State 1, Line 1

April 30, 2007

Pinal Dave

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

SQL Backup and Restore, SQL Error Messages, SQL Scripts, SQL Server Security

While moving some of the script from SQL SERVER 2000 to SQL SERVER 2005 our migration team faced following error. Msg 3159, Level 16, State 1, Line 1 The tail of the log for the database “AdventureWorks” has not been backed up. Use BACKUP LOG WITH NORECOVERY to backup the…

SQL SERVER – SET ROWCOUNT – Retrieving or Limiting the First N Records from a SQL Query

April 30, 2007

Pinal Dave

SQL Tips and Tricks

SQL Cursor, SQL Scripts, SQL Server, SQL Server Security

A SET ROWCOUNT statement simply limits the number of records returned to the client during a single connection. As soon as the number of rows specified is found, SQL Server stops processing the query. The syntax looks like this: