All Articles - SQL Authority with Pinal Dave

Interview Question of the Week #034 – What is the Difference Between Distinct and Group By

August 30, 2015

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

Question: What is the difference between DISTINCT and GROUP BY? Answer: A DISTINCT and GROUP BY usually generate the same query plan, so performance should be the same across both query constructs. GROUP BY should be used to apply aggregate operators to each group. If all you need is to remove…

SQL SERVER – Remove All Characters From a String Using T-SQL

August 29, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

In this post, How to Remove All Characters From a String Using T-SQL? we have seen How to Remove All Characters From a String Using T-SQL. But it only removes characters from the string. What if the string has some other special characters? Here is the method that handles this SET NOCOUNT ON…

SQL SERVER – Different Methods to Extract Scale Part From Decimal Number

August 28, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function

One of my blog readers asked me “Is there a way to extract only the number after the decimal point?”. For example, in decimal number 45.90, 45 is the precision and 90 is the scale value. There are several methods to get this done Let us create this dataset CREATE…

SQL SERVER – Are Power Options Slowing You Down? – Notes from the Field #095

August 27, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Backup and Restore

[Note from Pinal]: This is a 95th episode of Notes from the Fields series. When it is about tuning SQL Server, we always look at the configuration of the SQL Server. However, there are few settings of the operating system can also impact the performance of the SQL Server. I recently…

SQL SERVER – Script: Finding queries without JOIN Predicates

August 26, 2015

Pinal Dave

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

SQL Scripts

I have been in developer’s shoes for close to 5+ years before reinventing myself to do things that made me even better in coding. It is a tough challenge these days being a developer. The life around you and the technology is changing so rapidly that we seldom get time…

SQL SERVER – Database Mirroring login attempt failed – Connection handshake failed

August 25, 2015

Pinal Dave

SQL

SQL Error Messages, SQL Mirroring, SQL Scripts, SQL Server

The best way I have learnt about building SQL Server AlwaysOn Availability Group is by contacting my close friends who have written the only book on this topic. It is not common that I ping them for such technical queries, but that is what friendship is made off. Recently, while preparing a demo for the AlwaysOn Availability Group, I ran into interesting issue and was able to fix it as well. Let us learn about the Database Mirroring login error.

SQL SERVER – Fix @@ServerName Property Value When Incorrect

August 24, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Function

Our software systems are funny and sometimes give us strange values. I don’t quite venture out trying to fiddle around with system level properties on my servers, but having said that, this query had come from one of my colleagues who was working on his SQL Server instance and he…

Interview Question of the Week #033 – How to Invalidate Procedure Cache of SQL Server?

August 23, 2015

Pinal Dave

SQL Interview Questions and Answers

SQL Server, SQL Server DBCC, SQL Stored Procedure

Question: How to Invalidate Procedure Cache in SQL Server?

SQL Authority News – 100 Million Views and Onwards

August 22, 2015

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

SQL Milestone

I will always remember August 20, 2015 as a landmark milestone for SQLAuthority.com. On August 20th, this blog crossed 100 Million Views. When I started this journey on November 1, 2006, I had no idea that there will be over 100 Million Views on this blog. I am indeed very proud…

SQL SERVER – DBCC CHECKDB errors – Msg 2520 during executions

August 21, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

Some of the simplest recommendations can lead you to some bizarre output that we never anticipated. I always recommend running DBCC CHECKDB on mission critical databases because we need to be 200% sure that the database disk system is healthy from time to time. During one of my sessions, I…