Blog Home Page - Page 625 of 831 - SQL Authority with Pinal Dave

Aug25

Today is a quick puzzle time. Let us learn about – Does the order of column used in WHERE clause matter for performance? Let us learn today.

Aug24

SQLAuthority News – Download Microsoft SQL Server Migration Assistant

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL Documentation, SQL Download

SSMA for Oracle v4.2 Microsoft SQL Server Migration Assistant (SSMA) is a toolkit that dramatically cuts the effort, cost, and risk of migrating from Oracle to SQL Server 2005, SQL Server 2008 or SQL Server 2008 R2. SSMA for Access v4.2 Microsoft SQL Server Migration Assistant (SSMA) is a toolkit…

Aug24

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

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

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…

SQL SERVER – Function to Retrieve First Word of Sentence – String Operation orderofcolumn-800x338

SQL SERVER – Does Order of Column in WHERE Clause Matter?

SQLAuthority News – Download Microsoft SQL Server Migration Assistant

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 – Function to Retrieve First Word of Sentence – String Operation viewindex1

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

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 18 SQL Server database books and 117 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.

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.