query processing
No Answer is Posted For this Question
Be the First to Post Answer
What is Check point? Explain in Brief what it will do?
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
What is 3nf normalization?
How can I know what query is executing by by a particural user? (using sp id or any othe way.)
Define inner join? Explain with an example?
what is a check constraint?
How dts is used to extract, transform and consolidate data?
What are different backups available in sql server?
What are the different index configurations a table can have?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
How to transfer Logins from SQL Server 2000 to 2005
how can you attach more than 20 ldf files in sql server
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)