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..
Actually SQL Server by default does not support content search from PDF files. DMV sys.fulltext_document_types tells us the file types that are supported in your SQL Server instance. To read/index PDF files in SQL Server, we need to load a plugin/class 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..