All Articles - SQL Authority with Pinal Dave

MySQL – Different Methods to Know MySQL Version

November 5, 2015

In SQL Server, to know the current version of the server, you can use system variable @@VERSION How many of you know that the same can be used in mysql to know the version? Also there are many ways to know the version of MySQL Method 1: Select @@version as…

SQL SERVER – What is the OVER Clause? – Notes from the Field #101

November 4, 2015

Pinal Dave

SQL

Notes from the Field, SQL Function, SQL Scripts, SQL Server

[Note from Pinal]: In this episode of the Notes from the Field series database expert Kathi Kellenberger explains about T-SQL Over clause. Kathi is an amazing instructor, she was the SQL author I have read in my early career. The reason, I love SQL Server because her writing has instigated love for this technology in me. Today she brings a relatively interesting topic for database experts. Read the experience of Kathi in her own words.

SQL SERVER – How to take InMemory – OLTP FileGroup Offline?

November 3, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

In-Memory OLTP, SQL Error Messages

InMemory topics are always interesting and a great learning experience. When I wrote the other post, it was more about how InMemory tables are loaded into memory even if they are not queried. The basics, here is to bring the data for In Memory Tables ahead to memory irrespective of…

SQL SERVER – Basics ColumnStore FAQ – Part II

November 2, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

ColumnStore Index, SQL Index

I wrote the first part of FAQ in here. This is not a typical blog post but more of a process oriented topic when working with ColumnStore Indexes. With the advancements done in SQL Server 2016, I know that this is going to be even more critical to understand some…

SQLAuthority News – 9th Year Blog Anniversary

November 1, 2015

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

SQL Milestone

Today is an amazing day! 9 years ago on this day, I started to write this blog. Since then I am producing one blog post a day everyday! During this year there are so many changes have happened in the blog and my professional career as well as on my…

Interview Question of the Week #043 – What is the Difference Between EXCEPT operator vs. NOT IN

October 31, 2015

Pinal Dave

SQL Interview Questions and Answers

SQL Joins, SQL Scripts, SQL Server

Question: What is the Difference Between EXCEPT operator vs. NOT IN. Let us learn the answer to this question in this blog post.

SQL SERVER – Adding Datetime and Time Values Using Variables

October 30, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime

Datetime datatype stores date and time part. If you have only date value, You can add time part to a datetime variable using direct literal value and + operator. It is shown below DECLARE @date DATETIME SET @date='2010-10-01' SET @date=@date+'15:00:00' SELECT @date AS DATETIME The result is 2010-10-01 15:00:00.000 But…

SQL SERVER – Who is consuming CPU on my SQL Server?

October 29, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL CPU

The topics around performance tuning is always interesting and I get quizzed by a number of you during conferences on these topic areas post my presentation. A relatively simple yet a powerful question was asked by one of the attendee in my session at MODS (Mobile Developer Conference) this year.…

SQL SERVER – What is Semantics Search Inside SQL Server?

October 28, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Every now and then I bump into stuffs that I didn’t even hear about when it comes to working with SQL Server. This time I heard the word Semantics Search and was wondering where and when did it come. In this blog, I will put the foundation for this and…

SQL SERVER – Script level upgrade for database ‘master’ failed – CREATE SCHEMA failed due to previous errors

October 27, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

SQL Server troubleshooting topics seem to be the most searched for in this blog. In continuation to this, blog for today is also inspired with one such error message. Some time back I have written below blog which talks about upgrade script mode of SQL Server: SQL SERVER – Login…