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

SQL SERVER – InMemory Tables on SQL Azure DB

December 9, 2015

There have been tons of enhancements in the InMemory space with SQL Server 2016. I am due to write about them in this blog. Having said that, one of my DBA friend asked me based on the Pluralsight course on SQL Server 2014 Administration – Does SQL Azure support InMemory…

Interview Question of the Week #048 – How to Move TempDB to Another Drive?

December 6, 2015

Pinal Dave

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

SQL Scripts, SQL TempDB

In a recent interview when the interviewer asked interview that TempDB can be moved to a different drive, the candidate was extremely surprised. For the benefits of the interviewee who did not know the answer, I have written this blog post. Question: How to move TempDB to another drive? Answer:…

SQL SERVER – Resource Governor and Database Mapping

December 5, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Resource Governor

Recently in my trip to US for SQLPass, I had a unique opportunity to meet a number of attendees for my session. The session was well received and I got some great feedbacks. I loved the recent trip and it was a great experience for me to learn and prepare…

SQL SERVER – 2016 – Opening JSON with OPENJSON()

December 4, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

JSON

The first blog I wrote about JSON with SQL Server 2016 was to get a valid JSON output from relational tables. You can read that again from: SQL SERVER – Getting started and creating JSON using SQL Server 2016. In this blog, we will try to get to the next…

SQL SERVER – XEvents to Find Cardinality Estimation Issues

December 2, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Extended Events

Ever since SQL Server 2014 brought the new Cardinality estimates, there have been a number of blogs to talk about them. Even here, I wrote a quite a few blogs about this very subject. SQL SERVER – How to Force New Cardinality Estimation or Old Cardinality Estimation SQL SERVER –…

SQL Server – T-SQL Enhancement “Drop if Exists” clause

December 1, 2015

Pinal Dave

SQL Tips and Tricks

SQL Scripts, SQL Server, SQL Server 2016

I was reading through some of the enhancements introduced with SQL Server 2016 and I stumbled upon an interesting addition. The T-SQL construct introduced has been something very common and on the pending request for years I suppose.

Interview Question of the Week #047 – Logic To Find Weekdays Between Two Dates

November 29, 2015

Pinal Dave

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

I often enjoy seeing interview questions where the contestant has to write SQL Scripts. Here is another such example. Question: How to find weekdays between two dates? Answer: Here is a function which can be used to find weekdays between two dates. CREATE FUNCTION dbo.getDayCount(@startdate date, @enddate date) RETURNS INT…