There are many blogs covering this particular topic on internet but there are very few blogs available that actually will help when you are stuck with these 2 errors. I recently had a very tough time fixing these errors, hence Continue Reading..
It has been almost 9 years since I chose software development as my bread and butter though my degree says that I am an Electrical Engineer. Today, I spend most of my time in reading the codes than writing but Continue Reading..
What is fill factor? Fill factor is the value that determines the percentage of space on each leaf-level page to be filled with data. In SQL Server, the smallest unit is a page, which is made of Page with size Continue Reading..
Recently in a developer meet, I was asked a question that, “is there a simpler way to have a stored procedure output fill into a table without defining all columns, as simple as like * into #t ?” You must be thinking about OPENQUERY, Continue Reading..
Recently a few of developers started complaining about 100s of database in one instance, making them difficult to navigate in SSMS. This situation is quite generic in all development environment. So here we are going to do a little trick to hide all the databases Continue Reading..
You must have observed that the sample database adventureworks comes only with a mdf file as downloadable. Se let’s see how can we attach a data file without the log file/s? Mostly when you are on the latest version of Continue Reading..
One of the questions that I often receive on my blog and social media, “Is the Big Data going to replace RDBMS in future?” That’s an interesting question. In this article, I am going to give my opinion on this subject. Continue Reading..
Microsoft has recently added two new string functions STRING_AGG and CONCAT_WS to its cloud offering RDBMS solution i.e Azure SQL. These two functions are not new in the market and were already available in other databases like Postgres, Oracle, MySQL Continue Reading..
Microsoft has changed a lot of policies with the release of SQL Server 2016. In this post we will get a comparison between SQL Server express, developer, standard and enterprise editions. By the way if you are not aware, SQL Server developer Continue Reading..
We have been using different methods in SQL to convert row data into columns. Some time it’s just the requirement for data visualisation only. To fulfil this requirement mostly we use PIVOT, which is complex and lengthy. In this blog Continue Reading..