Ray Of Light

gr

2010-04-26T21:19:00.000+02:00

gr
never make somebody your every Thing because !!when they are gone you have got NOTHING !!!

Cakephp cache query

2010-03-16T12:15:00.002+02:00

check this article in my new blog

Cakephp cache query

SQL SERVER - SQL Commandments - Suggestions, Tips, Tricks

2008-08-19T17:50:00.002+02:00

1. Know your data and business application well.Familiarize yourself with these sources; you must be aware of the data volume and distribution in your database.

2. Test your queries with realistic data.A SQL statement tested with unrealistic data may behave differently when used in production. To ensure rigorous testing, the data distribution in the test environment must also closely resemble that in the production environment.

3. Write identical SQL statements in your applications.Take full advantage of stored procedures, and functions wherever possible. The benefits are performance gain as they are precompiled.

4. Use indexes on the tables carefully.Be sure to create all the necessary indexes on the tables. However, too many of them can degrade performance.

5. Make an indexed path available.To take advantage of indexes, write your SQL in such a manner that an indexed path is available to it. Using SQL hints is one of the ways to ensure the index is used.

6. Understand the Optimizer.Understand the optimizer how it uses indexes, where clause, order by clause, having clause, etc.

7. Think globally when acting locally.Any changes you make in the database to tune one SQL statement may affect the performance of other statements used by applications and users.

8. The WHERE clause is crucial.The following WHERE clauses would not use the index access path even if an index is available.e.g. Table1Col1 (Comparision Operator like >, <, >=, <=,) Table1Col2, Table1Col1 IS (NOT) NULL, Table1Col1 NOT IN (value1, value2), Table1Col1 != expression, Table1Col1 LIKE ‘%pattern%’, NOT Exists sub query.

9. Use WHERE instead of HAVING for record filtering.Avoid using the HAVING clause along with GROUP BY on an indexed column.

10. Specify the leading index columns in WHERE clauses.For a composite index, the query would use the index as long as the leading column of the index is specified in the WHERE clause.

11. Evaluate index scan vs. full table scan. (Index Only Searches Vs Large Table Scan, Minimize Table Passes)If selecting more than 15 percent of the rows from a table, full table scan is usually faster than an index access path. An index is also not used if SQL Server has to perform implicit data conversion. When the percentage of table rows accessed is 15 percent or less, an index scan will work better because it results in multiple logical reads per row accessed, whereas a full table scan can read all the rows in a block in one logical read.

12. Use ORDER BY for index scan.SQL Server optimizer will use an index scan if the ORDER BY clause is on an indexed column. The following query illustrates this point.

13. Minimize table passes.Usually, reducing the number of table passes in a SQL query results in better performance. Queries with fewer table passes mean faster queries.

14. Join tables in the proper order.Always perform the most restrictive search first to filter out the maximum number of rows in the early phases of a multiple table join. This way, the optimizer will have to work with fewer rows in the subsequent phases of join, improving performance.

15. Redundancy is good in where condition.Provide as much information as possible in the WHERE clause. It will help optimizer to clearly infer conditions.

16. Keep it simple, stupid.Very complex SQL statements can overwhelm the optimizer; sometimes writing multiple, simpler SQL will yield better performance than a single complex SQL statement.

17. You can reach the same destination in different ways.Each SQL may use a different access path and may perform differently.

18. Reduce network traffic and increase throughput.Using T-SQL blocks over Multiple SQL statements can achieve better performance as well as reduce network traffic. Stored Procedures are better over T-SQL blocks as they are stored in SQL Server and they are pre-compiled.

19. Better Hardware.Better hard ware always helps performance. SCACI drives, Raid 10 Array, Multi processors CPU, 64-bit operating system improves the performance by great amount.

20. Avoid Cursors.Using SQL Server cursors can result in some performance degradation in comparison with select statements. Try to use correlated sub query or derived tables if you need to perform row-by-row operations

Found On sqlauthority

We Are The Champion - (Ghana 2008)

2008-02-11T17:53:00.000+02:00

Egyptian people after Wining the African Cup go to streets to express its happiness about the result of match between the Pharoahs and Cameroon National team.

Egypt deserved their win in Accra, after A bog effort from Mohamed Zidan with the Ball and fininshed by Abotrika but Cameroon who had held out well for the most part eventually only fell victim to a simply suicidal goal.

Good job Ya Regalah

تعاطغا مع غزة

2008-02-03T13:31:00.000+02:00

لقد بلغت الإنسانية دركاً متدنياً لم يسبق له مثيل في الانحطاط من قبل، فلا الدين ولا العقل ولا القانون ولا شرعة حقوق الإنسان تقبل بالجريمة الأشنع ضد الإنسانية التي اقترفها الكيان الصهيوني بحق أهلنا الأبرياء في غزة.
ندعو الله سبحانه وتعالى بفك الحصار عن اخواننا الفلسطينين

"لفته جميله من الفنان ابو تريكا في مباراة السودان لمؤازرة اهل غزةلقد استطاع فعل ما عجز عنه السياسيون "

Adding ASP.NET AJAX to an Existing ASP.NET Application

2007-12-27T16:12:00.000+02:00

ASP. NET AJAX makes it easily to take advantage of AJAX techniques and enables you to create ASP.NET pages, and enables you to take full advantage of the capabilities of the browser to deliver richer Web experiences that work on any modern browser.

how to upgrade an existing asp.net 2.0 web app?

You add ASP.NET AJAX functionality to the application by adding a reference to the ASP.NET AJAX assembly,

I explain how to use ajax using XMLHttpRequest object in details in an article in codeproject.
Ttake your time reading the article and waiting for your comments, questions and queries .

See how to add ASP.NET AJAX to an existing ASP.NET 2.0 application article i hope you enjoy the article

Marie Digby

2007-12-03T18:09:00.000+02:00

We don't have to see TV shows to find talented people like Star Maker,Super Star, or any other TV shows .
All we need is just the internet ,You can find many talented people in the internet wating for thier chance . Marie Digby is one from those who used the internet to broadcast her songs, people know her throw the internet in http://www.youtube.com/
over than 6 milion watch her clips till now .i hope producer check the internet and find more and more talnted people Check this song Umberlla :D

Ajax Using XMLHttpRequest object

2007-11-11T16:42:00.000+02:00

Introduction
In all web application when you submit a button or sending a data to server the server each time deliver to you a new webpage.
What if I want just only a part of the webpage to be process and in this part get back another webpage content without reloading the whole page? How I can display data from another webpage in a DIV HTML element in the current page without loading the entire page.
Note: To read this article you must understand:
· HTML / XHTML
· JavaScript

What is Ajax?

Ajax is not an invention or a new programming language, it’s a web development technique witch build based on old ones (JavaScript, XML, HTML, CSS). Ajax is stand for (asynchronous java script and XML), and this technique make your web site more flexible faster friendly and more interactive, Ajax became popular in 2005 when Google use this new technology.

What Ajax Can Do?

What if I want just only a part of the webpage to be process and in this part get back only what the client needs without reloading the hole page ?!! This is what Ajax can do, with Ajax java script can communicate with server using XMLHttpRequest Object, and can exchange data with server. when you want to get or send data from server using JavaScript we make a form and post this data but unfortunately its reload anew web page with http request now we can get data from server behind the seen without reload the webpage, he will stay in the current page and will not notice any thing happened behind the seen.

I explain how to use ajax using XMLHttpRequest object in details in an article in codeproject.

Ttake your time reading the article and waiting for your comments, questions and queries .

XML

2007-04-01T04:16:00.000+02:00

XML Extensible Markup Langauge :

Defien Structure Data in plain text.
Markup langauge based in Tags.
Subset of SGML.
Edite and crated by text editor.
Unlike HTML dosn't have fixed sets of tags.
Fouccs in data and its structure but HTML focus in presentaion.
Not only used for web pages.
Unlike HTML ,XML isa case sensetive.
Universal Data Exchange Format HOW?

Separation of Content and Presentation
With HTML, the actual data and its presentation logic are interleaved. HTML tags do not add any semantic meaning to the data content, but just describe the presentation details. This approach makes it hard to manipulate just the data or just the way it is presented. The Cascading Style Sheets (CSS), initiative made an effort to separate data from the presentation.

As XML makes no assumption about how tags might be rendered on the display device browser,
wireless cell phone, PDA, or whatever, but simply provides a means to structure data with tags we define. it is quite natural to use the same XML data document and present it differently on
different devices. This separation of data from presentation also facilitates easy access to the data.

Example Of XML File:

XML-based Languages
Already, many new markup languages based on XML syntax have been created to meet the needs of specific application domains ,some of them:

SOAP
SMIL
SVG
XForms

never make somebody your every Thing because !!when they are gone you have got NOTHING !!!

Swallowed in the sea

2007-03-15T04:03:00.000+02:00

Swallowed in the sea Lyrics for my favourite band COld PlAy..........

You cut me down a tree
And brought it back to me
And that's what made me see
Where I was going wrong

You put me on a shelf
And kept me for yourselfI
can only blame myself
You can only blame me

And I could write a song
A hundred miles long
Well that's where I belong
And you belong with me

And I could write it down
And spread it all around
Get lost and then get found
or swallowed in the sea

You cut me down to size
And opened up my eyes
Made me realize
What I could not see

Web 2.0

2007-03-13T00:40:00.000+02:00

Web 2.0 is linking people..
"We Are The Web"

see this vedio

Starz in their Eyez

2007-03-04T03:27:00.001+02:00

What a beautiful thing that to love and to be loved, I mean these people who love you for reason u don’t know, maybe some for your kind or maybe only coz you draw a smile to their facie and maybe for nothing.

You don’t valuate this love until you hurt someone or when you came to the end of the road and may not u see them again.

I see them now in the skys, and the starz in their eyes I will do my best to catch theses starz or to fly high and stay with people whom i love.

First Blog

2007-02-24T00:25:00.000+02:00

24 february ,2007
12:26

"Hope Best Things Be Around Me"

Regards,

Islam K. Saber