There is no way to avoid index fragmentation in any SQL Server environment.
It does not depend on your SQL Server version or I/O subsystem you have, or
your hardware. In this article, we will drill down into SQL Server index
fragmentation issue. We will figure out why index fragmentation is a problem
and how it affect on overall performance, discuss how to detect and avoid it.
Fragmentation is a common term that describes numerous effects that can occur
because of data modifications. Chances are, you already know that SQL Server
stores data on 8KB data pages. Eight contiguous pages form extent. A data
page both in clustered or non-clustered indexes contains pointers to the next
and previous pages. The following picture demonstrates that there are no
Let's insert a new row into the index and see what happens. SQL Server
inserts a n... (more)
Over the last few years, more and more businesses have been embracing the
cloud-based technologies for their CRMs, customer service, project
development and management, accounting, etc. The reasons of the trend are
pretty obvious - all you need to access cloud services are web browser and
Internet connection, what allows cloud-based companies to minimize
maintenance costs and to boost productivity.
Nevertheless, there is still a large segment of business that looks at the
cloud rather suspicious, mostly questioning its ability to provide data
security and integrity. In this arti... (more)
Many of us are using JIRA during development and sometimes it is necessary
to record our working time spent on resolving a bug or completing a task in
JIRA. There are a lot of various time trackers but I want to show you a free
and easy solution that will help you to track your working time in JIRA.
TMetric is a time tracking software which helps individuals and
organizations to be more productive. This time management software provides
time tracking, work session monitoring, reporting tools, integrations and
Why is TMetric now called Jira Time Tracker?
Using its rich ... (more)
In this article, I'd like to elaborate on the subject of boosting
productivity while working with database tables. Chances are you already know
this from multiple resources on database development process.
However, the topic seems to become a front-burner issue when there are
continuous data growths - tables become too large that leads to the
It happens due to an ill-designed database schema that was not originally
designed for handling large volumes of data.
To avoid the performance loss in the context of continuous data growth, you
should stick to certain rul... (more)
The use of Instant File Initialization is a terrific way to reduce downtime
during failure recovery. It won't take you much time to initialize files for
filling them with zeros before the recovery. So keep in mind that there is
such useful thing as Instant File Initialization.
When SQL Server reserves new space on a disk, it initializes the space
with zeros. This behavior can be switched off thereby reducing the execution
time of some operations and the load on the disk subsystem.
Disk space reservation without initialization is called Instant File
Initialization. This feature is... (more)