Jun 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
  • Hire Me
  • Health Check
Jun1

SQL SERVER – Creating All New Database with Full Recovery Model

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
8 Comments
Sometimes, complex problems have very simple solutions. Let us see the following email which I received recently. “Hi Pinal, In our system when we create new database, by default, they are all created with the Simple Recovery Model. We have to manually change the recovery model after we create the…
Read More
May31

SQLAuthority News – Best SQLAuthority Posts of May

Pinal Dave
Personal, SQL, SQL Server, SQL Tips and Tricks
1 Comment
Month of May is always interesting and full of enthusiasm. Lots of good articles shared and lots of enthusiast communication on technology. This month we had 140 Character Cartoon Challenge Winner. We also had interesting conversation on what kind of lock WITH NOLOCK takes on objects as well. A quick…
Read More
May30

SQL SERVER – Puzzle – SELECT * vs SELECT COUNT(*)

Pinal Dave
SQL Puzzle
SQL Scripts, SQL Server
76 Comments

Earlier this weekend I have presented at Bangalore User Group on the subject of SQL Server Tips and Tricks. During the presentation I have asked a question to attendees. It was very interesting to see that I have received various different answer to my question. Here is the same puzzle for you and I would like to see what your answer to this question.

Read More
May29

SQL Azure – SQL Azure Throttling and Decoding Reason Codes

Pinal Dave
SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks
SQL Azure
4 Comments
I was recently reading on the subject SQL Azure Throttling and Decoding Reason Codes and end up reading the article over here. What I really liked is the explanation of the subject with Graphic. I have never seen any better explanation of this subject. I really liked this diagram. However,…
Read More
May28

SQL SERVER – A Quick Notes on SQL Azure

Pinal Dave
SQL Tips and Tricks
SQL Azure, SQL Server
5 Comments

I was recently attending a small meeting where I was asked if I can share few things to be considered when designing SQL Azure database. Today I am sharing the same notes over here.

Read More
May27

SQL SERVER – Copy Database from Instance to Another Instance – Copy Paste in SQL Server

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Azure, SQL Backup and Restore, SQL Server
59 Comments

SQL Server has a feature which copy database from one database to another database and it can be automated as well using SSIS.

Read More
May26

SQL SERVER – Getting Columns Headers without Result Data – SET FMTONLY ON

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
19 Comments
I was recently watching a videos online of TechEd 2011 USA (link) and I learned that SET FMTONLY ON is going to be replaced with enhanced DMVs in future versions of SQL Server. I really liked the new direction of the product. However, SET FMTONLY ON is really have done…
Read More
Previous 1 … 580 581 582 583 584 585 586 … 831 Next

SQL SERVER – Creating All New Database with Full Recovery Model

SQLAuthority News – Best SQLAuthority Posts of May

SQL SERVER - Getting Columns Headers without Result Data - SET FMTONLY ON selectstar-1

SQL SERVER – Puzzle – SELECT * vs SELECT COUNT(*)

SQL Azure – SQL Azure Throttling and Decoding Reason Codes

SQL SERVER - Getting Columns Headers without Result Data - SET FMTONLY ON azure-icon-250x250

SQL SERVER – A Quick Notes on SQL Azure

SQL SERVER - Getting Columns Headers without Result Data - SET FMTONLY ON copywizard1

SQL SERVER – Copy Database from Instance to Another Instance – Copy Paste in SQL Server

SQL SERVER – Getting Columns Headers without Result Data – SET FMTONLY ON

Previous 1 … 580 581 582 583 584 585 586 … 831 Next

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 24 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 109 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.


Shaivi Pinalkumar Dave is a book author and a women’s artistic gymnast.

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