Interested to Buy Any Domain ? << Click Here >> for more details...
how to control the amount of free space in your index pages? : Sql server database administration
- 0 Answers
- 1019 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
how can u get last observation in an unknown dataset ?
Determine when to use stored procedure to complete sql server tasks?
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 temporary table in sql server? Why we use temp table?
Explain external key management in sql server 2008
How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?
Can I delete event logs?
Is truncate autocommit?
Explain “@@rowcount” and “@@error” in sql server?
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
How to modify an existing user defined function?
can a database be shrunk to 0 bytes, if not, why? : Sql server administration
-
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)
