SQL Tips and Tricks Archives - Page 110 of 536 - SQL Authority with Pinal Dave

SQL SERVER – How to Suppress SQL Server messages in Application Event Log

November 7, 2015

Error messages are a great source of help when it comes to troubleshooting. What can I say, this is maybe be the most repeated phrase from me in this blog about error messages. The messages have grown over ages and got better with the SQL Server dev team putting in…

SQL SERVER – How to Change SQL Server Product Key or License Key?

November 6, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

I try to refrain from talking about licensing related topics because they seem to be complicated and have tons of permutations and combinations. Having said that, in the recent past, I was baffled to see this query land to my Inbox which was interesting and needed some attention from me.…

MySQL – Different Methods to Know MySQL Version

November 5, 2015

Pinal Dave

SQL, SQL Tips and Tricks

MySQL

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 – 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…

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…