Blog Home Page - Page 498 of 831 - SQL Authority with Pinal Dave

Dec4

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

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…

Dec3

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

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…

Dec2

SQL SERVER – Find Referenced or Referencing Object in SQL Server using sys.sql_expression_dependencies

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?

Dec1

SQL SERVER – Weekly Series – Memory Lane – #005

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.

Nov30

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

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: https://visualstudio.microsoft.com/vs/express/…

Nov29

SQL Contest – Win USD 300 Worth Gift – Cartoon Contest is Back

Pinal Dave

SQL Puzzle

Embarcadero, SQL Cartoon, SQL Humor, SQL Server

There are two excellent contests and we have lots of winning to do this year end. In this blog post we are going to have a cartoon contest again.

Nov28

SQL SERVER – Auto Recovery File Settings in SSMS – SQL in Sixty Seconds #034 – Video

Pinal Dave

SQL Video

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

Every developer once in a while facing an unfortunate situation where they have not yet saved the work and their SQL Server Management Studio crashes. Well, you can minimize the loss by optimizing auto recovery settings. In this video we can see how to set the auto recovery settings.

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

SQL SERVER - Auto Recovery File Settings in SSMS - SQL in Sixty Seconds #034 - Video references

SQL SERVER – Find Referenced or Referencing Object in SQL Server using sys.sql_expression_dependencies

SQL SERVER - Auto Recovery File Settings in SSMS - SQL in Sixty Seconds #034 - Video yestodelete-800x797

SQL SERVER – Weekly Series – Memory Lane – #005

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

SQL Contest – Win USD 300 Worth Gift – Cartoon Contest is Back

SQL SERVER – Auto Recovery File Settings in SSMS – SQL in Sixty Seconds #034 – Video

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 24 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.

Pinal has authored 14 SQL Server database books and 109 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.

Pinal is an experienced and dedicated professional with a deep commitment to flawless customer service. If you need help with any SQL Server Performance Tuning Issues, please feel free to reach out at pinal@sqlauthority.com.

Pinal is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).

Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long-term multi-channel campaigns to drive leads for their sales pipeline.

Shaivi Pinalkumar Dave is a book author and a women’s artistic gymnast.

Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.

Once you learn my business secrets, you will fix the majority of problems in the future.

Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.

Essentially I share my business secrets to optimize SQL Server performance.