Following are tips which will increase your SQL performance :-
1. Every index increases the time takes to perform INSERTS, UPDATES and DELETES, so the number of indexes should not be too much. Try to use maximum 4-5 indexes on one table, not more. If you have read-only table,then the number of indexes may be increased.
2. [...]
It is a Form of attack on a database-driven Web site in which the attacker executes unauthorized SQL commands by taking advantage of insecure code on a system connected to the Internet, bypassing the firewall. SQL injection attacks are used to steal information from a database from which the data would normally not be available [...]
The common language runtime manages memory, thread execution, code execution, code safety verification, compilation, and other system services. These features are intrinsic to the managed code that runs on the common language runtime.
With regards to security, managed components are awarded varying degrees of trust, depending on a number of factors that include their origin (such [...]
This article summarizes the technologies that are in the .NET Framework 2.0, technologies that are in .NET Framework 3.0, and the features that are in the .NET Framework 3.5. This list is not exhaustive; it lists just some of the major technologies that ship in the .NET Framework.
Technologies in the .NET Framework 2.0
The following technologies [...]
The ‘fill factor’ option specifies how full SQL server will make each index page. When there is no free space to insert new row on the index page, SQL Server will create new index page and transfer some rows from the previous page to the new one. This operation is called page splits. You can [...]
Transaction Isolation level decides how is one process isolated from other process.Using transaction levels you can implement locking in SQL SERVER. There are four transaction levels in SQL SERVER :-
1. READ COMMITTED
The shared lock is held for the duration of the transaction, meaning that no other transactions can change the data at the same time. [...]
Depending on the transaction level six types of lock can be acquired on data :-
1. Intent Locks
The intent lock shows the future intention of SQL Server’s lock manager to acquire locks on a specific unit of data for a particular transaction. SQL Server uses intent locks to queue exclusive locks, thereby ensuring that these locks [...]
Replication is way of keeping data synchronized in multiple databases. SQL server Replication has two important aspects publisher and subscriber.
Publisher
Database server that makes data available for replication is called as publisher.
Subscriber
Database Servers that get data from the publishers is called as Subscribers.
There are three types of replication supported by SQL SERVER:-
Snapshot Replication.
Snapshot Replication takes snapshot [...]
Bored by using the same Rectangular Button Control from your toolbox. Us the method mentioned below to create a new control named CircularButton in your toolbox and use it in your Form.
Step 1> Just Download the Zip file and unzip to get the Control.
Step 2> Right Click on your Toolbox and Choose the option “Choose [...]
Download Source Files on All Navigation Features
You can use the SiteMapPath, TreeView, or Menu controls to provide a consistent way for users to navigate your Web site. The SiteMapPath control displays a navigation path, which is also known as a breadcrumb, or eyebrow, that shows the current page location and displays links as a path [...]