Explain an automatic checkpoint
No Answer is Posted For this Question
Be the First to Post Answer
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
Explain about analysis services?
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
Is it possible to create tables in stored procedures using a variable for the table name?
what are different types of raid configurations? : Sql server database administration
What are the advantages to use stored procedures?
Difference between report and query parameter. Why do we need different type of parameter?
How to include date and time values in sql statements?
Difference between server.transfer and server.execute method?
What is the difference between a Application Server and a Database
Define the one-to-one relationship while designing tables.
What is log cache in sql server?