Does it help if you exclude that particular table from the replication and add it back later after checking for errors (DBCC CHECKTABLE)

We have architecture like

Oracle 10g Application

||

INTERNAL SYSTEM

...

The switches are only really helpfull with +4GB of ram

With defaults, 2GB is reserved for applications (like sql server) and 2GB for the OS.

With the /3GB boot.ini switch it allows...

I would reduce the batchsize.

Any particular table where the snapshot halts?

We have a 39-hour working scheme, similiar to the one of P Jones with "gliding" hours. Start between 8 and 9 am, stop between 4 and 5.30 pm.

With flexibility for...

We haven't got issues with databases of 100 gb, although we are thinking about data management to migrate readonly historical data. One of the side effects will be keeping the...

What security context is set for the linked server?

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?