Apple iPad 2 vs iPad: What different?

The iPad 2 is finally here in its full glory! But is it nearly as good as it looks like? We quickly summed up the main novelties that the new iPad offers and compared them to the main features of the original one. It all starts from the design – Apple outshines itself with an even thinner tablet. Actually, the new iPad is even thinner than the iPhone 4 and while you might not want to cut cake with it, you certainly could. One of the few rumors that Cupertino didn't fulfil was the higher resolution expected by some. But in all honesty, we're pretty happy with the tablet's current pixel density.

Use NOLOCK and READPAST table hints in SQL Server for speed up query

When data in a database is read or modified, the database engine uses special types of controls, called locks, to maintain integrity in the database. Locks basically work by making sure database records involved in a transaction cannot be modified by other transactions until the first transaction has committed, ensuring database consistency.

When designing database applications, you should keep in mind the different types of locks that will be issued, and the different levels of isolation your transactions will occur. Typically, the SQL Server defaults work fine for what you are trying to accomplish. However, there will be times when it is advantageous to manually make hints to how locks are issued on your tables in your SQL statements.

Tips to Speed up SQL Server database queries

by Tim Chapman, TechRepublic

Close

Please login or sign up to clip this article.
E-mail
Password

Remember me

Log in | Sign up | Why join Builder AU's community? See the benefits.

Please login or sign up to clip this article.
E-mail
Password

Remember me

If you've worked with SQL Server databases for any amount of time, it's practically a given that you've run into slow running queries. Sometimes the reason for the slow response time is due to the load on the system, and other times it is because the query is not written to perform as efficiently as possible (I find this reason much more common). Learn how you may be able to improve performance by knowing what to look for in your query designs.