All Articles - SQL Authority with Pinal Dave

SQL SERVER – Asynchronous Update and Timestamp – Check if Row Values are Changed Since Last Retrieve

December 11, 2012

Here is the question received just this morning. “Pinal, Our application is much different than other application you might have come across. In simple words, I would like to call it Asynchronous Updated Application. We need your quick opinion about one of the situation which we are facing. From business…

SQL SERVER – Get 2 of My Books FREE at Tech Day – Where Technologies Converge!

December 10, 2012

Pinal Dave

SQLAuthority News

SQL Book, SQL Training, SQLAuthority Author Visit

As a regular reader of my blog – you must be aware of that I love to write books and talk about various subjects of my books. They have been my biggest supporter of my books. Coming weekend they have a tech day event at their Bangalore Location.

SQL Authority News – Download SQL Server Data Type Conversion Chart

December 9, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Download

Datatypes are very important concepts of SQL Server and there are quite often need to convert them from one datatypes to another datatype. I have seen that deveoper often get confused when they have to convert the datatype. There are two important concept when it is about datatype conversion. Implicit…

SQL SERVER – Weekly Series – Memory Lane – #006

December 8, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Memory Lane

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…

SQLAuthority News – Technology and Online Learning – Personal Technology Tip

December 7, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Training

This is the fourth post in my series about Personal Technology Tips and Tricks, and I knew exactly what I wanted to write about. But at first I was conflicted. Is online learning really a personal tip? Is it really a trick that no one knows? However, I have decided…

SQL SERVER – Caption the Cartoon Contest – Last 2 Days

December 6, 2012

Pinal Dave

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 – Find Referenced or Referencing Object in SQL Server using sys.sql_expression_dependencies

December 2, 2012

Pinal Dave

SQL Tips and Tricks

SQL DMV, SQL Scripts, SQL Server, SQL Utility

Let us learn in this blog about sys.sql_expression_dependencies.

A very common question which I often receive are:

How do I find all the tables used in a particular stored procedure?

How do I know which stored procedures are using a particular table?