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
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
Oct26

SQL SERVER – Taking Backup Without Consuming Disk Space

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Backup and Restore
6 Comments
Long back, I learned this trick and found an interesting use of it. I totally understand that its very dangerous. Recently I have seen someone getting bitten by this so thought of sharing. Warning: Don’t do this in any production environment The trick here is to take backup on NUL…
Read More
Oct25

Interview Question of the Week #042 – How Does SPACE Function Works in SQL Server?

Pinal Dave
SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks
No Comments
This question may sound strange but I have personally observed this being asked in one of the interview. Question: How Does SPACE Function Works in SQL Server? Answer: SPACE function accepts one numeric parameter and generates as many as space as a value of the parameter. Observe the output of the…
Read More
Oct24

SQL SERVER – Simple Way to Find Existence of Column in a Table

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
2 Comments
If you want to check if the column is already available in the table, you can use system views like sys.columns or INFORMATION_SCHEMA.COLUMNS. Let us create this dataset USE TEMPDB; CREATE TABLE TESTING(ID INT, NAME VARCHAR(100)) Suppose you want to find out the existence of the column named NAME and…
Read More
Oct23

SQL SERVER – How to Identify InMemory Objects Can be Identified in SQL Server?

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
In-Memory OLTP
1 Comment
When SQL Server introduced InMemory OLTP functionality, it is a great addition to the database. I have seen people use this capability in limited capacity for specific use case scenarios. As a seasoned developer, it is difficult to know what are the consumers of memory. In a recent conversation, I…
Read More
Previous 1 … 337 338 339 340 341 342 343 … 831 Next

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

SQL SERVER – What is Semantics Search Inside SQL Server?

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

SQL SERVER – Taking Backup Without Consuming Disk Space

Interview Question of the Week #042 – How Does SPACE Function Works in SQL Server?

SQL SERVER – Simple Way to Find Existence of Column in a Table

SQL SERVER – How to Identify InMemory Objects Can be Identified in SQL Server?

Previous 1 … 337 338 339 340 341 342 343 … 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