March 2023 Discount: Comprehensive Database Performance Health Check | Testimonials

  • 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
  • Training
linenumber

SQL Server: How to Display Row Numbers in Query Editor for Efficient Query Editing

February 2, 2023
Pinal Dave
SQL Tips and Tricks
SQL Server, SQL Server Management Studio, SSMS

Let us learn how to Display Row Numbers in Query Editor for Efficient Query Editing. Comprehensive Database Performance Health Check

Read More
Restoring State

SQL SERVER – Source Database in Restoring State

October 19, 2021
Pinal Dave
SQL Tips and Tricks
SQL Backup, SQL Restore, SQL Scripts, SQL Server, SQL Server Management Studio, SSMS

A client whom I often help with Health Check recently reached out to me with an interesting problem about Source Database in Restoring State.

Read More
procedure definitions

SQL SERVER – Easiest Way to Copy All Stored Procedure Definitions

September 8, 2021
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Management Studio, SQL Stored Procedure, SSMS

What is the easiest way to copy all stored procedure definitions for your database? Well, let us quickly learn that today.

Read More

SQL Server – Single Scan for 3 Operations – COUNT(*) COUNT(1) SUM(1)

June 30, 2021
Pinal Dave
SQL Performance
Execution Plan, SQL Function, SQL Index, SQL Scripts, SQL Server, SQL Server Management Studio, SSMS

Today we will take the same conversation to the next level by discussing Single Scan for 3 Operations – COUNT(*) COUNT(1) SUM(1).

Read More
Join Type

SQL SERVER – Change Join Type for Query

April 22, 2021
Pinal Dave
SQL Tips and Tricks
Execution Plan, SQL Joins, SQL Operator, SQL Scripts, SQL Server, SQL Server Management Studio, SSMS

“Can I Change Join Type for Query?” I was recently asked this during  Comprehensive Database Performance Health Check. Of course Yes!

Read More
backup files

Multiple Backup Copies Stripped – SQL in Sixty Seconds #156

February 19, 2021
Pinal Dave
SQL Tips and Tricks
SQL Backup, SQL in Sixty Seconds, SQL Restore, SQL Server, SQL Server Management Studio, SSMS

Yesterday I blogged about SQL SERVER – Creating Multiple Backup Copies. I got an amazing response to the blog post. Let us learn it today.

Read More
backup files

SQL SERVER – Creating Multiple Backup Files – Stripped

February 18, 2021
Pinal Dave
SQL Tips and Tricks
SQL Backup, SQL Restore, SQL Server, SQL Server Management Studio, SSMS

One of my long-term clients (Comprehensive Database Performance Health Check) recently asked me question if I know a way of creating multiple backup files.

Read More
1 2 3 4 … 48 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version