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 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..
Last week a good friend of mine (Parth Shah) asked me a very interesting question that he wants to capture TRUNCATE and DELETE statements being fired on a database with very minimal overhead on the system. When performance is the 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..
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..
Microsoft Excel is a very powerful tool, using excel we can connect to all most all known data sources available and create a report easily. In this post, we will learn how to connect to a SQL Server database from 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..