Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / dharmendra k dixit
INDEX are physical address of data, its is same just we
Have indexes in our Book..through this we can make our
search much faster.
in Idle way always try to make Indexes on that Column which
have Integer Value(i.e. Not on text type).
There are two types of Indexes in SQL SEREVR
1. Clusterd Index.(Create automatically if there is a
Primary key on Table)
2. Non Clusterd Index.
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
How many types of triggers are there?
What area unit the various kinds of info compression introduced in sql server 2008?
Does the unique constraint create an index?
How to create new tables with "select ... Into" statements in ms sql server?
Explain how many normalization forms?
What is a data source or ds? : sql server analysis services, ssas
In which tcp/ip port does sql server run? Can it be changed?
What is collation?
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
What is SQL Azure Data sync?
What are the results of running this script?
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
What are the triggers in sql?
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
Explain the working of sql privileges?
