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) 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.
2535Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?
2 4763
What is query image?
What is percent sign in sql?
Explain how you can configure a running aggregate in SSRS?
What do you mean by field in sql?
What is bulk collect in pl sql?
What is a heap table?
Do you know what are different types of replication in sql server?
Define implicit and explicit cursors.
What is the command syntax that tells you whether you are on the master server or not? And how many master does mongodb allow?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
Are stored procedures precompiled?
How to convert character strings to dates?
What are the advantages of using Query Strings?
What is a ctid?
What is clustered vs nonclustered index?