Explain indexes disadvantages?
No Answer is Posted For this Question
Be the First to Post Answer
Can we perform backup restore operation on tempdb?
Explain how does the report manager work in ssrs?
What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas
List out the difference between union and union all in sql server?
What are constraints in microsoft sql server?
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 restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?
After recovering the database by using tail log backup.How to verify the data has been sucessfully restored or not.?
What is Left Outer Join?
What is the difference between getdate and sysdatetime?
What does it mean if @@cursor_row returns a negative number?
What is reference section?
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)