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

Geometry Datatype – Line String Behavior Enhancements

December 28, 2015

When I did the session at SQLPass about the 42 tips, I had included an interesting behavior I got when working with Geometry data types. When I was doing a session at a large SI location, one of the application developers walked up to me to say they were getting…

SQL SERVER – Getting to understand SQL Server Activity Monitor in SSMS

December 25, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Management Studio

This site is flooded with blog posts around SQL Server Management Studio’s Activity Monitor capability. In fact, we have written few special case scenarios on how to use the same. In this blog post, I might not want to rehash the same, but take a stance on how I explained…

SQL SERVER – Error and Fix for Msg 1907 Cannot recreate index The new index definition does not match the constraint being enforced by the existing index

December 22, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

ColumnStore Index, SQL Error Messages

This particular blog post is around usage of Clustered ColumnStore Indexes and how one of my customer in a recent conversation brought this up to my notice. They were on SQL Server 2012 and were upgrading to SQL Server 2014 and were very much interested in the usage of Clustered…

Interview Question of the Week #050 – Query to Retrieve Second Highest Salary of Employee

December 20, 2015

Pinal Dave

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

There are some questions which never gets old and I keep on seeing them again and again every time I participate in the interview to help hire qualified Developers and DBA. Here is another popular question which I often see. Question: Write a query to retrieve Second (or Nth) highest…

SQL SERVER – Recompiling InMemory OLTP with SQL Server 2016

December 18, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

In-Memory OLTP

I wrote an intetresting trivia about InMemory OLTP code previously, SQL SERVER – How to take InMemory – OLTP FileGroup Offline?. Post this one of the reader was curious enough to ask me a counter question. He wrote back stating the recovery of the same is easy but he wanted…

SQL SERVER – Server Side and Client Side Trace

December 15, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

I don’t know where to start, I get to learn things from the most unusual of places. Most of the learnings is based on challenging the statuesque of our understanding. During my interactions with various DBAs one of the common misunderstanding is about server side and client side trace. One…

Interview Question of the Week #049 – Taking Database Offline

December 13, 2015

Pinal Dave

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

SQL Scripts

Here is the conversation which I observed the other day. Question: How do we take database off-line? Answer: Well, we can run following script to take the database offline. ALTER DATABASE [mydb] SET OFFLINE WITH ROLLBACK IMMEDIATE Question: Let us assume that your boss suggest that you should wait 30…