Explain an automatic checkpoint


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

Post New Answer

More SQL Server Interview Questions

there is a table having two columns no and name and the data is 1 A 2 B 3 C write a query that will result a horizontal output A,B,C

9 Answers   tdfc, vsworx,


Explain about analysis services?

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,


Is it possible to create tables in stored procedures using a variable for the table name?

2 Answers  


what are different types of raid configurations? : Sql server database administration

0 Answers  






What are the advantages to use stored procedures?

0 Answers   Ernst Young,


Difference between report and query parameter. Why do we need different type of parameter?

0 Answers  


How to include date and time values in sql statements?

0 Answers  


Difference between server.transfer and server.execute method?

2 Answers  


What is the difference between a Application Server and a Database

3 Answers   Oracle,


Define the one-to-one relationship while designing tables.

0 Answers  


What is log cache in sql server?

0 Answers  


Categories