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
11tips

11 Essential Tips for Avoiding Common SQL Server Performance Tuning Mistakes

February 1, 2023
Pinal Dave
SQL Performance
Data Type, Normalization, Software Development, SQL Backup, SQL Cursor, SQL Data Storage, SQL Index, SQL Server, SQL Server Security, SQL Statistics, Temp Table

This blog post will cover 11 tips for avoiding common SQL server mistakes. From indexing to security, these tips will help you optimize your database’s performance.

Read More

Compressed Backup and Performance – SQL in Sixty Seconds #196

April 12, 2022
Pinal Dave
SQL Video
SQL Backup, SQL in Sixty Seconds, SQL Restore, SQL Server

I was recently asked if I have a handy script that can help us take compressed backup and uncompressed backup. Backup and Performance

Read More

SQL SERVER – Sample Script for Compressed and Uncompressed Backup

March 21, 2022
Pinal Dave
SQL Tips and Tricks
SQL Backup, SQL Scripts, SQL Server

I was recently asked if I have a handy script that can help us take compressed backup and uncompressed backup. Well, of course.

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
Restore Date

SQL SERVER – Get Last Restore Date

September 10, 2021
Pinal Dave
SQL Tips and Tricks
SQL Backup, SQL Restore, SQL Scripts, SQL Server

Let us learn how to get the last restore date for the backup in SQL Server. Here is a very simple script for the same. Let me know your feedback.

Read More
copy database

Copy Database – SQL in Sixty Seconds #169

May 27, 2021
Pinal Dave
SQL Video
SQL Backup, SQL in Sixty Seconds, SQL Restore

At that time I use this technique of copy database while keeping the database online. This method is very simple and efficient.

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
1 2 3 4 … 18 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version