1. X
  2. Pinal Dave
Log inSign up
Pinal Dave
81.4K posts
Image
user avatar
Pinal Dave
@pinaldave
I am SQL Server Performance Tuning Expert at @SQLAuthority
blog.SQLAuthority.com
Joined May 2007
425
Following
26.4K
Followers
RepliesRepliesArticlesArticlesMediaMedia

New to X?

Sign up now to get your own personalized timeline!

Create account

By signing up, you agree to the Terms of Service and Privacy Policy, including Cookie Use.

Terms·Privacy·Cookies·Accessibility·Ads Info·© 2026 X Corp.
Don't miss what's happening
People on X are the first to know.
Log inSign up
  • Pinned
    user avatar
    Pinal Dave
    @pinaldave
    Mar 12
    SQL Server is changing. AI is changing how we work with data. I explore both. Here you will find: 🛢️ SQL Server performance tips ⚡ Query tuning and troubleshooting 🤖 AI ideas for DBAs and data professionals Real examples. Real scripts. No fluff. Follow if you enjoy practical
    6.5K
  • user avatar
    Pinal Dave
    @pinaldave
    Sep 6, 2023
    Which query do you think would perform better and WHY? #SQLServer #SQL
    Image
    492K
  • user avatar
    Pinal Dave
    @pinaldave
    Sep 21, 2023
    The following queries may give different results; do you know why? #SQL #SQLServer Reply with your answer!
    Image
    383K
  • user avatar
    Pinal Dave
    @pinaldave
    Sep 8, 2023
    The following two scripts are different - Any guesses as to why? #SQL #SQLServer
    Image
    359K
  • user avatar
    Pinal Dave
    @pinaldave
    Sep 10, 2023
    Which one of the following will give a better performance? #SQL #SQLServer
    Image
    395K
  • user avatar
    Pinal Dave
    @pinaldave
    Sep 22, 2023
    Are they the same or different? #SQL #SQLServer
    Image
    442K
  • user avatar
    Pinal Dave
    @pinaldave
    Sep 12, 2023
    Which one of the following is faster? #SQL #SQLServer
    Image
    205K
  • user avatar
    Pinal Dave
    @pinaldave
    Sep 12, 2023
    Which option do you prefer? #Join #SQL
    Image
    167K
  • user avatar
    Pinal Dave
    @pinaldave
    Sep 7, 2023
    Which of the following indexes would work best for the query? #SQL #SQLServer Sample script: -- Sample tables CREATE TABLE orders ( order_id INT PRIMARY KEY, customer_id INT, order_date DATE ); CREATE TABLE order_items ( item_id INT PRIMARY KEY, order_id
    Image
    127K
  • user avatar
    Pinal Dave
    @pinaldave
    Sep 22, 2023
    Why do the following queries give different results? Only 1% know the correct answer. #SQL #SQLServer
    Image
    155K
  • user avatar
    Pinal Dave
    @pinaldave
    Oct 5, 2023
    Which one of the following is FASTER? Only 3.3% of people got it right before. #SQLServer
    Image
    160K
  • user avatar
    Pinal Dave
    @pinaldave
    Sep 15, 2023
    What may be output of this query? #SQLServer
    Image
    133K
  • user avatar
    Pinal Dave
    @pinaldave
    Sep 16, 2023
    What can be the output of this query? #SQL #SQLServer
    Image
    92K
  • user avatar
    Pinal Dave
    @pinaldave
    Sep 27, 2023
    Are they the same or different? #SQL #SQLServer
    Image
    83K
Advertisement
Advertisement