April 2007 - Posts

0
Comments

SQL Server ANSI Information Schema Views by Kasim.Wirama

SQL Server ANSI Information Schema Views Based on the system tables, a set of ANSI views are defined in each database and inherited from the model database; they extract a limited set of information from the database system tables. Each view has the owner...
Filed under:
0
Comments

System Tables in SQL Server by Kasim.Wirama

System Tables in SQL Server According to the relational model, all data about a database’s tables should be kept in system tables. Every database has a set of catalog tables, which describe and govern all the data tables; and some databases, such...
Filed under:
0
Comments

More View Usage Variations in SQL Server by Kasim.Wirama

More View Usage Variations in SQL Server This article will show you how to use view for any scenarios that need improvisation such as partitioned views, function in view, and encrypting views. Partitioned View You can make a union of a set of views, provided...
Filed under:
2
Comments

Using View in SQL Server by Kasim.Wirama

Using View in SQL Server Views are virtual tables. They are really queries, but you can refer to them as though they were tables. For example, the following code creates a view : CREATE VIEW CA_Authors AS SELECT * FROM Authors WHERE state = ‘CA’...
Filed under:
1
Comments

Table Operations in SQL Server by Kasim.Wirama

Table Operations in SQL Server This article, I want to show you some operations on table such as determining table size, copying, renaming and deleting a table, and changing table structure through the ALTER TABLE command. Determining table size You can...
Filed under:
0
Comments

SQL SERVER Relational and Storage Engine by Kasim.Wirama

SQL SERVER Relational and Storage Engine There are a lot of factor to keep in mind when building databases in SQL Server. The context for understanding those factors begins with a fundamental fact about SQL Server architecture, namely that at its core...
Filed under:
2
Comments

Advanced Data Type Value in SQL Server by Kasim.Wirama

Advanced Data Type Value in SQL Server I will show you advanced data type in SQL Server. They are: default values, null, identity property, uniqueidentifier, Unicode character data, and computed columns. You can also specify whether you want a column...
Filed under:
0
Comments

Data Types in SQL Server by Kasim.Wirama

Data Types in SQL Server Topic for this article seems very simple. But worth it to know because improper data types will impact to suboptimal database performance. Every database columns have data types that limit the kind of data that can be stored in...
Filed under:
0
Comments

Storage Engine in SQL Server by Kasim.Wirama

Storage Engine in SQL Server Storage engine stores and retrieves data for the query engine. First of all, SQL Server has a larger page size (8KB) and this change has a ripple effect throughout SQL Server storage structure. Extents are now 64 KB (8 pages...
Filed under:
1
Comments

Using BULK INSERT T-SQL Server Command by Kasim.Wirama

Using BULK INSERT T-SQL Server Command SQL Server add one more interesting advance with the BULK INSERT command. This command is used to imports data from a bcp-formatted text file into SQL Server, and you do not need to invoke BCP externally to use it...
Filed under:
0
Comments

Bulk Copy Data Into SQL Server by Kasim.Wirama

Bulk Copy Data Into SQL Server If external and internal SQL table does not have same structure, you should use BCP format file and change it to fit the data. To create a format file in BCP, you had to avoid specifying either /c or /n in bcp command and...
Filed under:
0
Comments

Bulk Copy Data Out from SQL Server by Kasim.Wirama

Bulk Copy Data Out from SQL Server Sometimes you want to bulk insert data from external source to SQL Server. Common external resource is from other SQL Server or flat file. This article, I want to show you how to insert external data into SQL Server...
Filed under:
0
Comments

Security Function in SQL Server by Kasim.Wirama

Security Function in SQL Server If you want to track login name, user name or role membership for each login, a full set of security functions are provided by SQL Server. These security functions enable you to restrict what portions of database data a...
Filed under:
0
Comments

Object Level Permissions in SQL Server by Kasim.Wirama

Object Level Permissions in SQL Server Besides database level permissions, you can grant permission on database object level. The kinds of permissions you can grant are: Table or view : SELECT, INSERT, UPDATE, and DELETE Stored procedure : EXECUTE By...
Filed under:
0
Comments

Permissions in SQL Server by Kasim.Wirama

Permissions in SQL Server I will show permission feature in SQL Server, and how you can correctly implement permission for securing your SQL Server database. When a database has already had database users and roles, you can grant permissions to database...
Filed under:
More Posts Next page »
Copyright © INDC, 2006. All rights reserved.
Powered by Community Server (Commercial Edition), by Telligent Systems