-
1). Understanding Sql Web Hosting By : Paolo Basauri
What is SQL Web Hosting
Before understanding the concept of SQL web hosting, it’s necessary to have a basic grasp on what SQL is, and also how web hosting works.
* SQL is the acronym for Structured Query Language, which is a computer language that is used to manipulate data in a database. SQL works with many different database systems, such as Access, Oracle and MS SQL.
Article Related to: sql server, hosting
|
-
2). Eliminating cursor in SQL Server By : Marin Kostadinovic
We all know how cursors are slow and how badly they tend to issue a lock on part of the table, or on the whole table, during its execution. To explain exactly what is going on, and what we can do to optimize the performance, here is an example:
Table t_Customers has 3000 records.
Table t_Orders has 1 to 100 records for each record in t_Customers table, making it a table with 65000 records.
Article Related to: sql server, eliminating cursor, table type, table variable
|
-
3). Optimizing Your Asp.Net Pages for Faster Loading and Better Performance. By : John Belthoff
Copyright 2006 John Belthoff
If you read the internet and all of the websites dedicated to Asp.Net you will inevitably read about the wonders of the DataGrid, DataList, and Repeater controls. While each of these has its place, if you are only displaying data there is a much faster and more efficient means to do so.
Let's say you have a page that displays articles based on a query string.
Article Related to: asp.net, web custom control, performance, caching, cache, asp.net controls, sqldatareader, sql server, classes, arraylist
|
