window.dataLayer = window.dataLayer || []; function gtag(){dataLayer.push(arguments)}; gtag('js', new Date()); gtag('config', 'UA-12254750-2');

How to speed up computer (8 Ways to boost windows performance with absolutely no money)

2019-07-27T01:26:56+02:00Tuesday, 25 February, 2014|Categories: Featured, Operational|Tags: , , , , , , |

Have you ever found yourself frustrated waiting for your PC to turn on or the internet browser to finally open the webpage? If you are like me and every other human being using a computer, you have probably dealt with such situation. Are you interested on how to speed up your computer? One of the [...]

SQL Indexing and SQL Performance Part 1: SQL Storage and Indexing

2016-10-19T13:11:24+02:00Monday, 29 November, 2010|Categories: Featured, Technical|Tags: , , , , , , , |

Before we begin our journey in SQL Indexing it is important to understand how a SQL Server stores its data. Database FileGroups and Files A MS SQL database uses a .mdf file as the primary data file, a number of .ldf files as transaction logs, and optionally a number of .ndf files as secondary data files. These [...]