May 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
Jul15

SQL SERVER – Find Column Used in Stored Procedure – Search Stored Procedure for Column Name

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Stored Procedure
28 Comments
Place: Any Developer Shop Scenario: A developer wants to drop a column from a table Time: Any Day – usually right before developer wants to go home The developer rushes to the manager and following conversation begins: Developer: I want to drop  a column from one of the tables. Manager:…
Read More
Jul14

SQL SERVER – Example of Width Sensitive and Width Insensitive Collation

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
9 Comments
I had a great time writing blog post SQL SERVER – Effect of Case Sensitive Collation on Resultset. It was interesting to see lots of questions related to collation based on this blog post. However, one of the question, I find very interesting and though to share today here. Question: What is…
Read More
Jul13

SQL SERVER – Switch Between Two Parenthesis using Shortcut CTRL+]

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Shortcut
5 Comments
Earlier this week I wrote a blog post about SQL SERVER – CTRL+SHIFT+] Shortcut to Select Code Between Two Parenthesis, I received quite a lot of positive feedback from readers. If you are a regular reader of the blog post, you must be aware that I appreciate the learning shared by…
Read More
Jul12

SQL SERVER – Effect of Case Sensitive Collation on Resultset

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
3 Comments
Collation is a very interesting concept but I quite often see it is heavily neglected. I have seen developer and DBA looking for a workaround to fix collation error rather than understanding if the side effect of the workaround. Collation is a very deep subject. Earlier I wrote an article…
Read More
Jul11

SQL SERVER – Remove Debug Button in SSMS – SQL in Sixty Seconds #020 – Video

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQL Video
Database, SQL in Sixty Seconds, SQL Scripts, SQL Server Management Studio
5 Comments
SQL in Sixty Seconds is indeed tremendous fun to do. Every week, we try to come up with some new learning which we can share in Sixty Seconds. In this busy world, we all have sixty seconds to learn something new – no matter how much busy we are. In…
Read More
Jul10

SQLAuthority News – Lessons from Life and Work by Srini Chandra (Author of 3 Lives, In search of Bliss)

Pinal Dave
Personal
SQLAuthority Book Review
13 Comments

I requested Srini Chandra (renowned author of Amazon Best Seller 3 Lives, in search of bliss to write a guest post on this subject which developer can read and appreciate.

Read More
Jul9

SQL SERVER – Monday Morning Puzzle – Query Returns Results Sometimes but Not Always

Pinal Dave
SQL, SQL Interview Questions and Answers, SQL Puzzle, SQL Server, SQL Tips and Tricks
16 Comments
The amount of email I receive sometime it is impossible for me to answer every email. Nonetheless I try to answer pretty much every email I receive. However, quite often I receive such questions in email that I have no answer to them because either emails are not complete or they…
Read More
Previous 1 … 515 516 517 518 519 520 521 … 830 Next
SQL SERVER - FIX: Setup Was Not Able to Access Domain clpk3

SQL SERVER – Identify Table Where Clustered Index is Not a Primary Key – DMV

SQL SERVER - FIX: Setup Was Not Able to Access Domain computed1

SQL SERVER – Computed Column and Conditions with Case Statement

Hey DBAs – What Are You Assuming/Missing Today? – Notes from the Field #122

SQL SERVER - FIX: Setup Was Not Able to Access Domain scalability-vertical-horizontal-01-800x447

Understanding Database Scalability – Vertical and Horizontal

SQL SERVER - FIX: Setup Was Not Able to Access Domain select-1-by-2-puzzle-01

SELECT One by Two – Interview Question Extended – Part II

SQL SERVER - FIX: Setup Was Not Able to Access Domain insertmultiple-3-800x395

How to Insert Multiple Rows in a Single SQL Query – Interview Question of the Week #069

SQL SERVER - FIX: Setup Was Not Able to Access Domain Status-dialog-error-icon-800x800

SQL SERVER – FIX: Setup Was Not Able to Access Domain

Previous 1 … 515 516 517 518 519 520 521 … 830 Next

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 22 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 104 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.


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