truncate the log file of a Microsoft SQL database
With SQL 2000 always ran into the problem of the automatic log file size of the database, it defaults to the LDF file grows in size continuously until it reaches the maximum size set in the database, or worse, up to end of disk space.
This situation is created simply because the LDF file keeps track of all transactions, even when properly committed.
To resolve this problem, simply run the command: DBCC
BACKUP LOG [database name] WITH TRUNCATE_ONLY
simple, immediate, and above all, decisive.
via: merlinox.tumblr.com
Thursday, July 31, 2008
Thursday, July 17, 2008
What Is The White Mucus In My Urine
Quick Restart services
developing batch applications that perform tasks in a Microsoft environment, one is invariably working with windows services.
With this type of programs the way they work is slightly different, and so no longer able to launch applications with the development environment, it is more often confronted with the awkward interface for managing services.
Well, well the end is not uncomfortable, but working with and debugging these applications there is a stop and start hundreds of times a day.
order to stop and then start the services with a single click, you can easily create a. Bat with these 3 lines of code:
NET STOP "service name"
pause net start "service name"
The pause between the two commands is essential, because operationally it will launch this command, the service is stopped as soon as you can compile the executable, and a completed build with a single shipment in the DOS window open, you can restart the service.
Comfortable, convenient and quick ...
developing batch applications that perform tasks in a Microsoft environment, one is invariably working with windows services.
With this type of programs the way they work is slightly different, and so no longer able to launch applications with the development environment, it is more often confronted with the awkward interface for managing services.
Well, well the end is not uncomfortable, but working with and debugging these applications there is a stop and start hundreds of times a day.
order to stop and then start the services with a single click, you can easily create a. Bat with these 3 lines of code:
NET STOP "service name"
pause net start "service name"
The pause between the two commands is essential, because operationally it will launch this command, the service is stopped as soon as you can compile the executable, and a completed build with a single shipment in the DOS window open, you can restart the service.
Comfortable, convenient and quick ...
Tuesday, July 15, 2008
How To Replace Cigarette Lighter Receptical
SandBox, a protected environment to perform software
Some time ago, downloading a software from the network while I've just updated the virus infected my pc with an unpleasant troian.Da then, in addition to solving the problem of anti-virus, I started to run into a suspicious file secure environment. I always just one click away from a virtual machine and start if necessary, once checked and tested the software I use on the real machine.
A few days ago I discovered a much more practical.
software Sandboxie fact is responsible for running a particular software you choose, in a "black box" by not allowing the process you direct access to writing the disc.
Image http://www.sandboxie.com/
Much more practical than a slow virtual machine, and altogether effective.
Some time ago, downloading a software from the network while I've just updated the virus infected my pc with an unpleasant troian.Da then, in addition to solving the problem of anti-virus, I started to run into a suspicious file secure environment. I always just one click away from a virtual machine and start if necessary, once checked and tested the software I use on the real machine.
A few days ago I discovered a much more practical.
software Sandboxie fact is responsible for running a particular software you choose, in a "black box" by not allowing the process you direct access to writing the disc.
Image http://www.sandboxie.com/
Much more practical than a slow virtual machine, and altogether effective.
Thursday, July 10, 2008
Electronic Stratego Buy
My PC has a black hole!!
I looked at my PC and I found the following items ...
- Browse the entire network
- My Bluetooth
- Research new hardware
-
Empty Recycle Bin - Delete Temporary Internet files ...
...
these things have in common?
Well ... no matter how powerful your PC is, how many processors are available or how much RAM is installed, use these components will make the PC unusable for a short period, often arbitrary ...
Well ... have access to a hole black for the performance ...
I looked at my PC and I found the following items ...
- Browse the entire network
- My Bluetooth
- Research new hardware
-
Empty Recycle Bin - Delete Temporary Internet files ...
...
these things have in common?
Well ... no matter how powerful your PC is, how many processors are available or how much RAM is installed, use these components will make the PC unusable for a short period, often arbitrary ...
Well ... have access to a hole black for the performance ...
Subscribe to:
Posts (Atom)