What are the differences between clustered and non-clustered index?
No Answer is Posted For this Question
Be the First to Post Answer
Explain the properties of subqueries in sql server?
Why use update_statistics command in sql server?
What command is used to delete a table from the database in the sql server and how?
Why do we use stored procedures in sql server?
What is a document index?
What is create statement?
Advantages and Disadvantages of Cursor?
15 Answers Polytechnic, TCS, Zenith,
What happens if the update subquery returns no rows in ms sql server?
What is replication with database mirroring? : sql server database administration
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
What is difference between stored procedure & function?
3 Answers CarrizalSoft Technologies, Concept Infoway, TATA,
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
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)