SQL Error Messages Archives - Page 83 of 114 - SQL Authority with Pinal Dave

SQL SERVER – Error Msg 511 using SQL Server Sparse columns

May 30, 2015

SPARSE Columns, SQL Error Messages, SQL Scripts

When I wrote the previous post around SQL SERVER – CREATE TABLE Failed Because Column ‘C1024′ in Table ‘myTable’ Exceeds the Maximum of 1024 Columns, I thought it was a simple concept. Lesser did I know that there can be something wrong. One of my blog reader said they were getting…

SQL SERVER – Using 20 Logical Processors Based on SQL Server Licensing

May 29, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

It is second to human nature to utilize every bit of juice for what we pay. You buy something and you would like to get the best out of it right? If you start thinking from an organizations point of view, they think they should buy something which satisfies their…

SQL SERVER – Service Pack Error – The User Data directory in the registry is not valid. Verify DefaultData key under the instance hive points to a valid directory

May 16, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

As a good SQL Server DBA, I always keep updating my SQL Server on my all VMs with the latest service pack available. During my last installation of service pack 2 on SQL Server 2012, I got below error. The User Data directory in the registry is not valid. Verify…

SQL SERVER – WARNING – SQL Server Has Encountered N Occurrence(s) of I/O Requests Taking Longer Than 15 Seconds

May 15, 2015

Pinal Dave

SQL Tips and Tricks

SQL Counter, SQL DMV, SQL Error Messages, SQL Log, SQL Server

This is one of the most commonly asked questions via blog comments and emails sent across to me. Here is the sample error message which has been reported in SQL Server ERRORLOG. Let us learn about how to fix occurrences of I/O Requests taking longer.

SQL SERVER – Backup Failure – Error: 3203, Severity: 16, State: 1

May 8, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Error Messages

In the recent past, I have been writing about different error messages on SQL Server that one encounters. Thanks to my blog readers who have been sharing a lot of errors with me either by email or by blog comments and asking for solution. If I find something interesting and…

SQL SERVER – Login Failed For User – Reason Server is in Script Upgrade Mode

April 10, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

I just can’t get enough of the error messages that land into my Inbox almost every single day. I do my due diligence of making a search in my blogs and I try to hang around in the forums from time to time to learn what people are getting as…

SQL SERVER – Where is ERRORLOG? Various Ways to Find ERRORLOG Location

March 24, 2015

Pinal Dave

SQL Tips and Tricks

SQL Error Messages, SQL Log, SQL Scripts, SQL Server

Whenever someone reports some weird error on my blog comments or sends email to know about it, I always ask to share SQL Server ERRORLOG file. There have been many occasions where I need to guide them to find location of ERRORLOG file generated by SQL Server. Most DBA’s are intelligent and know some of these, but this is my try to share my learning about ERRORLOG location.