Feb 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
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check
Nov2

SQL SERVER – Basics ColumnStore FAQ – Part II

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
ColumnStore Index, SQL Index
2 Comments
I wrote the first part of FAQ in here. This is not a typical blog post but more of a process oriented topic when working with ColumnStore Indexes. With the advancements done in SQL Server 2016, I know that this is going to be even more critical to understand some…
Read More
Nov1

SQLAuthority News – 9th Year Blog Anniversary

Pinal Dave
Personal, SQL, SQL Server, SQL Tips and Tricks
SQL Milestone
16 Comments
Today is an amazing day! 9 years ago on this day, I started to write this blog. Since then I am producing one blog post a day everyday! During this year there are so many changes have happened in the blog and my professional career as well as on my…
Read More
Oct31

Interview Question of the Week #043 – What is the Difference Between EXCEPT operator vs. NOT IN

Pinal Dave
SQL Interview Questions and Answers
SQL Joins, SQL Scripts, SQL Server
7 Comments

Question: What is the Difference Between EXCEPT operator vs. NOT IN. Let us learn the answer to this question in this blog post.

Read More
Oct30

SQL SERVER – Adding Datetime and Time Values Using Variables

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL DateTime
11 Comments
Datetime datatype stores date and time part. If you have only date value, You can add time part to a datetime variable using direct literal value and + operator. It is shown below DECLARE @date DATETIME SET @date='2010-10-01' SET @date=@date+'15:00:00' SELECT @date AS DATETIME The result is 2010-10-01 15:00:00.000 But…
Read More
Oct29

SQL SERVER – Who is consuming CPU on my SQL Server?

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL CPU
4 Comments
The topics around performance tuning is always interesting and I get quizzed by a number of you during conferences on these topic areas post my presentation. A relatively simple yet a powerful question was asked by one of the attendee in my session at MODS (Mobile Developer Conference) this year.…
Read More
Oct28

SQL SERVER – What is Semantics Search Inside SQL Server?

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
3 Comments
Every now and then I bump into stuffs that I didn’t even hear about when it comes to working with SQL Server. This time I heard the word Semantics Search and was wondering where and when did it come. In this blog, I will put the foundation for this and…
Read More
Oct27

SQL SERVER – Script level upgrade for database ‘master’ failed – CREATE SCHEMA failed due to previous errors

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Error Messages
3 Comments
SQL Server troubleshooting topics seem to be the most searched for in this blog. In continuation to this, blog for today is also inspired with one such error message. Some time back I have written below blog which talks about upgrade script mode of SQL Server: SQL SERVER – Login…
Read More
Previous 1 … 335 336 337 338 339 340 341 … 829 Next

SQLAuthority News – Last Post of Year 2012

SQLAuthority News – Resolutions of Year 2013 – Commitment to Myself

SQL SERVER – Wrap SQL Code in SSMS – SQL in Sixty Seconds #038 – Video

SQLAuthority News - Download Whitepaper - Cleanse and Match Master Data by Using EIM wheredidtheycomefrom-619x423

SQLAuthority News – Year 2012 in Review – Perspective of Blog

SQL SERVER – An Interesting Case of Redundant Indexes – Index on Col1, Col2 and Index on Col1, Col2, Col3 – Part 1

SQLAuthority News - Download Whitepaper - Cleanse and Match Master Data by Using EIM infosys2

SQL SERVER – Cursor, Truncate Log and More – Memory Lane #010

SQLAuthority News – Download Whitepaper – Cleanse and Match Master Data by Using EIM

Previous 1 … 335 336 337 338 339 340 341 … 829 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