You need DateAdd; 59 seconds + 1 = 0 seconds, not 60

So this is the construction to use:

SELECT

 DATEPART(SECOND,DATEADD(s,1,GETDATE()))

(NOLOCK):

Open the query analyser and open 3 connections.

First connection:

Create Table MyTest(TestField1 char(2), TestValue int, constraint [pk_mytest] primary key nonclustered (TestField1) with fillfactor=90 )

begin Transaction

Insert into MyTest(TestField1, TestValue)

Values ('AA', 1)

Insert into MyTest(TestField1,...

To prevent blocking, I always use the with (nolock) option in all readonly queries.

pro: why lock what you don't want to change

dis: reads uncommited data!

Grow of 100 Gb a month ????

What are you trying to do? - copying the complete internet?

We also restart the SQL every night (not only the SQL service, but the complete server).

We saw a great performance increase after we decided to do this.

About 4 years ago, we set up merge replication for our agents with SQL7.

We tested it for about 3 months with 4 subscribers and everything worked yust fine. Then we went...

Don't know if I am smarter 🙂

For security issues, we kept our SQL Server outside the domain and placed behind a firewall, so no one can login on windows credentials...

All our backups are done to a compressed folder (Backupsize: > 15 Gb per db).

We never had any problems with the backup or restore of these files; we use the restore...

Try the following:

1. Reindex the database:

--START SCRIPT

declare @table sysname

create table #tmp(TABLE_QUALIFIER sysname ,

 TABLE_OWNER sysname ,

 TABLE_NAME sysname ,

 TABLE_TYPE varchar(32),

 REMARKS varchar(254))

insert into #tmp(TABLE_QUALIFIER, TABLE_OWNER, TABLE_NAME, TABLE_TYPE, REMARKS)

exec sp_tables null,null,null, "'TABLE'"

declare x cursor for

 select

  TABLE_NAME

 from

  #tmp

open x

fetch next from x...

SQL2000: It's faster, it's more secure, and it has a SQL 7 compatiblity modus.

So, what is the problem?

To see how much memory is needed for processes outside SQL Server, I disable the SQL Server services, and restart the server.

The memory used by the server without the SQL...

Replace the line

rstvec.Fields("LastModifiedTime") = Now

with

rstvec.Fields("LastModifiedTime") = Format$(Now,"yyyy-mm-dd hh:nn:ss")

and it wil always work.

Set the option 'Auto Shrink' on this database; it will aso shrink the logfile after it is backed up.

A long time ago I had the same problem.

This problem disappeard completely when the network cabling was replaced.

So, I think it is a hardware or network congestion problem.