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

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

November 3, 2015

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…

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…