SQL Archives - Page 101 of 519 - SQL Authority with Pinal Dave

Interview Question of the Week #046 – How @@DATEFIRST and SET DATEFIRST Are Related?

November 22, 2015

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

Question: How @@DATEFIRST and SET DATEFIRST are related? Answer: The master database’s syslanguages table has a DateFirst column that defines the first day of the week for a particular language. SQL Server with US English as default language, SQL Server sets DATEFIRST to 7 (Sunday) by default. We can reset any day…

SQL SERVER – Inserting into ColumnSet with SPARSE Columns

November 21, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

ColumnStore Index

There are a number of blogs around using SPARSE columns here. Here are few of them for reference and can be used as a great learning experience. SQL SERVER – 2008 – Introduction to SPARSE Columns SQL SERVER – 2008 – Introduction to SPARSE Columns – Part 2 SQL SERVER…

SQL SERVER – InMemory Table Creation Error Message: Msg 41337

November 20, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

I had recently gone to my hometown to visit my parents as it was holidays for my daughter because of festival. These are relaxing times and hardly try to get in front of my computer during these 2-3 days of family time. But who said that happens always. In this…

SQL SERVER – T-SQL Window Function Framing and Performance – Notes from the Field #103

November 19, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Function

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

SQL SERVER – Puzzle with Miliseconds – Win USD 50 Amazon Gift Card

November 18, 2015

Pinal Dave

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

Embarcadero, SQL DateTime

Last contest, which we had ran was in May and it had received amazing responses. I once again reached out to kind team of Embarcadero and they agreed to support the next contest. The contest has two steps and they are very simple. It took me a while to build…

SQL SERVER – Looking Inside SQL Complete – Advantages of Intellisense Features

November 17, 2015

Pinal Dave

SQL

Devart

Recently SQL Complete add-in was updated, which I use when writing SQL queries in SSMS. In the product history I saw that a several features were added, such as code refactoring or automatic semicolon insertion. However, in this post I do not want to talk about them. I have noticed a new logic for metadata queries, which significantly accelerated my work with database objects. So I decided to look inside SQL Complete… to understand how it works and what changed…. Let us learn about Advantages of Intellisense Features.

MySQL – Get Latest Identity Value by Inserts

November 16, 2015

Pinal Dave

SQL, SQL Tips and Tricks

MySQL

In SQL Server, whenever you add data to a table that has an identity column, you can get the lastly generated identity value using @@identity or scope_identity(). Similarly, in MySQL you can make use of LAST_INSERT_ID () function Let us create the following dataset Create table test(id int AUTO_INCREMENT NOT…