I was curious about how the SQL language stands with the other technologies. Next table shows it. The data is taken from StackOverflow. Charted data looks like in the next figure. Next figure gives the relationships between the technologies, Continue reading SQL and the other technologies
I’ve seen quite a lot of usage of both functions in the T-SQL codes. However, their usage sometimes matters. The expectation from @@IDENTITY can sometimes not be the desired. This post shows why you should use SCOPE_IDENTITY() instead of @@IDENTITY when Continue reading SCOPE_IDENTITY() or @@IDENTITY
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