How to shoot a noise free video with nikon d3100 at night?

I need camera configurations

Nikon 50mm f/1.8 G on D5100 for indoor equine?

So i've been doing some research for a couple of hours on what lens is best for indoor equine.
Now my 55-200 f/4 well.yeah.that's no use!

Someone had quoted:
"I need f/1.8 for ISO 3200-6400 at 1/500 on my D5100. Indoor sports has to be the most expensive thing to photograph!"

The photo under neath of the horse indoor with poor light was fantastic, visible noise was there, but it didn't bother me the slightest.

***I don't want to be wasting my money on this lens if i do buy it, but as its "50mm" is it that only? So no zoom?***

There's the 85mm but that's not compatible with the d5100:'(

***And would it shoot better videos too? Or is that to do with the video quality (as some frames are completely blurred out then 1-2 frames are in focus***

Thanks! Lots of research going into this!

Added (1). The zoom isn't a massive thing to me as i will be right next to the action/moving around etc

First DSLR camera, what do the number behind stand for?

In reguards to the lens. First off 18-55 mm? Then there's the f/3.5 - 5.6? Finally come the acronyms AF-S DX VR? I'm looking at the Nikon D3200 24.2 MP CMOS Digital SLR… This is just for pleasure. Taking pictures or moving kids!

Is there a problem with my camera/lens?

I bought a nikon d3100 a few days ago with the afs nikor 18-55mm lens

I'm not sure if it did this before but now when i hold the shutter button to focus, it makes a little rattley click noise. Then when i release the shutter button, it does the same noise.

Any ideas?

Nikon D5100 bad sports photos INDOOR?

Recently got this camera (i have the kit lens and a 55-200, if that solves anything)
And i have a massive massive interest in horses, that's literally what the card will be full of, and i'm not impressed with any of the photos i've taken.
This is a fast moving sport/hobby in my mind so i can't be standing around changing settings after every photo i've taken, i'll be missing the shots/

This is indoor, on sports mode (tried the pets mode, was worse) and the 'indoor' mode was laggy with a flash

It focuses perfectly on everything around it, but usually with a sports mode there's a moving focus green thing, which is usually there on other cameras

I tried changing the shutter speed to capture it quicker but the photo was pitch black.

This was with flash, because i got fustraited.

It may seem i have no idea what i'm on about but i'm new to this, and i just want to take some decent photos after paying So much for it

Please don't just say "practice" because thats such a wide word meaning "turning the camera on and off properly"

I want to know what i'm doing wrong! Thanks!

Added (1). Thank you very much everybody.
Are there any lenses under £550 instead of a £3000 lens to help the shutter speeds?

Nikon 70-300mm f/4-5.6G?

I have a Nikon D7000. I would like to get a zoom lens. The zoom lens I'm thinking is the Nikon 70-300mm f/4-5.6G. Can someone please let me know if this lens would be compatible with my Nikon D7000.

My camera is saying something but i don't know what to do?

My Nikon D3100 keeps saying on the screen Memory card is locked. Slide lock to "write" position.

i'm not so sure on what to do, all i did was put the memory card back in, it was working and didn't say this until now.

How to make my nikon d3000 focus on its own?

This probably sounds like a very stupid question but please don't make fun of me haha. How do i set it to where the camera does the focusing, not me?

What will give me the best image quality?

I'm going backpacking in Europe for a few weeks next summer and I plan to bring my dSLR, a zoom lens and a prime lens with me. Currently my best option would be to bring my Nikon D60 with my Nikkor 50mm f/1.8D and Nikkor 18-55mm VR lens. I want to know if buying the 16-85mm would make much of an improvement, and if so will it be worth it?
Also there's a great sale in town for a Nikon D7000 and the Nikkor 18-105mm VR lens for 1000$. Right now I'm debating making this purchase because I think a better lens will bring me a better image quality then purchasing a NEW body with the kit lens.

I'm also considering buying the Nikkor 35mm f/1.8G prime lens to bring with me instead of my 50mm prime. I believe the 35mm lens will be more handy indoors than the 50mm.

Anyway I just want your thoughts on that subject.

Best Nikon Camera (under 300 bucks) for beginners

I'm beginning photography, and I need to know what camera is best.

people are saying the Nikon D3100, but its too much money for me. What Nikon camera is best but under 300 bucks?