Developer Cookies Blog

Category: SQL Server

SQL Server

Naming conventions for stored procedures

You should always use consistend naming conventions (no sp_ prefix). Beside of the documented recommendation of Microsoft for possible sp_ naming conflicts for future

Non clustered index on NON-SEQUENTIAL unique identifier vs. SEQUENTIAL unique identifier

If you have a non clustered index on unique identifier you might have identified a serious performance problem. The SQL server creates for each non

Developer Cookies Blog

Category: SQL Server

Naming conventions for stored procedures

Non clustered index on NON-SEQUENTIAL unique identifier vs. SEQUENTIAL unique identifier

Categories

Tags