Updating database index
when i create a table with nearly 100 rows, database index gets update to accomodate those 100 rows. Can i find out the time taken by the index to get updated from previous state to a state to accomodate those 100 rows?

Answer Question   |  August 31, 2010  7:18 AM
Database, Database index strategy, Database management, Indexing, SQL Database Indexing

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

indexes on a large table
hello, i got a 5milion rows on a single table, my database is sql2005 and my select is : SELECT top * FROM tbl1 WHERE ip_from <= 3515134258 and ip_to >= 3515134258 the 3515134258 is on a sample but the format is similar: SELECT top 1 * FROM tbl1 WHERE ip_from <= [value] and ip_to [...]

Answer Question   |  November 11, 2008  7:33 PM
Index Performance, SQL 2005, SQL 2005 Database, SQL Database, SQL Database Indexing