Currently browsing tag

not

Index of Materialized View Not Working

Index of Materialized View Not Working Introduction I got a mail from one of my closed friends related to “Materialized view Index not working”. I am little bit confused after getting this mail. When I am getting closer look at the problem that I understand what he mean by “Materialized …

Things you should not do in PHP

Here is a list of things you should not do in PHP. Most of the stuff is pretty obvious, but over the years I’ve seen a lot of them. In most cases, these problems remain hidden until data grows above 10000 entries. So on a development system, things are always …

Android Why Google map is not displayed in my application

Android – Why Google map is not displayed in my application?? There are some reasons due to which a Google map is not displayed in Android Application instead a grey portion with squares is displayed. Some possible reasons are as follows. Do not using API key : In order a …

NOT IN clause is a Performance Killer

NOT IN clause is a Performance Killer   Performance is a very important factor in terms of web based applications. Sometimes I find that the developer use the NOT IN clause in SQL statement which decrease the performance of entire SQL statements. Developers told that we don’t have any options …

Physical defragmentation NOT Needed After SQL Server defragmentation

Physical defragmentation NOT Needed After SQL Server defragmentation   May of us doing physical defragmentation to get the performance of SQL server and think that physical defragmentation after SQL server defragmentation. This is a absolutely wrong concept and to illustrate my points I have collected some facts.     Physical …