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

SQL SERVER – Strange SQL Transaction called UpdateLoginStats

October 14, 2015

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…

SQL SERVER – To Find Events Mapped to Channels in Extended Events

October 13, 2015

Pinal Dave

SQL Tips and Tricks

SQL Extended Events, SQL Scripts, SQL Server

I have outlined a number of blogs here that point to the basics of working with Extended Events. Some of them also detail you some specific scenarios that you can use inside your environments.

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…