SQL Archives - Page 238 of 519 - SQL Authority with Pinal Dave

SQL SERVER – Caption the Cartoon Contest – Last 2 Days

December 6, 2012

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

Developer’s life is very interesting, we often want to start my day early at a job so we can go home early. However, the day never comes as the life of the developer is always about working late hours. If the developer goes to the office early – there are…

SQL SERVER – Concat Strings in SQL Server using T-SQL – SQL in Sixty Seconds #035 – Video

December 5, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQL Video

Database, SQL in Sixty Seconds, SQL Scripts, SQL Server Management Studio

Concatenating string is one of the most common tasks in SQL Server and every developer has to come across it. We have to concat the string when we have to see the display full name of the person by first name and last name. In this video we will see…

SQL SERVER – Fix: Error : 402 The data types ntext and varchar are incompatible in the equal to operator

December 4, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

Some errors are very simple to understand but the solution of the same is not easy to figure out. Here is one of the similar errors where it clearly suggests where the problem is but does not tell what is the solution. Additionally, there are multiple solutions so developers often…

SQL SERVER – Fix Error: Microsoft OLE DB Provider for SQL Server error ‘80040e07’ or Microsoft SQL Native Client error ‘80040e07’

December 3, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime, SQL Error Messages

I quite often receive questions where users are looking for solution to following error: Microsoft OLE DB Provider for SQL Server error ‘80040e07’ Syntax error converting datetime from character string. OR Microsoft SQL Native Client error ‘80040e07’ Syntax error converting datetime from character string. If you have ever faced above…

SQL SERVER – Weekly Series – Memory Lane – #005

December 1, 2012

Pinal Dave

SQL

Memory Lane

This article is the 5th edition in the memory lane series. Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here with additional notes below it. Let me know which one of the following is your favorite article from memory lane.

SQL SERVER – Fix Visual Studio Error : Connections to SQL Server files (.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component or download from the URL

November 30, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, sqlcmd

In one of the virtual environment while I was trying to add SQL Server Database (.mdf) file to asp.net project I encountered following error: Connections to SQL Server files (.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component or download from the URL: …

SQL SERVER – Shard No More – An Innovative Look at Distributed Peer-to-peer SQL Database

November 27, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

NuoDB

There is no doubt that SQL databases play an important role in modern applications. In an ideal world, a single database can handle hundreds of incoming connections from multiple clients and scale to accommodate the related transactions. However the world is not ideal and databases are often a cause of…