You could use an index on tsdt if the range is selective enough

Why are there so many char() fields? Varchar is usually smaller

The problem is when the query returns multiple records

@KOD_1 can contain only one value

John Kandrovy (1/22/2008)

---

Hi we are having a problem on our live server.... whenever we run a query on one of our major tables in Enterprise Manager, it creates locks in...

Not sure where you can download the personal edition

The enterprise evaluation edition (120 days) can be downloaded from:

http://www.microsoft.com/downloads/details.aspx?familyid=d20ba6e1-f44c-4781-a6bb-f60e02dc1335&displaylang=en

Upgrading evaluation to retail:

http://support.microsoft.com/kb/281574/

Hello,

I've currently 3 different stored procedures with the same generic layout

EXECUTE master.dbo.USP_BACKUP_DATABASE @DatabaseNaam='MYDB'

EXECUTE master.dbo.USP_BACKUP_DATABASE_DIFF @DatabaseNaam='MYDB'

EXECUTE master.dbo.USP_BACKUP_DATABASE_LOG @DatabaseNaam='MYDB'

Currently redesigning it for controlled restores.

Someone posted an artikel about custom logshipping about a...

Try to find out what causes the pagelatch

1) exclusive updates

2) cpu-resources

3) i/o resources

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/dw_perf_top10.mspx

What version of sql server 2000 are you using and what is its patch level (sp3, sp4, hotfixes)

Could there be a sql agent job running under his username?

Is there difference in hostnames?

depends on the blade

Things to consider:

Does the database has to share anything with other programs

Are the I/O capabilities sufficient (and not shared)?

Are the cpu(s) sufficient?

My backup procedure has the following structure

DECLARE @DatabaseName varchar(1000)

DECLARE @BackupLocation varchar(1000)

DECLARE @DayExtension varchar(1000)

/*adding day + time*/

SET @DayExtension =REPLACE(REPLACE(REPLACE(convert(varchar(30),CURRENT_TIMESTAMP,120),'-','_'),':','_'),' ','_')

SET @Backuplocation= '...defaultlocation...'

/*defaultlocation*/

SET @BackupLocation=@Backuplocation+'\'+@DatabaseName+'_'+@DayExtension +'_DIFF.BAK'

BACKUP DATABASE @DatabaseName

TO DISK = @BackupLocation

WITH INIT ,...

offtopic:

I recommend not to use the sa-account for software.

A. It is a well known superadministrator account.

Because of that:

*There exist alot of program's to crack passwords, having the account name helps.

*Sometimes...

infact when i m getting disconnected with client, i have to restart the client computer and the connection gets eshtablished again...........

That sounds fishy.

What method do you use when to connect...

Is this a intermittent error or always?

1)Check if the network connection is primestable

2)Check the integrity of your database. An integrity fault due corruption can cause an aborted connection.

More things to...

I'll have to recheck it.

What edition of sql server 2000 is it? Standard,Enterprise,.. 32-bit or 64-bit

What edition of windows 2003 is it ? Standard,Enterprise,...

Your problem problably has been discussed on

http://sql-server-performance.com/Community/forums/p/24896/138597.aspx#138597

but...

insert into #ALLQ

select * --below will be treated as a "table"

from

(

SELECT 'T'+ T334.C2 + RIGHT(T334.C1,7) -- error message point to here

+ @TimeranH +@TimeranM +@TimeranS +@TimeranN,

@user1,C536870929, T.[RANK]

FROM ARSystem.dbo.T334 [T334],...

Hello,

You have to specify the format mask of the to_number function.

See

http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements004.htm

At second thought, name the columns. Select column1,column... FROM OPENQUERY (... SELECT ... column1,....) in case the columnorder would...