Archive for 'SQL Server'
Hostname Column in SQL Profiler 2005
If you are using SQL Profiler and you want to know which workstation is using the db you should use the hostname column in sql profiler.
While this was relatively straight forward in SQL Server 2000, users of SQL Server 2005 may find that the hostname column is not displayed when running the SQL Profiler. By [...]
Posted: March 31st, 2009 under SQL Server.
Tags: hostname, SQL Profiler, SQL Server 2005
Comments: none
Deleting large number of rows without filling the transaction log
Sometimes, when you try to delete a large number of rows from a table the transaction file may grow to the point that you will run out of disk space. In other occasions, when the transaction log growth is limited, the delete can fail with the following message:
The transaction log for database ‘database name’ is [...]
Posted: November 24th, 2008 under SQL Server.
Tags: delete, full, SQL Server, transaction log
Comments: 1
What to do when ldf file grows
If you noticed that the free space on your hard drive is shrinking and you found that the log LDF file is taking most of it (and growing) don’t panic.
it is possible that the reason is that your recovery mode is is set to full.
to change this:
1) Right click on the db (in SQL server [...]
Posted: September 17th, 2008 under SQL Server.
Tags: LDF, SQL Server
Comments: 2