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

281 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

9 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

7 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

182 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

8 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

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

276 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

13 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

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

Take Time to Gain Perspective

The Fringe Festival

Demo for Parameter Sniffing and Memory Grant Feedback

Forums

Alamat Kantor BCA KCU BOGOR Tlp:08217555651

Alamat Kantor BCA KCU Sukabumi Tlp:08217555651

Alamat Kantor BCA KCU Karawang Tlp:08217555651

Question of the Day

The SQL Server MCP Server