how to do partition in sqlserver
No Answer is Posted For this Question
Be the First to Post Answer
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 the query optimization statistics?
What is sql service broker?
How to know whether our backup is succesfully taken?
What is difference between TRUNCATE and DELETE statement
What is Command line parameters in PLSQL.?
What are the types of stored procedures in an sql server?
What is relationship? What number of sorts of relationship are there?
How to skip remaining statements in a loop block using continue statements?
What are database states in ms sql server?
how do u find least salary in a table
what is the maximum size of a row in sql server 2000 and 2005
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)