You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
No Answer is Posted For this Question
Be the First to Post Answer
What are the High-Availability solutions in SQL Server and differentiate them briefly?
What is 2nf example?
How extra digits are handled with numeric data type literals?
What is a linked server in sql server?
explain declarative management framework (dmf) in sql server 2008?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
Can you explain powershell included in sql server 2008?
What is order of B+tree?
What is buffer cash in sql server?
Can a stored procedure call another stored procedure. If yes what level and can it be controlled?
Explain what is public role in sql server?
How to create a login account in ms sql server to access the database engine using "create login" statements?
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)