Display by: Title | Popularity

1). How to Mine Information on the Web Any serious discussion of how to use the web effectively will inevitably center around search tools. Quite simply, ones success in finding informa 2). Secrets of Successful Websites - Part 2 As the Renaissance swept across Europe during the 15th and 16th centuries, it was fueled by Johannes Gutenberg’s information-processing machine: t 3). Secrets of Successful Websites - Part 3 The trick is in satisfying all of the different requirements of a website at the same time, and delivering excellence in multiple dimensions. Con 4). SQL Server 2000 Data Types SQL Server requires that each variable and column in a table should be defined with respect to the type of data it will store. From a bit to a huge image and binary storage types, the allocation is supposed to help the user conform to the data required, and help the engine allocate space and processing speed efficiently. Built-in data... 5). SQL Server Indexes "SQL Server Indexes A database index is similar to an index in a book – it is comprised of a lookup value, and a number identifier that corresponds to the row number in a table. In SQL Server, there are two kinds of indexes – clustered and non-clustered. Clustered Indexes require that the data in the table is physically sorted in the order of... 6). SQL Server Security There are several levels of security to SQL Server. At the a base level, in order to be granted get access to a SQL Server, a user is required to have a login account. There are two modes of security to SQL Server, distinguished by which program provides the authentication. NT Authentication provides that Windows NT (and/or its succes... 7). SQL Server Stored Procedures "SQL Server Stored Procedures Stored Procedures are SQL statements saved in a database as a n object. They can be called interactively through the Query Analyzer, and by other stored procedures. They can be defined with parameters to make them more flexible, and can return result sets and status codes. Their advantages include:... 8). SQL Server System Stored Procedures System Stored Procedures System stored procedures are packaged with SQL Server. Many procedures are used to administer SQL Server, but some are utilities that can be profitablly used by developers. They are global, and can be called from any database application without their fully qualified name. (They are all owned by dbo.) . They are all stored ... 9). SQL Server Triggers Triggers are stored procedures which are fired when data is modified in an underlying table. They can evaluate data being added to a table for validation purposes, or can make changes in that or other fields depending on the value of that data. You can use them even to execute a separate stored procedure, or to roll back a data modification or an e...