What is the optimization being performed in oracle and SQL Server?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

What is meant by indexing?

0 Answers  


How to delete multiple rows with one delete statement in ms sql server?

0 Answers  


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

1 Answers   Cognizant,


What is the difference between update lock and exclusive lock?

0 Answers  


Explain what is analysis service repository?

0 Answers  






How to check parameter value in stored procedure sql server?

0 Answers  


Tell me what are the advantages of using stored procedures?

0 Answers  


How check triggers in sql server?

0 Answers  


Explain log shipping?

0 Answers  


can you any body tell me the how to decrease the logfile

4 Answers  


What is named query? : sql server analysis services, ssas

0 Answers  


How to list all dsn entries on your local machine using odbc_data_source()?

0 Answers  


Categories