you can keep your historical /old data on other disk by setting some archival job(hourly basis or may be trigger) and later use these two different tables to fetch current...

Read this http://msdn.microsoft.com/en-us/library/ms176064%28v=sql.90%29.aspx

your query's subtraction basically generating 1899-12-31 23:59:59.997 date and DATEPART function picking up the second's value which is 59

dixon_dwayne (4/30/2012)Also, I've read that the DB on the DR box can't be used at all even to read... it just sits there doing nothing but restores as transaction logs...

@ OP,

If possible try to divide the database into multiple. it will help you in future as sudden/urgent restore might put you in danger :-).

1. copy the backup to local/shred drive(accessible) to dev environment and do the restore.

2. use ssis package to migrate the data and save it too for later use.

MSQLDBA (5/5/2012)

---

Hi Friends,

One of my database configured on mirroring, and i want to restrict users on it. Because to put database on single user mode is not possible if...

It means that there should not be any connection (some process is using) with those files but why this case doesnt get applied on INDEX...

GilaMonster (4/28/2012)

---

File defrags isn't something often done, especially if the files are on a SAN. Also note that you almost certainly need to have the SQL service stopped to do...

Gail

i didn't get your point here,why IDX3 couldn't...

@aaron,

i have couple of questions ?

1) how much time does single run take(single execution) ?

2) Whats the frequency of single run ?

3) how much data single run handling?

4) how...

From performance perspective, you can use the concept of remote distributor and create the DB which multiple files plus use separate disk.this will improve the performance as it seems that...

set this...

have you setup the distribution fresh here or its a part of image ? if its part of image can you try to create it fresh

USE distribution

GO

EXEC sp_browsereplcmds

@xact_seqno_start = '0x00001C3D00000B9A002800000000',

@xact_seqno_end = '0x00001C3D00000B9A002800000000'

GO above query will give you exact query which his creating PK violation here "xact_seqno" can be obtained from...