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

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

June 12, 2007

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

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…

SQL SERVER – Cannot Resolve Collation Conflict For Equal to Operation

June 11, 2007

Pinal Dave

SQL Tips and Tricks

Best Practices, SQL Collation, SQL Error Messages, SQL Joins, SQL Scripts, SQL Server

Cannot resolve collation conflict for equal to operation. In MS SQL SERVER, the collation can be set at the column level.

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

June 10, 2007

Pinal Dave

SQL Tips and Tricks

Best Practices, SQL DateTime, SQL Function, SQL Scripts, SQL Server

Just a week ago, my Database Team member asked me what is the best way to only select date part from datetime. When ran following command it also provide the time along with the date.

SQL SERVER – Fix : Error : An error has occurred while establishing a connect to the server. Solution with Images.

June 10, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Computer Network, SQL Error Messages

While reviewing my my blog search engine terms I find Error 40 is the most common error searched. I have previously wrote blog about how to fix this error here : SQL SERVER – Fix : Error : 40 – could not open a connection to SQL server. Today I…

SQL SERVER – Fix : Error : Msg 9514 Xml data type is not supported in distributed queries. Remote object ‘OPENROWSET’ has xml column(s)

June 9, 2007

Pinal Dave

SQL Tips and Tricks

SQL Error Messages, SQL Scripts, SQL Server, SQL XML

In this blog post we are going to learn how to fix XML Data Type related error.

SQL SERVER – Spatial Database Definition and Research Documents

June 9, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Spatial Database

Recently I was asked in meeting of SQL SERVER user group, what my opinion about spatial database. I answered from my basic knowledge. Spatial database is like database of space (not the star wars or star trek kind space). SQL Server database can understand the numeric and string values. If…