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 I was answering to a question on a SQL Server public forum, that how to grant only execute permission on a database for some users? Yes, It’s very easy to grant execute permission to a user but somehow I feel Continue Reading..
It is very important to set the Max Server memory setting for SQL Server instance. Default setting allows SQL Server to use as much as memory available on the server. In a busier system, SQL Server might consume all the Continue Reading..
Unlike other RDBMS platform SQL Server does not have an easy way to take a table level backup, often people use BCP or generate script method to take one or more table backup. In my previous blog posts, I have Continue Reading..
All most all DBA can answer, how to move tempdb to another drive in SQL Server? This is one of the best practices for tempdb performance point of view. Tempdb is not like other databases and cannot be backed up and restored 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..
There are occasional times when we need to test connectivity from a machine back to SQL Server without installing SSMS or any tool. There are many ways to do it but the question is how easily can this be done? Continue Reading..
When you ask a DBA or developer that, what features they would most like to see added to the future versions of SQL Server, they will undoubtedly say, “The ability to backup of a single table to physical file system Continue Reading..
Full-text queries perform linguistic searches against text data in full-text indexes by operating on words and phrases based on rules of a particular language such as English or Hindi or Gujarati etc. Full-text queries can include simple words and phrases Continue Reading..