Explain indexed views and partitioned view with their syntax.
No Answer is Posted For this Question
Be the First to Post Answer
What is a primary index?
what is nonclustered index
employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.
What does REVERT do in SQL Server 2005?
How to read data in a table with "select" statements?
Tell me what is log shipping?
Tell me what is a linked server?
How would you choose between a clustered and a non-clustered index?
What are the extra roles available in msdb? : sql server security
one table has four field id,name,design,salary. i have to find maximum salary .
How can I track the changes or identify the latest insert-update-delete from a table?
What is extended stored procedures?
Oracle (3259)
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)