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

SQL SERVER – Why Should You Not to Use Old Style JOIN?

October 8, 2015

If you want to JOIN two tables you can do it in two ways. One using ANSI compliant INNER JOIN and another with old style join But it is advisable not to use old style join. Here is the reason. Let us create the following data sets CREATE TABLE item_master(item_id…

SQL SERVER – SSMS Query Command(s) completed successfully without ANY Results – Part 2

October 7, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Management Studio

What do you do when you encounter something that you didn’t expect? A lot of times such experiences take you to a state of shock or a state of bafflement. The curiosity sometimes pushes you off the cliff to understand why certain behaviors occur. I am fortunate that I get…

SQL SERVER – Creating a Database Administrator Group Using User-Defined Server Roles

October 5, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Security

When it comes to security related topics, I always read and learn something new from my friend Vinod. He always comes-up with something interesting and when he was at GIDS event, one of the attendees walked and asked a security question. He was interested in knowing how we can have…

Interview Question of the Week #039 – What is Included Column Index in SQL Server 2005 and Onwards?

October 4, 2015

Pinal Dave

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

SQL Index

You may find it interesting that not many people still know what is Included Index in SQL Server. I have seen it personally around me and also have seen at Question: What is Included Column Index? Answer: In SQL Server 2005, the functionality of non-clustered indexes is extended by adding non-key…

SQL SERVER – Linked server creation error: OLE DB provider “SQLNCLI11” for linked server returned message “Invalid authorization specification”

October 3, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Scripts, SQL Server

One of the blog reader sent me the below mail. I always find that using linked server have been of concern and trouble at a number of places. So when the mail landed – well I was not surprised that there was a problem. It is common and hence the…

SQL SERVER – What Does WHERE 1=1 Mean in the Code?

October 1, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

One of the blog followers asked this question “The code written by my colleague has WHERE 1=1. What does it mean?” Well. You have seen people using it when they dynamically construct WHERE condition based on the input values. Let us create this dataset CREATE TABLE #t (emp_name VARCHAR(100), experience…

SQL SERVER – What is Windows Internal Database Edition?

September 30, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

The more you read the more you learn. But some of the best learnings need not come from known sources. These can be accidental too. These learnings in my opinion involves tons of exploration which you would have never done before. This blog post today is something on the similar…