Igor Micev

Integration specialist, Developer & Programmer, Database administrator, and Architect with 15+ years of
expertise. Experienced in software development, database analysis & design, performance tuning, upgrades &
migrations, high availability solutions implementation, and design, backup and recovery strategies, and system
capacity planning.

All authors

SCOPE_IDENTITY() or @@IDENTITY

by Igor Micev

Si vis pacem, para sql

I’ve seen quite a lot of usage of both functions in the T-SQL codes. However, their usage sometimes matters. The expectation...

2017-01-27

275 reads

SCOPE_IDENTITY() or @@IDENTITY

by Igor Micev

Si vis pacem, para sql

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...

2017-01-27

4 reads

SCOPE_IDENTITY() or @@IDENTITY

by Igor Micev

Si vis pacem, para sql

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...

2017-01-27

3 reads

My first Microsoft MVP Award!

by Igor Micev

Si vis pacem, para sql

Exactly 10 years ago I started my career as a Software developer in a Bank, which for me meant directing...

2017-01-10

178 reads

My first Microsoft MVP Award!

by Igor Micev

Si vis pacem, para sql

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...

2017-01-10

5 reads

My first Microsoft MVP Award!

by Igor Micev

Si vis pacem, para sql

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...

2017-01-10

4 reads

Indexes optimize for the system databases

by Igor Micev

Si vis pacem, para sql

Maintenance of the system databases in SQL Server regarding the indexes is important too. The system tables also have indexes...

2016-12-23

1,371 reads

Indexes optimize for the system databases

by Igor Micev

Si vis pacem, para sql

Maintenance of the system databases in SQL Server regarding the indexes is important. The system tables also have indexes and...

2016-12-23

273 reads

Indexes optimize for the system databases

by Igor Micev

Si vis pacem, para sql

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....

2016-12-23

4 reads

Indexes optimize for the system databases

by Igor Micev

Si vis pacem, para sql

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....

2016-12-23

3 reads

All authors

Igor Micev

SCOPE_IDENTITY() or @@IDENTITY

SCOPE_IDENTITY() or @@IDENTITY

SCOPE_IDENTITY() or @@IDENTITY

My first Microsoft MVP Award!

My first Microsoft MVP Award!

My first Microsoft MVP Award!

Indexes optimize for the system databases

Indexes optimize for the system databases

Indexes optimize for the system databases

Indexes optimize for the system databases

Blogs

Git forked

Setting FK Constraints in Data Modeler

Webinar: Navigating the Database Landscape in 2026

Forums

SSMS 22 Latest Update Crashing

Transactional Replication setup issue

The Power of Data and Privacy

Question of the Day

What's the Date?