Apr 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
index used

SQL SERVER – COUNT(*) and Index Used – Part 2

June 18, 2021
Pinal Dave
SQL Tips and Tricks
Clustered Index, Execution Plan, SQL Index, SQL Scripts, SQL Server

Yesterday I wrote a blog post on the topic SQL SERVER – COUNT(*) and Index Used, lots of people asked me to follow up question.

Read More
Count Distinct Values

MS Access – Count Distinct Values

June 17, 2021
Pinal Dave
SQL Tips and Tricks
MS Access, SQL Distinct, SQL Scripts, SQL Server

I love answering random questions and particularly when they are from my paying clients. Let me answer about MS Access and Count Distinct Values.

Read More
Difficult to Remove

SQL SERVER – Identity Column is Difficult to Remove

June 16, 2021
Pinal Dave
SQL Tips and Tricks
SQL Identity, SQL Scripts, SQL Server

I discuss this during  Comprehensive Database Performance Health Check. It is true that the identity Column is Difficult to Remove.

Read More
Changing Password

SQL SERVER – Unlocking User Without Changing Password

June 9, 2021
Pinal Dave
SQL Tips and Tricks
SQL Password, SQL Scripts, SQL Server, SQL Server Security

If know the answer, I like to answer them. Today we are going to discuss Unlocking User Without Changing Password. Let us learn.

Read More
cultures FORMAT

SQL SERVER – Display Dates in Different cultures FORMAT

May 31, 2021
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Scripts, SQL Server

Today we are going to learn a very simple and interesting concept used very little. It is about how to Display Dates in Different cultures FORMAT.

Read More
Slowloris

Slowloris DDoS Attack Mitigation

May 24, 2021
Pinal Dave
SQL Tips and Tricks
Pluralsight, SQL Server Security

Slowloris is one of the very popular tools for DDoS attacks and today we will be talking about Slowloris DDoS Attack Mitigation at Pluralsight.

Read More
SQL Server on Linux

SQL SERVER on Linux – Commands

May 11, 2021
Pinal Dave
SQL Tips and Tricks
Linux, SQL Server, SQL Server Installation, Starting SQL

Let us learn how to install SQL Server on Linux in this quick blog post. I have recently worked with a client wanting multiple installations of SQL Server.

Read More
Previous 1 … 19 20 21 22 23 24 25 … 536 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version