explain different types of constraints? : Sql server database administration
No Answer is Posted For this Question
Be the First to Post Answer
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
Explain atomicity?
What is a trace frag?
what's new in sql server 2016?
What is acid mean in sql server?
what is database replicaion? : Sql server database administration
How can I get data from a database on another server?
What are relationships and mention different types of relationships in the dbms
How do we return a record set from a Stored Procedure in SQl server 2000?
What is updatable resultset?
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 the use of nvl work?
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)