Jun 2026 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
  • Hire Me
  • Health Check
Jun4

SQL SERVER – Basic Statistics Maintenance – Notes from the Field #083

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Notes from the Field, SQL Server Security, SQL Statistics
9 Comments
[Note from Pinal]: This is a 83rd episode of Notes from the Field series. Maintenance of the database is very critical activity and I have always seen DBA taking it very seriously. There is a only one problem – there is no single solution or guidance for how to maintain the database.…
Read More
Jun3

SQL SERVER – Finding Out Identity Column Without Using Column Name

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Identity
5 Comments
There is an interesting observation when querying the identity column of a table Let us create the following tables CREATE TABLE test1 ( id INT IDENTITY (1,1) ) GO CREATE TABLE test2 ( id INT ) Note that the table test1 has identity column and table test2 does not have…
Read More
Jun2

SQL SERVER – Errors and Limitations of Working with SPARSE Columns in SQL Server

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SPARSE Columns, SQL Error Messages
1 Comment
I make a visit to the local user group whenever I get and keeping the community juices up and running for me. I get an opportunity to share some of the learnings and meet tons of new people. In our recent meetup at the SQLBangalore UG, I met a lot…
Read More
Jun1

SQL SERVER – Restore Error: Specified cast is not valid (SqlManagerUI)

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Error Messages
24 Comments
As I always say, Errors are a great source of learning and I am fortunate to have you as my readers. Because one of my blog reader reported an interesting issue which is worth blogging. This is his initial email: Hi Pinal, Your blogs have been very helpful to me…
Read More
May31

Interview Question of the Week #022 – How to Get Started with Big Data?

Pinal Dave
Big Data, SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks
No Comments
Big data is one of the most popular subject in recent time and everybody wants to get started on this subject. During recent interviews there are plenty of the questions with related to Big Data. Here is the most popular question which I receive on this subject. Question: How to…
Read More
May30

SQL SERVER – Error Msg 511 using SQL Server Sparse columns

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SPARSE Columns, SQL Error Messages, SQL Scripts
No Comments
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…
Read More
May29

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

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Error Messages
9 Comments
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…
Read More
Previous 1 … 358 359 360 361 362 363 364 … 831 Next

SQL SERVER – Basic Statistics Maintenance – Notes from the Field #083

SQL SERVER – Finding Out Identity Column Without Using Column Name

SQL SERVER – Errors and Limitations of Working with SPARSE Columns in SQL Server

SQL SERVER – Restore Error: Specified cast is not valid (SqlManagerUI)

Interview Question of the Week #022 – How to Get Started with Big Data?

SQL SERVER – Error Msg 511 using SQL Server Sparse columns

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

Previous 1 … 358 359 360 361 362 363 364 … 831 Next

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.

Comprehensive Database Performance Health Check

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.


SQL Server Performance Tuning Practical Workshop

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.


  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com