A columnstore index is a type of data structure that’s used to store, manage and retrieve data that is stored in a columnar-style database. Columnstore indexes work well with read-only queries and large-scale analysis. One of their primary uses is queries Continue Reading..
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..
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..
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..