Showing posts with label sqldatabase. Show all posts
Showing posts with label sqldatabase. Show all posts

Wednesday, March 21, 2012

image datatype

Is the Image Datatype to store pictures and if so how would you transfer a picture in asp.net into a sqldatabase that has this datatype?

if it isnt for pictures what is it used for?the image datatype can be used for any binary files. Not just images.

Check out microsoft's 23 C# samples. One of them does exactly what you want!

http://msdn.microsoft.com/vcsharp/downloads/samples/23samples/default.aspx|||it doesnt work:(
i tried to download it and it said it could not perform my requestsql

Friday, March 9, 2012

IIS Logs Max Per Hour

Hi
Being very new to SQL so iam hoping that this will be
easy.
Using a dts package to transfer IIS logs into a SQL
database i would now like to knpw of there is any
resource that gives some idea on the best stats to take
from IIS Logs.
i have create a query that is a count of [c-ip] i would
like to find out what is the max hourly count of [c-ip]
grouped by day the data is very mixed as when log a is
recorded could be 3 a second or not one for a few
seconds ? but generally data is at per second level?

Quote:

Originally posted by Simon Jelinek
Hi
Being very new to SQL so iam hoping that this will be
easy.
Using a dts package to transfer IIS logs into a SQL
database i would now like to knpw of there is any
resource that gives some idea on the best stats to take
from IIS Logs.
i have create a query that is a count of [c-ip] i would
like to find out what is the max hourly count of [c-ip]
grouped by day the data is very mixed as when log a is
recorded could be 3 a second or not one for a few
seconds ? but generally data is at per second level?

Try asking your manager, I hear he is very good at this sort of thing