Where do we generally create INDEX?
- 1 Answers
- 2285 Views
- Ernst Young, Thomson Reuters, I also Faced
- E-Mail Answers
What is tempdb database? : SQL Server Architecture
Explain the difference between clustered and non-clustered index?
What do you mean by an execution plan? Why is it used?
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE (cond1...or..cond2....or...cond3...and.....so on.....??? (upto how much extent))?????
What is faster join or union?
What is spid in sql server profiler?
How can I change procedure name in sql server?
Define self join?
Explain why variables called the most powerful component of ssis?
I Have Employee table having column name as ID,SALARY how to get second max salary from employee table with id ex ID SALARY 1 20000 7 37000 2 5000
17 Answers HCL, IBM,
How To Find That One Week Change in My DataBase we Have Done Like We Have A database Test I Change Table,Stored Procd. Then I Find Which SP,Table We Have Edit/Change in Seven Dayes
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
