Exactly 10 years ago I started my career as a Software developer in a Bank, which for me meant directing my career in the fields of data analysis, processing and data architecture. Fortunately all my next jobs were/are strongly related Continue reading My first Microsoft MVP Award!
Maintenance of the system databases in SQL Server regarding the indexes is important. The system tables also have indexes and their maintenance is of asset on the busy environments. It’s also important to know that the indexes in msdb and Continue reading Indexes optimize for the system databases
This post is about the CPU utilisation in the Standard, Web and Express editions of SQL Server because there is limitation for them. Licensing is given at the end of this post. Physical environments According to the official msdn references (, Continue reading SQL Server and Hyper-threading
In this article I’ll show you how to eliminate periodic spikes in the CPU that are caused by the jobs that execute periodically. Figure 1 shows such a situation. You can see the spikes occurring every minute. Figure 1. CPU Continue reading CPU Spikes Caused by Periodic Scheduled Jobs
This post is about the importance of a right index to a query. The following simple query was considered.
[GroupBy1].[A1] AS [C1]
FROM ( SELECT
MAX([Extent1].[CreatedDate]) AS [A1]
FROM [dbo].[GeoIP2Location] AS [Extent1] WITH (NOLOCK)
) AS [GroupBy1]
Even simple, this query was causing troubles on our production systems. The query is generated from .NET Entity Framework. A simple Continue reading What does an Index mean to a Query
In this article I’ll show you how to connect to SQL Azure database instance and create a simple database. First you have to own an Azure account. In the account you have to have a resource (your database server). Some of the Continue reading Connect to SQL Azure database from SSMS
This post is about how to rename a stand-alone SQL server instance. There could be some reasons to do that: You simply forgot to change the name of your Sysprep server or You want to change from the default instance Continue reading Changing SQL Server name
Below are the topics every Administrator has to keep up with. Backup / Restore: Understand the backup / restore options SQL Server provides for you. Implement those on your databases to meet your users’ needs. Test those backups regularly to Continue reading Be a good administrator
Introduction The process that writes the dirty pages from the system memory (RAM) to the disk is called the checkpoint process. Dirty pages consist of the data and log pages as well as the information for the transaction log. Detailed Continue reading Target Recovery Interval and Indirect Checkpoint
The CHECK constraints enforce integrity by limiting the values that are accepted by one or more columns. You can create a CHECK constraint with any logical expression that returns TRUE or FALSE based on the logical operators. CHECK constraints are Continue reading The CHECK constraints unlike behaviours