Technical Article

Transaction Log Will Not Truncate

I saw a posting recently of a DBA not being able to truncate a transaction log. I rememberred this script that I had, (downloaded from Microsoft Support many moons ago), which did the job for me. It basically filled the log with data, then truncated and shrank the log. All important points throughout the script […]

You rated this post out of 5. Change rating

2005-10-28 (first published: )

384 reads

Blogs

Flying Halfway Around the World to Australia

By

I leave tonight for Australia. I was in London 3 days ago, so this...

Dealing with Change – Two Resources

By

As I look at the state of information technology today, I see one constant:...

Cloud Databases Made Simple: Creating Your First AWS RDS Instance

By

I recently started full time learning of Amazon Web Services (AWS). I found that...

Read the latest Blogs

Forums

what is the BC338 NPN transistor?

By judy chen

The BC338 NPN transistor is a small but basic electronic component commonly utilized in...

Table with FK(s) to other columns within the table

By BOR15K

Hello All, I have recently joined a project, where main, core tables with millions...

SQL 2017 throwing BugCheck on differential database restore

By arran.franklin

Long time listener, first time caller. I have a problem that my usual bag...

Visit the forum

Question of the Day

Using Table Hints in a Query

How many table hints can I include in a query?  

See possible answers