Blog Home Page - Page 369 of 829 - SQL Authority with Pinal Dave

Apr1

Playing around with date and time datatypes can be loads of fun. I hope you got the pun intended when I say it is fun. Most of the developers working with date and time datatypes feel it is a pain. I understand their sentiments, but would like to let you…

Mar31

SQL SERVER – Script to find SQL Startup Account using WMIC

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

No Comments

Friends are your lifeline that keep your life interesting. I have various friends’ circles that range from family, acquaintances, work and the most exciting circle is the technical circles. Most of the times the tech circles is what fuels most of the post that lands up here. I was talking…

Mar30

SQL SERVER – Using MaxTransferSize parameter with SQL Server Backups

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Scripts, SQL Server

Off late I have been writing a lot around SQL Server backups and administration topics. I have seen a lot of my readers have been enjoying some of the deep conversations I have with people in the industry. As I always say, most of the blog posts are inspired by someone asking me a question, me doing the research and then reaching out to them to give a solution. This blog post is no different in that aspect.

Mar29

Interview Question of the Week #013 – Stored Procedure and Its Advantages – How to Create Stored Procedure

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

SQL Stored Procedure

No Comments

There are some questions which are so old that they should not be asked in the interview and gets old. Here is one of the questions I have spotted so many times in the interview that if co-interviewer asks to the candidate, I often feel bored (well, I was caught…

Mar28

SQL SERVER – System procedures to know SQL Server Version

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Extended Events, SQL Stored Procedure

There are several ways to know the version of SQL Server. But did you know that there are two system procedures through which you can know the version? They are SP_SERVER_INFO and EXEC XP_MSVER EXEC sp_SERVER_INFO If you execute the above, you get a result set with informations about the…

Mar27

SQL SERVER – Find the Growth Size for All files in All Databases

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

I am a big time advocate of some common best practices that I see in the industry. These have been ingrained into every session that I do be it SQL Server, MySQL or any other databases. Though I work extensively on SQL Server and from time-to-time on other databases, the…

Mar26

SQL SERVER – Mistake to Avoid: Duplicate and Overlapping Indexes – Notes from the Field #073

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Index

[Note from Pinal]: In this episode of the Notes from the Field series database expert Kathi Kellenberger explains about indexes and its impact. We often believe that indexes will improve the performance of the query, but it is not true always. There are cases when indexes can reduce the performance as well. Read…

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.

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.

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.

Feb 2026 Discount: Comprehensive Database Performance Health Check | Testimonials

SQL SERVER – Quiz on knowing DATEPART and DATENAME Behaviors

SQL SERVER – Script to find SQL Startup Account using WMIC

SQL SERVER – Using MaxTransferSize parameter with SQL Server Backups

Interview Question of the Week #013 – Stored Procedure and Its Advantages – How to Create Stored Procedure

SQL SERVER – System procedures to know SQL Server Version

SQL SERVER – Find the Growth Size for All files in All Databases

SQL SERVER – Mistake to Avoid: Duplicate and Overlapping Indexes – Notes from the Field #073

SQL – Download NuoDB and Qualify for FREE Amazon Gift Cards

SQL SERVER – How to Compare the Schema of Two Databases with Schema Compare

SQL – Crossword Puzzle Based on Course Building Successful High Traffic Profitable Blog

SQL SERVER – Disk Space Monitoring – Detecting Low Disk Space on Server

SQL SERVER – Weekly Series – Memory Lane – #040

SQL SERVER – Understanding Restrict Access to Restricted_User Database Property

SQLAuthority News – Releasing Author’s 10th Book – SQL Basics Joes 2 Pros: A Getting Started Guide to Administering and Developing SQL Server Databases for Beginners