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

SQL SERVER – Looking Forward to Meeting you at SQLPASS 2015

October 15, 2015

If you are going to at SQLPASS 2015, Seattle, I am looking forward to meet you. I will be there and presenting two technology sessions. Here are the details of my sessions. I will be very happy if you are at SQLPASS and attend my session. If you see me…

SQL SERVER – Strange SQL Transaction called UpdateLoginStats

October 14, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

I was preparing a demo for my upcoming presentation which is about couple of weeks ahead. While doing a stress test, I was looking at profiler and found that for every login there is an additional SQL transaction which is having ObjectName as UpdateLoginStats appearing even before Audit Login. Initially…

Interview Question of the Week #040 – Difference Between Unique Index vs Unique Constraint

October 11, 2015

Pinal Dave

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

SQL Index

Question: What is the difference between unique index and unique constraint? Answer: Add Unique Constraint ALTER TABLE dbo.<tablename> ADD CONSTRAINT <namingconventionconstraint> UNIQUE NONCLUSTERED ( <columnname> ) ON [PRIMARY] Add Unique Index CREATE UNIQUE NONCLUSTERED INDEX <namingconventionconstraint> ON dbo.<tablename> ( <columnname> ) ON [PRIMARY] There is no difference between Unique Index…

SQL SERVER – Trick – Running SSMS With Different Windows Account

October 10, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

MySQL, SQL Server Management Studio

Recently in one of my interaction with a DBA inside a big financial organization, I was surprised to see that the administrator was logging into a desktop / server using a different credential. What baffled me was the fact that he was logging off. I immediately asked, why are you…

SQL SERVER – Database Testing and Waitfor Delay – Notes from the Field #099

October 9, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Function

[Note from Pinal]: This is a 99th episode of Notes from the Field series. In this episode we are going to learn something very simple but effective about database testing. Database testing is one of the most critical elements for any developer or DBA. If you do not test your code, there are…

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

October 8, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Joins

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…