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

T-SQL for UDFs

by Igor Micev

Si vis pacem, para sql

SQL Server has plenty of built-in functions, but sometimes we just have to combine some of them to create functions for...

2016-01-15

114 reads

T-SQL for UDFs

by Igor Micev

Si vis pacem, para sql

SQL Server has plenty of built-in functions, but sometimes we just have to combine some of them to create functions for our purposes. Such one, for example, is the function...

2016-01-15

7 reads

T-SQL for UDFs

by Igor Micev

Si vis pacem, para sql

SQL Server has plenty of built-in functions, but sometimes we just have to combine some of them to create functions for our purposes. Such one, for example, is the function...

2016-01-15

15 reads

Bad queries!!!

by Igor Micev

Si vis pacem, para sql

Once it happend quite a black Friday for my environment after a deployment. The application got sucked so that becoming worst and...

2015-12-25

132 reads

How a Bad query can rise up your CPU to ceiling

by Igor Micev

Si vis pacem, para sql

Once it happened quite a black Friday for my environment after a deployment. The application got sucked so that becoming worst and...

2015-12-25

104 reads

How a Bad query can rise up your CPU to ceiling

by Igor Micev

Si vis pacem, para sql

Once it happened quite a black Friday for my environment after a deployment. The application got sucked so that becoming worst and worst. The average CPU raised over 80% (Figure 1)....

2015-12-25

9 reads

How a Bad query can rise up your CPU to ceiling

by Igor Micev

Si vis pacem, para sql

Once it happened quite a black Friday for my environment after a deployment. The application got sucked so that becoming worst and worst. The average CPU raised over 80% (Figure 1)....

2015-12-25

5 reads

Sql Hints #1 - Don’t update Primary Key values

by Igor Micev

Si vis pacem, para sql

Recently I had the chance to take a look at a problematic query in an application. I caught the query...

2015-11-11

110 reads

Why you should not update Primary Key values

by Igor Micev

Si vis pacem, para sql

Recently I had the chance to take a look at a problematic query in an application. I caught the query...

2015-11-11

3,387 reads

Why you should not update Primary Key values

by Igor Micev

Si vis pacem, para sql

Recently I had the chance to take a look at a problematic query in an application. I caught the query in profiler and it’s the following: [crayon-5e81b52edda2c602772598/] The query...

2015-11-11

9 reads

All authors

Igor Micev

T-SQL for UDFs

T-SQL for UDFs

T-SQL for UDFs

Bad queries!!!

How a Bad query can rise up your CPU to ceiling

How a Bad query can rise up your CPU to ceiling

How a Bad query can rise up your CPU to ceiling

Sql Hints #1 - Don’t update Primary Key values

Why you should not update Primary Key values

Why you should not update Primary Key values

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