Articles - Database (SQL Server)

0

Like

The code provided here provides an optimized paging solution using ASP.NET Repeater, SQL Server 2005 / 2008 (not 2000). The implementation does not use temp tables, ROW_COUNT or similar. It only returns the specified amount of rows and not the full dataset to the client for performance reasons. The code is meant to be very simple for easy maintenance.

Background

Paging is used many places, but it is hard to find an optimized solution that is fast, efficient and light-weight to implement. With this article I have tried to implement some of the techniques I think are efficient. All comment ...Read more
Posted by: Teena
On 26 Dec 2011 | Views: 804 | Categories: Database (SQL Server)
0

Like

Stored procedures provide improved performance and scalability to your ystems. When you develop stored procedures, keep the following recommendations in mind:
·Use Set NOCOUNT ON in stored procedures.
·Do not use the sp_ prefix for custom stored procedures. ...Read more
Posted by: Ram
On 05 Dec 2011 | Views: 910 | Categories: Database (SQL Server)
1

Like

We can increase the performance of application in which using EF by following the instruction of articles ...Read more
Posted by: Ram
On 09 Nov 2011 | Views: 1120 | Categories: Live Framework, Database (SQL Server), ASP.NET
0

Like

There are lots of ways to select a random record or row from a database table. Here are some example SQL statements that don't require additional application logic, but each database server requires different SQL syntax.

Select a random row with MySQL:

SELECT column FROM table
ORDER BY RAND()
LIMIT 1 ...Read more
Posted by: Teena
On 11 Oct 2011 | Views: 816 | Categories: Database (SQL Server)
0

Like

What is an Indexed View?
For many years, Microsoft® SQL Serverâ„¢ has supported the ability to create virtual tables known as views. Historically, these views served these main purposes:

To provide a security mechanism that restricts users to a certain subset of data in one or more base tables.

To provide a mechanism that allows developers to customize how users can logically view the data stored in base tables.

With SQL Server 2000, the functionality of SQL Server views was expanded to provide system performance benefits. It is possible to create a unique clustered index on a vie ...Read more
Posted by: Teena
On 11 Oct 2011 | Views: 762 | Categories: Database (SQL Server)
0

Like

When you try to connect to an instance of Microsoft SQL Server 2005 from a remote computer, you may receive an error message. This problem may occur when you use any program to connect to SQL Server. For example, you receive the following error message when you use the SQLCMD utility to connect to SQL Server:

Sqlcmd: Error: Microsoft SQL Native Client: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

This problem may ...Read more
Posted by: Teena
On 11 Oct 2011 | Views: 749 | Categories: Database (SQL Server)
0

Like

Firewall systems help prevent unauthorized access to computer resources. If a firewall is turned on but not correctly configured, attempts to connect to SQL Server might be blocked.

To access an instance of the SQL Server through a firewall, you must configure the firewall on the computer that is running SQL Server to allow access. The firewall is a component of Microsoft Windows. You can also install a firewall from another company. This topic discusses how to configure the Windows firewall, but the basic principles apply to other firewall programs. ...Read more
Posted by: Teena
On 11 Oct 2011 | Views: 749 | Categories: Database (SQL Server)
1

Like

Ever since SQL Server 2005 was released, each object in a database has belonged to a database schema. SQL Server 2008 has continued with database schemas, and an explanation follows.

What is a Database Schema?
A database schema is a way to logically group objects such as tables, views, stored procedures etc. Think of a schema as a container of objects.

You can assign a user login permissions to a single schema so that the user can only access the objects they are authorized to access.

Schemas can be created and altered in a database, and users can be granted access to a schema. A sch ...Read more
Posted by: Teena
On 09 Oct 2011 | Views: 881 | Categories: Database (SQL Server)
0

Like

Stored procedures are a powerful part of SQL Server. They can assist programmers and administrators greatly in working with the database configuration and its data.

A stored procedure is a precompiled group of Transact-SQL statements, and is saved to the database (under the "Stored Procedures" node). Programmers and administrators can execute stored procedures either from the SQL Server Management Studio or from within an application as required.

Transact-SQL, which is based on SQL (Structured Query Language), is the programming language used to interface between applications a ...Read more
Posted by: Teena
On 09 Oct 2011 | Views: 1042 | Categories: Database (SQL Server)
0

Like

Although the DataReader is very fast and simple, in many situations, we're going to need more than just forward-only access to the results of our queries - this is where the DataSet and SqlDataAdapter classes come in. The DataSet is essentially an in-memory database, complete with multiple tables, constraints, running queries and sorting, plus the ability to persist its state to an XML file. You can use SqlDataAdapter (and its cousins OleDbDataAdapter and OdbcDataAdapter) to populate the DataSet with rows from a SQL server query. Once populated, you can make changes to the DataSet, add rows, p ...Read more
Posted by: Michael
On 15 Sep 2011 | Views: 923 | Categories: Database (SQL Server), ADO.NET
Page 11 of 11
Other lins

.Net Techies
Other lins