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..
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..
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..
Few times I have observed that developers directly consider the dynamic SQL option as a solution, when there is need to sort the result set on basis of user input variables/parameters. Let’s see how can we do the sorting using case when. Continue Reading..
Personally I am very strict to the datatypes, whether it’s for a column or parameter or just a variable. I don’t like if somebody choose them carelessly. Always the datatypes needs to used precisely. Make it as a coding standard or your Continue Reading..
I have seen many times that a few developers like to write SELECT * instead of column names. It’s definitely a bad habit and not the coding standard of-course. Few times I was reverted back saying that the table/view have very few Continue Reading..
SQLIO is not a part of SQL Server package despite its name, it is a tool provided by Microsoft which can be used to determine the I/O capacity or benchmark a given disk subsystem. Benefit of SQLIO is that, it Continue Reading..
As a DBA, we spend a lot of time investigating and maintaining the database performance parameters like new index creation, index rebuild on basis of fragmentation level, statistics update etc. but what about a HEAP table, how will we handle the fragmentation Continue Reading..
So far there is no inbuilt split function available in SQL Server to split a delimited string into an array or table format. In my last article I talked about, splitting a delimited string into columns and rows. In this blog post I Continue Reading..
OPTIMIZE FOR is a query hint introduced in SQL Server 2005 version and supported in all editions of SQL Server. This query hint can be applied to all DML operations like SELECT, INSERT, UPDATE, DELETE AND MERGE. The OPTIMIZE FOR Continue Reading..