Browse by Tags

• execution plan
• GUID
• optimization
• Performance
• PK
• Primary Key
• sql optimization
• sql stored procedure optimization
• Stored Procedure
• Stored Procedure execution
• uniqueidentifier

How to select the primary key data type?
04 July 07 11:00 PM | idragoev | 0 Comments   

When a new database is about to be designed, have to think about what data type to use for the primary keys. There are several things that should be taken into consideration: the average database size expected, the possibility of growing in the future, Read More...

Filed under: PK, database design, Primary Key, uniqueidentifier, GUID

Increase Stored Procedure execution performance dramatically
18 June 07 05:52 AM | idragoev | 0 Comments   

Last month we spent a lot of time in data loading optimization due to performance problems. I started with optimization of the heaviest views and put them in parameterized stored procedures . I also used a simple method to check the performance by measuring Read More...

Filed under: execution plan, optimization, Stored Procedure, Performance, Stored Procedure execution, sql optimization, sql stored procedure optimization, database design