Which index created when Create Index on table(col), Why
Answers were Sorted based on User's Feedback
Answer / sanjay
whenever you create index without specifying the type, its
non-clustered.
| Is This Answer Correct ? | 5 Yes | 0 No |
How do I find the size of a sql server database?
what are database files and filegroups? : Sql server database administration
What is a table called, if it has neither cluster nor non-cluster index? What is it used for?
What is the fillfactor concept in indexes?
statement (of account) Receive ID_receive Date_receive Amount_receive TO_receive From_receive Description_receive 1 2010/01/01 500 Bank Ahmed Payment from the account 2 2010/02/01 700 Bank Ahmed Payment from the account Payment ID_payment Date_payment Amount_payment From_payment To_payment Description_payment 1 2010/03/01 1000 Ahmed Sales Sale goods 2 2010/04/01 1500 Ahmed Sales Sale goods How can crate Stored Procedures for the statement (of account) from these tables? I want statement (of account) like this: (in sql 2005) ID_ name description debit account credit account balance
Is oracle faster than sql server?
What is view in sql?
Do you know what is normalization of database? What are its benefits?
internal language used in sql server 2000?
What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas
What is onf in normalization form?
How to rebuild all indexes on a single table?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)