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
Oct12

SQL SERVER – Advanced Data Quality Services with Melissa Data – Azure Data Market

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
DQS, SQL Utility
6 Comments
There has been much fanfare over the new SQL Server 2012, and especially around its new companion product Data Quality Services (DQS). Among the many new features is the addition of this integrated knowledge-driven product that enables data stewards everywhere to profile, match, and cleanse data. In addition to the…
Read More
Oct11

SQLAuthority News – Amazon Gift Card Raffle for Beta Tester Feedback for NuoDB

Pinal Dave
SQL Tips and Tricks
NuoDB
2 Comments
As regular readers know I’ve been spending some time working with the NuoDB beta software. They contacted me last week and asked if I would give you a chance to try their new web-based console for their scalable, SQL-compliant database. They have just put out their final beta release, Beta…
Read More
Oct10

SQL SERVER – Find Rows and Index Count – SQL in Sixty Seconds #029 – Video

Pinal Dave
SQL Performance
Clustered Index, Database, SQL in Sixty Seconds, SQL Index, SQL Scripts, SQL Server Management Studio
12 Comments

There are a few questions I often get asked. I wonder how interesting is that in our daily life all of us have to often need the same kind of information at the same time. Here is the example of the similar questions about index count:

Read More
Oct9

SQL SERVER – Identify Numbers of Non Clustered Index on Tables for Entire Database

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Index
8 Comments
Here is the script which will give you numbers of non clustered indexes on any table in entire database. SELECT COUNT(i.TYPE) NoOfIndex, [schema_name] = s.name, table_name = o.name FROM sys.indexes i INNER JOIN sys.objects o ON i.[object_id] = o.[object_id] INNER JOIN sys.schemas s ON o.[schema_id] = s.[schema_id] WHERE o.TYPE IN…
Read More
Oct9

SQLAuthority News – A Conversation with an Old Friend – Sri Sridharan

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Database, DBA, SQL PASS
4 Comments
Sri Sridharan is my old friend and we often talk on GTalk. The subject varies from Life in India/USA, movies, musics, and of course SQL. We have our differences when we talk about food or movie but we always agree when we talk about SQL. Yesterday while chatting with him…
Read More
Oct8

SQL SERVER – Recover the Accidentally Renamed Table

Pinal Dave
SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks
16 Comments
I have no answer to following question. I saw a desperate email marked as urgent delivered in my mailbox. “I accidentally renamed table in my SSMS. I was scrolling very fast and I made mistakes. It was either because I double clicked or clicked on F2 (shortcut key for renaming).…
Read More
Oct7

SQLAuthority News – Download Whitepaper – SQL Server Analysis Services to Hive

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL White Papers
2 Comments
The SQL Server Analysis Service is a very interesting subject and I always have enjoyed learning about it. You can read my earlier article over here. Big Data is my new interest and I have been exploring it recently. During this weekend this blog post caught my attention and I…
Read More
Previous 1 … 501 502 503 504 505 506 507 … 829 Next

    This form uses Akismet to reduce spam. Learn how your data is processed.

    SQL SERVER 2016 – InMemory OLTP support for Foreign Key

    Hyper V: Error and Fix – Fix – Boot failure. Reboot and Select proper Boot device

    SQL SERVER - Why is My Query Switching to Row Processing and Not Doing Batch Processing? stopaterror

    SQL SERVER – FIX: Msg 4335, Level 16, State 1 – The specified STOPAT time is too early

    SQL SERVER – 2016 – Creating Additional Indexes with Clustered ColumnStore Indexes

    SQL SERVER - Why is My Query Switching to Row Processing and Not Doing Batch Processing? wmi-01-800x210

    SQL SERVER – Script: Change Service Account Using WMI / SMO

    Interview Question of the Week #055 – How to Convert ASCII to DECIMAL or DECIMAL to ASCII?

    SQL SERVER - Why is My Query Switching to Row Processing and Not Doing Batch Processing? cloumnstore_abort-row-01-800x558

    SQL SERVER – Why is My Query Switching to Row Processing and Not Doing Batch Processing?

    Previous 1 … 501 502 503 504 505 506 507 … 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 100 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