Category Archives: SQL Tricks and Tips

SQL Tricks and Tips

Why parallelism is not desired in OLTP database enviornment.

 a) Many time out of date statistics or missing indexes can lead to parallelism in OLTP environment. Contrarily to OALP in most OLTP environment a transaction touches few numbers of rows so large table sca n is not desired which … Continue reading

Posted in SQL Tricks and Tips | Leave a comment

How to upgrade from evaluation or trial edition to full or retail edition of SQL Server

When the evaluation period for your SQL Server 2008 Evaluation edition expires, you will notice the following symptoms: SQL Server service fails to start. The following message is logged in the Windows Application log: SQL Server evaluation period has expired … Continue reading

Posted in SQL Tricks and Tips | Leave a comment