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

271 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

A New Word: Dolorblindness

Claude Code Helps Analyze Test Data Manager Log Files

PowerPoint to HTML with Claude AI

Forums

Case part is sloooooow

Why the following cmds in sequence do not work

When SQL Server Central Went Down

Question of the Day

The String Distance I