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

Aug24

I recently got opportunity to speak at Virtual Tech Days on August 18, 2010 on the subject Spatial Database. The event was heavily attended by enthusiasts world wide. I delivered session the on the subject of Spatial Database and it was great fun to deliver the session. I have delivered…

Aug23

SQL SERVER – ORDER BY Does Not Work – Limitation of the Views Part 1

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL View

Update: Please read the summary post of all the 11 Limitations of the view SQL SERVER – The Limitations of the Views – Eleven and more… Recently, I was about the limitations of views. I started to make a list and realized that there are many limitations of the views. Let…

Aug22

SQL SERVER – Computed Columns – Index and Performance

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Index, SQL Scripts

This is the last article in the series of the computed columns I have been writing. Here are previous articles. SQL SERVER – Computed Column – PERSISTED and Storage This article talks about how computed columns are created and why they take more storage space than before. SQL SERVER –…

Aug21

SQL SERVER – Computed Column – PERSISTED and Storage – Part 2

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Data Storage, SQL Scripts

I am really enjoying writing about computed column and its effect in terms of storage. Before I go on with this topic, I suggest you read the earlier articles about computed column to get the complete context. This is the list of the all the articles in the series of…

Aug20

SQL SERVER – Function to Retrieve First Word of Sentence – String Operation

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts, SQL String

I have sent of function library where I store all the UDF I have ever written. Recently I received email from my friend requesting if I have UDF which manipulate string and returns only very first word of the statement. Well, I realize that I do not have such a…

Aug19

SQL SERVER – Negative Identity Seed Value and Negative Increment Interval

Pinal Dave

SQL Tips and Tricks

SQL Function, SQL Identity, SQL Scripts, SQL Server

Let us learn today about Negative Identity Seed Value and Negative Increment Interval. I have also included a video in this blog post.

Aug18

SQL SERVER – Download SQL Server 2008 Interview Questions and Answers Complete List

Pinal Dave

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

I was getting many request to update SQL Server Interview Questions and Answers I had written couple of years ago. I have modified the original document a bit and corrected few of the typos and errors. I have really enjoyed going over all the Interview Questions and Answers. It has…

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

SQLAuthority News – Feedback Received for Virtual Tech Days Sessions on Spatial Database

SQL SERVER – ORDER BY Does Not Work – Limitation of the Views Part 1

SQL SERVER – Computed Columns – Index and Performance

SQL SERVER – Computed Column – PERSISTED and Storage – Part 2

SQL SERVER – Function to Retrieve First Word of Sentence – String Operation

SQL SERVER – Negative Identity Seed Value and Negative Increment Interval

SQL SERVER – Download SQL Server 2008 Interview Questions and Answers Complete List

SQL SERVER – FIX – Error 1402 – Could not Open Key: UNKNOWN\Components – System Error 5 (Another Solution)

How to Force a Parallel Execution Plan for a Query? – Interview Question of the Week #170

SQL SERVER – SharePoint not Working After Failover to Another Node

SQL SERVER – Script – Transaction Log Backups Based on Growth / Size

PowerShell – How to Install dbatools?

PowerShell – Get Maximum Memory of Server with dbatools

SQL Server Performance Tuning – Upcoming Public Training