Tempdb size increase become 20gb

Panic ! due to database system slow. After check the tempdb is very big wow amasing coz actually user db only 15gb , after search and discuss with superior and try shrink db, and use bellow script then size become smaller. I think this script very usefull to me.

USE [tempdb]
GO
DBCC SHRINKFILE (N’tempdev’ , 0, TRUNCATEONLY)
GO

before :

tempdb big

after :

tempdb

Iklan
Tempdb size increase become 20gb

A Small Collection of DBCC Commands

Glenn Berry's SQL Server Performance

There are a number of pretty useful DBCC Commands that have nothing to do with checking the consistency of a database (and thus were probably not written by Paul Randal).  I have put together a few of them in the script below.  The first command is the only one that I consider to be somewhat “dangerous”, in that it will completely flush the contents of your “clean’ buffer cache, which will cause a lot of stress on your I/O subsystem as the buffer cache is refilled from disk. Depending on your workload, this might take a few minutes to happen, during which time you would see a performance impact.

-- A Small Collection of Useful DBCC Commands
-- Glenn Berry 
-- August 2010
-- http://glennberrysqlperformance.spaces.live.com/
-- Twitter: GlennAlanBerry


-- Clears out contents of buffer cache
-- Use caution before doing this on a production system!
DBCC DROPCLEANBUFFERS;

-- Clears…

Lihat pos aslinya 203 kata lagi

A Small Collection of DBCC Commands

Tips Photography

Tips and Tricks for Getting the Pictures you Want

TIP

There are two Priority Modes on your camera that can help make shooting easier while still having some control over the exposure of your image. When you’re shooting in a priority mode you decide which exposure setting you want to control – Aperture or Shutter Speed, while the camera can automatically adjust the others to ensure a good exposure.

TIP

When in Aperture Priority mode keep in mind that when you use a small Aperture, the Shutter Speed will adjust to stay open longer. Long shutter times will pick-up any hand movement so use a tripod.

TIP

Shutter Priority Mode (represented by Tv), allows you to focus on how motion is being captured, while automatically setting your Aperture and ISO. So if you’re shooting a track meet or a car race, you will probably want to use Shutter Priority.

TIP

Think of Aperture and Shutter Speed as balanced variables. If your settings are giving you a good exposure but you want to increase the size of your Aperture by one stop (or click) – you will also need to decrease your shutter speed by one stop to get the same balanced exposure.

TIP

Remember that using a very high ISO may add some digital noise. So always start with a low ISO and adjust if necessary to achieve the effect you want.

TIP

When taking pictures, just remember the following: ISO affects Noise, Aperture affects Depth-of-Field (DOF), Shutter affects Motion.

TIP

Be aware that a longer Shutter Speed will show any movement from your hand. Try steadying your camera or using a tripod.

TIP

Remember that sometimes natural light gives you the most beautiful results.

TIP

By adjusting your exposure settings you can capture amazing moments in low light and bright light.

TIP

On a bright sunny day using a smaller aperture and short shutter speed may get you a good exposure.

TIP

Shooting a scene with low light is going to need a larger aperture and/or a longer shutter speed. Remember to steady the camera if you are using a longer shutter speed.

 

(from Canon )

Tips Photography

Basic Manual settings for cool visual effects

A Little About Exposure: Exposure is the amount of light a digital camera’s sensor captures when a photo is taken. Too much light results in a washed out photo (overexposed). Too little light and the photo will be too dark (underexposed). A camera’s Aperture, Shutter Speed and ISO settings directly affect exposure, but more importantly, they allow you to control how each photo will look.

Aperture – Control the amount of blur or sharpness around your subject.

What it is and what it does: The aperture setting controls the size of the lens opening that allows light into your camera.You can blur the foreground and background that bracket your subject (known as shallow depth of field) by opening up the aperture with a low f-stop number; alternatively, you can keep your photo sharp from the foreground through to the background (known as wide depth of field) by closing the aperture down with a high f-stop number.

Aperture: f/2.8

Foreground and background blur make the subject stand out. Great for portraits.

Aperture: f/22

The subject, foreground and background are sharp. Perfect for landscape shots.

Shutter Speed – Show the movement of a fast moving subject or freeze it in action.

What it is and what it does: The only thing between the light that has passed through the Aperture and the image sensor is a shutter. The Shutter Speed setting controls how long the shutter opens to expose the image sensor to that light. Open it for just a millisecond and you can freeze a fast moving subject. Alternatively, you can show the movement of a fast moving subject by keeping it open longer with a slow shutter speed.

Shutter Speed: 1/250 sec

The movement of the propellor has been captured with a ghosting effect. Great for stunning images of streams and waterfalls.

Shutter Speed: 1/4000 sec

Even though its moving the propellor looks frozen. Perfect for sports action shots.

ISO – Sense the right amount of light for the visual effect you want.

What it is and what it does: With the ISO setting a camera’s image sensor can be adjusted to detect more, or less light as needed for a good exposure. On a bright sunny day too much light hitting the sensor can cause an overexposure so make it less sensitive with a low ISO number. If your shooting conditions are dark the sensor needs to detect more light so increase its sensitivity with a higher ISO. High ISO will cause grainyness so as a rule use the lowest ISO possible. The photo effects you want to achieve with the aperture and shutter speed will impact the amount of light reaching the sensor, so use the ISO to adjust its sensitivity and get a good exposure.

ISO: 100

Shooting indoors with a low ISO means you will need more light to reach the sensor. Get more light to the sensor by opening your aperture and/or slowing your shutter speed. Low ISO is ideal for shots under bright sunlight.

ISO: 25,600

Shooting indoors with such a high ISO means you will need less light to reach the sensor. Reduce the amount of light reaching the sensor by narrowing your aperture and/or using a fast shutter speed. High ISO is ideal for night photography.

Exposure Meter- Sanity check your settings.

What it is and what it does: The Exposure Meter is your final check before you snap a shot. At a glance it tells you how your exposure will turn out based on the Aperture, Shutter Speed and ISO settings. A well exposed shot lines up right down the centre at zero. An underexposed shot (too little light) falls left of centre and an overexposed shot (too much light) falls right of centre. Use the Exposure Meter as a guide only, exposure is a matter of personal preference so don’t be affraid to wander off of zero.

 

(taken from canon)

Basic Manual settings for cool visual effects

Photography 101

 

Exposure Explained Simply

Understanding Exposure

Understanding the three elements that affect exposure (ISO, Shutter Speed and Aperture) and learning how to control them, will help you achieve the results you want in your final image. The first step is to determine the environment you’ll be shooting in. This will help you determine your ISO. The ISO controls the sensitivity of the image sensor in your camera. A high ISO setting means that the image sensor is operating at full capability and capturing more, so you don’t need as much light when you shoot at a high ISO. A high ISO will allow you to shoot in low light situations – like indoors at a dinner. With a low ISO – your sensor is not running at full capacity, which means that you have more flexibility in the amount of light you can let into your camera. A low ISO setting is perfect for a bright sunny day.

 

Setting the mood

The next step is to determine if you will be shooting a subject in motion, and, if so, how you want it to look. Your answer will help you set your shutter speed, which determines the length of time the shutter remains open. Leaving your shutter open a long time will let in lots of light and will capture motion as it moves – meaning you will see it as a blur. A short shutter speed, like a quick blink, freezes a moment in time without blur.

 

Selecting the focus

Lastly, you will determine what depth of field you want: If you only want just your subject in focus you will set a low aperture, which gives you a shallow depth of field. Conversely, a high aperture will lengthen your depth of field. The aperture controls the size of the lens opening. Like the pupil of the eye, open it wide in low light and make it small in full sunlight.

 

Setting the Exposure

To get a good exposure in manual mode you will need to balance between the aperture and shutter speed. A large aperture will let in lots of light, to balance this your shutter speed will need to be set for a shorter/faster time. When your aperture is smaller, there is less light coming into your camera so you can use a longer/slower shutter speed to compensate.

 

Your shooting environment

In photography, ambient light refers to any source of light in the scene that is not supplied by the photographer. Ambient light could be light from side table lamps, candles on a birthday cake or the lights on Christmas tree. Many photographers enjoy shooting with only ambient light because it helps preserve the atmosphere of the scene.

Since ambient lighting can be unpredictable, you need to be aware of your exposure settings for each and every photograph. In bright sunlight, your settings will need to be adjusted to decrease the amount of light your camera is capturing. When there is less light available (like when someone blowing out the candles on a birthday cake) you will need to adjust your settings to capture more light.

(from canon)

Photography 101

Order Management System for Contract Logistic Company

JRS Creative Galleries

Another system that i’ve build is Order Management System. Spesifically for Contract Logistic Company.

This system provide many benefit such as:

  • Order Tracibility
  • Real Time Report
  • Automated Instruction
  • Easy Order Monitoring
  • Reduce Input Needed
  • Etc.

There are some screenshoots of the system

Quick Menu Quick Menu

Order Lists Order Lists

Add Order Add Order

Order Detail and Quick Order Flow Order Detail and Quick Order Flow

Execution Detail Execution Detail

Lihat pos aslinya

Order Management System for Contract Logistic Company