Web technologies are moving at a pace that we can hardly keep up in pace. More and more of investments are going on in the space of web that even database developers like me find it interesting. In the same context, recently I was exploring on Skyvia (SQL SERVER – Integrate Your Data with Skyvia – Cloud ETL Solution) from ETL to how one might query and was surprised to see how some of these can be made useful.
SQL SERVER – Adding Reference Data to Master Data Services – Notes from the Field #081
[Note from Pinal]: This is a 81th episode of Notes from the Field series. Master Data Services is one of the most important, but a very little explored feature of SQL Server. If you have been reading this blog, when it is about BI, I always take help from LinchPin People who are BI experts. I requested Reeves from LinchiPin people to help me answer this unique question. Let us learn in this blog post how to add reference data to Master Data Services (MDS).
Interview Question of the Week #020 – What is the Difference Between DISTINCT and GROUP BY?
Question: What is the Difference Between DISTINCT and GROUP BY? Answer: A DISTINCT and GROUP BY usually generate the same query plan, so performance should be the same across both query constructs. GROUP BY should be used to apply aggregate operators to each group. If all you need is to remove duplicates,…
Read MoreInterview Question of the Week #019 – How to Reset Identity of Table
Here is the question which I received in email: Question: I have a table which has an identity column. I have recently deleted old and archive it to another place. Now I want to reset the identity of the table to original value of 1. How should I do that? Answer:…
Read More
SQL SERVER – Generating Row Number Without Ordering Any Columns
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.
Interview 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 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