SQL Tips and Tricks Archives - Page 108 of 535 - SQL Authority with Pinal Dave

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

November 19, 2015

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

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…

Interview Question of the Week #045 – How to Do Case Sensitive Search?

November 15, 2015

Pinal Dave

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

One of my popular questions which helps me to understand lots of understanding of SQL by SQL developer. Question: How doing a case sensitive search in SQL Server? Answer: If Column1 of Table1 has following values ‘CaseSearch, casesearch, CASESEARCH, CaSeSeArCh’, following statement will return you all the four records. SELECT…

SQL SERVER – Backup to Azure Blob error – The remote server returned an error: (409) Conflict

November 13, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

Cloud is inevitable. With various innovations happenings in this area, SQL Server is not left behind. It is becoming a first class citizen when it comes to moving to cloud. In the past couple of releases, we have been seeing the enhancements of integrating with Azure getting stronger. Last year…

SQL SERVER – What is T-SQL Window Function Framing? – Notes from the Field #102

November 12, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Function

SQL SERVER – What is SQL Server Operating System?

November 11, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Sometimes the strangest of questions come from unusual places. This blogging journey is all about revisiting the basics. I have always felt getting some of these basic questions can make us learn even more and look into the internals of how products work. In my recent visit to SQLPass and…