Row_number function is used to generate a serial number for a given record set. But you need to always use ORDER BY clause so that the numbers are assigned to the specific order.
SQL SERVER – Who ALTER’ed My Database? Catch Them Via DDL Trigger
Here is an interesting comment from one of my previous blogs on how to change the compatibility level of SQL server post posted earlier. Some of these comments are interesting and can provide some interesting extension to blog ideas like this. So the comment was: Under what circumstances would SQL…
Read MoreInterview Question of the Week #018 – Script to Remove Special Characters – Script to Parse Alpha Numerics
If you ask me – there are certain questions not appropriate for an interview as they are often very subjective. There are some questions, which really do not help to identify if the candidate has the necessary skills or not. Here is one such question, if you ask me in the…
Read MoreSQLAuthority News – Presented 3 Technical Session at Great Indian Developer Summit 2015
Great Indian Developer Summit is my favorite technology event and I have been extremely happy to present technology sessions here for over 5 years. Just like every year, this year, I presented three technology session on SQL Server 2014. This time the event was at two locations. First one is Bangalore and the…
Read MoreSQL AZURE – How to Disable and Enable All Constraint for Table and Database
Recently I wrote blog to enable and disable all constraints in the database SQL SERVER – How to Disable and Enable All Constraint for Table and Database. One of my reader told me that this trick of sp_msforeachtable doesn’t work in Azure SQL Database (WASD). It is interesting that a lot…
Read More
SQL SERVER – Recovering from Snapshots – Notes from the Field #078
[Note from Pinal]: This is a 78th episode of Notes from the Fields series. What do you do when data is deleted accidentally or you are facing disaster? Well, there are plenty of the things, you can do, but when in panic quite often people make mistakes which just intensify the disaster. Database snapshot…
Read More
SQL SERVER – Script: Knowing Data and Log Files Are On the Same Drive
Last week it was wonderful to spend time at the GIDS conference to meet all the enthusiastic developers. Had fun preparing for the session and the number of people who walked to me and say they read this blog makes me really humble and motivated to write more. I love attending and presenting at these conferences because I get an opportunity to meet people and at many times able to answer real world problems. Let’s learn Script: Knowing Data and Log Files Are On the Same Drive.