Indexing in Microsoft SQL
What is an index in Microsoft SQL? What types of indexes are available in SQL Server 2005? Do I need to know about this to create and deploy a database?

Answer Question   |  August 27, 2010  8:08 PM
Database design, SQL, SQL Database, sql indexes, SQL Server 2005, SQL Server 2005 index strategy

How to keep date format when creating Index on a Table
I have used CREATE TABLE to create a PF which contain a DATE field. And then use CREATE INDEX to create a LF with data selections. However, when I check the DATE field, I find that, in the PF, its Date Format is *ISO; but in the LF, its Date Format has been changed to [...]

Answer Question   |  July 2, 2010  3:06 AM
SQL Database Indexing, sql indexes, SQL statements, SQL tables

SQL indexes
hello, there are many indexes clustered an non clustered .so how can i see the result of each index, clustered and non clustered seperately through (T-SQL) pls guide me. RINO

Answer Question   |  June 8, 2010  12:21 PM
sql indexes, SQL Server, T-SQL

SQL index on dds file
Will and existing rpg program that is doing a file read/table scan utilize an sql index with changing any of the rpg program?

Answer Question   |  March 5, 2010  2:43 PM
DDS, SQL, sql indexes