What are the dmvs? : sql server database administration
No Answer is Posted For this Question
Be the First to Post Answer
What is nonclustered index on computed columns?
What is full outer join in sql server joins?
What is analysis service repository?
What is trigger in salesforce?
What does it mean to have quoted_identifier on? What are the implications of having it off?
What is table join?
What is excution Plan in sql server
1 Answers CarrizalSoft Technologies, TCS,
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
How to implement service broker?
Does group by or order by come first?
Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
What is table constraint?
Oracle (3253)
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)