Si vis pacem, para sql

SQL and the other technologies

• by Igor Micev

• Si vis pacem, para sql

Next table shows how SQL stands with the other technologies. The data is taken from StackOverflow.Data charted looks like in the...

2017-01-28

435 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

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

207 reads

SCOPE_IDENTITY() or @@IDENTITY

• by Igor Micev

• Si vis pacem, para sql

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

2017-02-01 (first published: 2017-01-27)

3,103 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

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

173 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

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

233 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

925 reads

SQL Server and Hyper-threading

• by Igor Micev

• Si vis pacem, para sql

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

2016-12-20