what are cursors? : Sql server database administration
No Answer is Posted For this Question
Be the First to Post Answer
Write query to return all rows sql?
How to test subquery results with the exists operator?
How to provide default values to stored procedure parameters?
What is a natural primary key?
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 view and materialized view?
Does partitioning ssd reduce performance?
what stored procedure would you use to view lock information? : Sql server administration
What is bcp? When does it used?
what is mean by crystal repoart? ahere we will mainly use that?
what stored procedure can you use to display the current processes? : Sql server administration
Explain transaction server consistency?
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)