Arkiv för kategorin 'SQL-server'

Query designer in management studio sql server 2005

torsdag 17 april, 2008 kl. 10:58 f m

I have been using Management Studio for SQL-server 2005 for a while now. However, I have never really liked it because of the really strange user interface. Compared to the simple Enterprise manager I first thought that Management studio was a nightmare. But I guess it takes some time to get used to…
I have […]

Publicerat i SQL-server | Inga kommentarer »

Shrinking ALL Truncate Log Files

torsdag 13 december, 2007 kl. 4:48 e m

The transaction logs on your SQL-server can fill up a lot of disk space. In my case, I monthly needed to truncate all the log files from the databases that I get from our production environment. These log files are really huge. I need to truncate them because I do not need the logs on […]

Publicerat i SQL-server | Inga kommentarer »