Dinesh's Blog :::: Being Compiled ::::

Few days back, I wrote an article on SQL Server default behavior when it expands files with AutoGrowth enabled. Where there are multiple f...

We add multiple data files to file groups to get data distributed (it is always better to get them distributed among multiple physical vol...

Indexes get fragmented based on the operation we perform against records and modification we do against index keys. We use one of the Dyna...

Sometime, for some administration works, we need to know which file has been used for holding our records and the related page numbers. Ho...

I would say, this is the most confusing property in the Microsoft SQL Server. Most misunderstand it and most do not know how it works. Alt...

Licensing is always complex and sometime we cannot figure out the number of licenses we have to buy for the production. It is always bette...

There are set of server level configurations related to optimizing SQL Server but not all guarantee that the result will be as expected an...

I have written two posts on SQL Server Error Log;  How to delete current SQL Server error log? My current log is in GBs and  Reading SQL ...

Although SQL Trace and SQL Server Profiler have been marked as deprecated and Microsoft recommends to use Extended Events  instead, many o...

When I was discussing about getting Stored Procedures automatically executed at service start, a question raised; How can we find Stored P...

We use sp_readerrorlog  for reading the content of the error log of SQL Server and it actually uses xp_readerrorlog extended stored proced...

While I was writing a code on backing up operation for SQL Server 2016, I noticed that there is an issue with partial backup. As per docum...

I have written a post tilted  When was my SQL Server Database last accessed? that talks about how to find the last accessed date and time ...

SQL Server Agent Jobs are commonly used for automating administrative tasks and other routine tasks. For creating a job as you need, you n...

Administrators always try to automate routine tasks, making sure that all required operations are done on time without failures. The main ...

In a continuous running SQL Server environment, it is not uncommon to see a large error log related to SQL Server that is continuously gro...

Let's talk about accounts that can be assigned to the services related to SQL Server and how they can be assigned or changed later. Si...

The most friendly database tool, Management Studio was released with SQL Server 2005 and it has become the right-hand for both database ad...

There are many ways of collecting statistics of SQL Server such as CPU usage, IO made, reads and writes. One facility given by SQL Server ...

Have you ever read the Severity Level  indicated with an error occurred? Or just tried to find out the problematic code exist in your code ...