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..
I was working on a data warehouse project where the time data (HH:MM) were coming in decimal format from the source. Some of them were restricted to actual hour and minutes (23.59) and some were coming in real decimal format like (16.80). So I had Continue Reading..
A friend of mine asked me a very interesting question today, she wanted date output like “14th Mar 2016”. Immediately I answered her to use new FORMAT function eg: FORMAT (GETDATE(), ‘dd MMM yyyy’) or CONVERT(VARCHAR(10), GETDATE(), 13) which returns Continue Reading..
Sometimes there is a need to search every field of every table for a particular value in SQL Server database. Recently I had a some requirement to search a value against a Microsoft Dynamics AX ERP database and then replace that value Continue Reading..