Is this possible? SQL Server 2000 Write times

I created an online application for one of our educational programs. The da
ta is inserted via website entry -> client side validation -> stored procedu
re -> database. Given a table stucture as follows, if 100 or even 1000 peop
le applied at the exact same time using an online application, what is the m
aximum time interval that could separate each record. How long would SQL Se
rver 2000 generally take to insert each record into the database. The probl
em is that each year, only the top 100 students are admitted in the program,
but there is one student who says they applied at 9:00 am and their record
insert time shows 9:59am. There are records before it and after it that sho
ws times like 9:58, 9:58, 9:59: 10:00, 10:00, etc. Could it really take SQL
Server 59 minutes to actually write the record if 1000 people hit the datab
ase at the same time? Please help, they want to get counsil involved.
ApplicantID int primary key identity
SSN varchar(11)
FirstName varchar(30)
LastName varchar(50)indexed
Address varchar (50)
City varchar (50)
State char (2)
Zip varchar (11)
Phone varchar (20)
Email varchar (50)
dateEntered smalldatetimeShawn Ferguson wrote:
> I created an online application for one of our educational programs.
> The data is inserted via website entry -> client side validation ->
> stored procedure -> database. Given a table stucture as follows, if 100
> or even 1000 people applied at the exact same time using an online
> application, what is the maximum time interval that could separate each
> record. How long would SQL Server 2000 generally take to insert each
> record into the database. The problem is that each year, only the top
> 100 students are admitted in the program, but there is one student who
> says they applied at 9:00 am and their record insert time shows 9:59am.
> There are records before it and after it that shows times like 9:58,
> 9:58, 9:59: 10:00, 10:00, etc. Could it really take SQL Server 59
> minutes to actually write the record if 1000 people hit the database at
> the same time? Please help, they want to get counsil involved.
> ApplicantID int primary key identity
> SSN varchar(11)
> FirstName varchar(30)
> LastName varchar(50)indexed
> Address varchar (50)
> City varchar (50)
> State char (2)
> Zip varchar (11)
> Phone varchar (20)
> Email varchar (50)
> dateEntered smalldatetime
I would not expect that sort of delay. 9:00am/9:59am, could there be a
time zone discrepancy? Can you use your website logs to determine when
the user made their submission?

is there documenation on format of transaction log entries

I searched the forums and SQL 2005 book online to see if Microsoft provides documentation on the format of transaction log entries. I could not find any...

Will Microsoft provides this documentation? It will also be nice if Microsoft will provide utilities to help us read content of transaction logs (online or backup file)? This will be quite helpful for DBAs.

Oracle provides a FREE utility called log miner... This tool is quite helpful. I know there are vendors that sell utilities to process transaction logs ( Log Explorer). I would like more flexibility.

If Microsoft does not provide documentation or utilities in SQL 2005, what would be the reasons? These things can help DBAs, thus will help Microsoft sell SQL 2005.

Thanks.

Microsoft does not provide the format of its files to everyone. Microsoft does work with third party vendors to provide additional functionality (as you mentioned).

Please work with the third party vendors to get more features and the flexibility that you want.

Thank you,
Mark Wistrom

Is there any sp deals with the table sysproperties ?

Hi,
Is the table sysproperties a new added one to sql 8.0 ?
Because I cannot found the description about it in SQL
Server Online book.
BTW: Is there any sp deals with this table ?
Thansk
.Hi,
Thanks.
>--Original Message--
>Hi,
>sysproperties is used to store the extended
properties .Adding and
>retrieving extended properties was introduced in
SQL2000.But for that there
>is no need to use sysproperties, instead you can use the
system functions
>sp_addextendedproperty and ::fn_listextendedproperty.
>--
>Dinesh.
>SQL Server FAQ at
>http://www.tkdinesh.com
>"gohigh" <gohigh@.sh163.net> wrote in message
>news:01e201c356b2$45835c30$a101280a@.phx.gbl...
>> Hi,
>> Is the table sysproperties a new added one to sql 8.0 ?
>> Because I cannot found the description about it in SQL
>> Server Online book.
>> BTW: Is there any sp deals with this table ?
>> Thansk
>> .
>>
>
>.
>

Is there an Online Remote SQL Server I can test against?

Hi

I am trying to connect an application to a remote sql server database, however it does not appear to eb configured for remote connections.

Does anyone know a connection string of a database I can connect to , soem sort of learnsers database sort of idea ?

Thank you.Fo anyone looking at the post ,just download SQL express