how can a database be repaired? : Sql server administration
No Answer is Posted For this Question
Be the First to Post Answer
Define cursor locking
Does group by or order by come first?
what are three different authentications to connect linked servers?
Explain the first normal form(1nf)?
How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?
When we are using this query to shrink the log file,what exactly it will execute internally? Do we lose any data when we run this script? which data it will truncate in the log file and where it is saved. Please let me know... USE DatabaseName GO DBCC SHRINKFILE(<TransactionLogName>, 1) BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY DBCC SHRINKFILE(<TransactionLogName>, 1) GO
What is read committed?
How can you find out how many rows returned in a cursor?
How to add an address record into adventureworkslt?
How to verify the port number of the sql server?
How can I create a report based on a query? : sql server management studio
Differentiate between truncate vs delete in mssql?
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)