[Note from Pinal]: This is a 100th episode of Notes from the Field series.
SQL SERVER – Looking Forward to Meeting you at SQLPASS 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…
Read MoreSQL SERVER – Strange SQL Transaction called UpdateLoginStats
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…
Read More
SQL SERVER – To Find Events Mapped to Channels in Extended Events
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.
SQL SERVER – Error Fix: Msg 300, VIEW SERVER STATE
I travel quite a bit and the month of October and November seem to be filled with half my life is going to be spent hopping from one airport to another. Not to mention the amount of screening that go through every single time in every flight. However strange as it might sound, in one of such airport transits I was waiting for my bag to be screened through the machine and I was watching the screen on the other side where the security officer sits. It was interesting because it was a very skillful task as he was finding a needle in a haystack (in the literal sense). He was able to figure out what items, sharp items and toys which are restricted were getting passed through. I was amused and was transported into a world of wonderland because it was quite a challenging task. With these memories not subsiding, I landed to my desired destination and started checking my mails. There was one mail that caught my attention because suddenly it was a junior DBA who was trying to give some permissions and was getting an error. I was quick to get interested because it was a topic around security and I wanted to crack it. The message stated like: Error Fix: Msg 300, VIEW SERVER STATE
Interview Question of the Week #040 – Difference Between Unique Index vs Unique Constraint
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…
Read More
SQL SERVER – Trick – Running SSMS With Different Windows Account
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…
Read MoreSQL SERVER – Database Testing and Waitfor Delay – Notes from the Field #099
[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…
Read MoreSQL SERVER – Why Should You Not to Use Old Style JOIN?
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…
Read MoreSQL SERVER – SSMS Query Command(s) completed successfully without ANY Results – Part 2
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…
Read More