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..
Merry Christmas to all of you!! May Santa bring you all you’ve asked for and more.. This is my Christmas tree decorations. *Important: Press Ctrl + T and then execute the query. –*Important: Execute this query in Result to Text mode. Continue Reading..
Checking a column existence in a table is very simple in SQL Server, but you should be careful while doing it on Azure environment. We simply ignore the performance consideration while writing SELECTs against systems tables/views/dmvs etc. Recently a stored proc started Continue Reading..