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

276 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

5 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

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

179 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

6 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

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,372 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

274 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

5 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

A New Word: on tenderhooks

Ramblings about data communities and your contributions, no excuses

SQL Server Journey till 2025 (brief)

Forums

Ola Hallengren Index Optimize Maintenance can we have data compression = page

how do i map the "current" object entry in for each to one variable

Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)

Question of the Day

String Similarity I