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

SQL SERVER – Interesting Function AGENT_DATETIME

March 13, 2015

One in a while I come across such interesting side of SQL Server that it even surprises me. Just the other day I came across function AGENT_DATETIME. I had never used it before and now I just found usage example of the same. There can be several methods to convert…

SQL SERVER – The Basics of the File System Task, Part 1 – Notes from the Field #071

March 12, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SSIS

[Note from Pinal]: This is a new episode of Notes from the Field series. Every time I give an introductory note, however, this time there is no need of intro note. This note is from Andy and as we all know he is amazing person when we have to understand the fundamentals. He…

SQL SERVER – Error – Msg 6401, Level 16: Cannot roll back Transaction

March 11, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

In a recent Usergroup meet that I attended someone asked me this simple yet interesting question about how transactions work and is there any concept like nested transactions inside SQL Server. Though I have talked about this in the past, thought it would be worth revisiting this concept to drive…

SQL SERVER – FIX – A connection cannot be made to redirector. Ensure that ‘SQL Browser’ service is running. (Microsoft.AnalysisServices.AdomdClient)

March 10, 2015

Pinal Dave

SQL

Computer Network, SQL Error Messages, SQL Server

I opened SQL Server Management Studio and instead of a database engine. Below is the error which I received for SQL Browser:

SQL SERVER – How to Add User Across Databases

March 9, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Security

In this era of standards, many organizations want to be using some of the cutting edge technologies in their organizations. In many of these interactions I was lucky enough to meet few DBA’s who give me interesting challenges to meet within their organizations. I still vividly remember sharing a script…

Interview Question of the Week #010 – What is the Difference Between Primary Key Constraints and Unique Key Constraints?

March 8, 2015

Pinal Dave

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

I often see people getting confused between Primary Key and Unique Key. I see where people get confused about the same. Let us discuss. Question: “What is the Difference Between Primary Key Constraints and Unique Key Constraints?” Answer: “Primary Key (PK) Constraints enforce uniqueness just like Unique Key (UK) Constraints,…

SQL SERVER – Using Buffer Pool Extension with In-Memory OLTP?

March 7, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

In-Memory OLTP

I am always amazed to see the questions asked by my blog reader which lead me to learn more about SQL Server. Here is the question which took me little time to figure out the answer. If you are new to SQL Server 2014 new features which I have in…