SQL Server Archives - Page 8 of 393 - SQL Authority with Pinal Dave

SQL SERVER – InMemory Table Creation Error Message: Msg 41337

November 20, 2015

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…

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

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