SQL Tips and Tricks Archives - Page 513 of 535 - SQL Authority with Pinal Dave

SQL SERVER – Easy Sequence of SELECT FROM JOIN WHERE GROUP BY HAVING ORDER BY

June 14, 2007

I was called many times by Jr. Programmers in team to debug their SQL. I keep log of most of the problems and review them afterwards. This helps me to evaluate my team and identify most important next thing which I can do to improve the performance and productivity of…

SQL SERVER – Explanation SQL SERVER Hash Join

June 14, 2007

Pinal Dave

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

SQL Joins

Hash Join works with large data set. I have seen this join used many times in data warehouses applications as well as data mining algorithms. While its characteristics are similar to merge join it does not required ordered result set to join. Hash join requiresequijoin predicate to join tables. Equijoin…

SQL SERVER – Fix : Error 8629 The query processor could not produce a query plan from the optimizer because a query cannot update a text, ntext, or image column and a clustering key at the same time.

June 13, 2007

Pinal Dave

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

SQL Error Messages, SQL Server

Error : 8629 The query processor could not produce a query plan from the optimizer because a query cannot update a text, ntext, or image column and a clustering key at the same time.

SQL SERVER – Download 2005 Books Online (May 2007)

June 13, 2007

Pinal Dave

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

SQL Download

Microsoft has merged SQL Server 2005 Expressed to SQL Server 2005 Books Online. New Version of SQL Server 2005 Books Online is released on June 12, 2007. Download SQL Server Books Online (BOL) Reference : Pinal Dave (https://blog.sqlauthority.com)

SQL SERVER – Recovery Models and Selection

June 13, 2007

Pinal Dave

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

SQL Backup and Restore, SQL Coding Standards, SQL Data Storage, SQL Scripts, SQL Server Security

SQL Server offers three recovery models: full recovery, simple recovery and bulk-logged recovery. The recovery models determine how much data loss is acceptable and determines whether and how transaction logs can be backed up. Select Simple Recovery Model if: * Your data is not critical. * Losing all transactions since…

SQL SERVER – SQL Joke, SQL Humor, SQL Laugh – Funny Quotes

June 12, 2007

Pinal Dave

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

Database, SQL Humor

While searching WIKI I came across this oracle WIKI. I found this very funny. I have taken few quotes from this site. There are lot more stuff there. The degree of normality in a database is inversely proportional to that of its DBA. Program complexity grows until it exceeds the…

SQL SERVER – LEN and DATALENGTH of NULL Simple Example

June 12, 2007

Pinal Dave

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

SQL Function, SQL NULL, SQL Scripts

Simple but interesting – In recent survey I found that many developers making this generic mistake. I have seen following code in periodic code review. (The code below is not actual code, it is simple sample code) DECLARE @MyVar VARCHAR(10) SET @MyVar = NULL IF (LEN(@MyVar) = 0) … I…