another alternative would be use of profiler with event like sp:stmtstart and sp_stmtcompted this will give you cpu, IO , memory usage

personal contact or...

see this link you will get enough material...

are you using 32 bit server ?

you can use LEFT JOIN also like

declare @t table (id int , addr nvarchar(20))

declare @t1 table (id int , addr nvarchar(20))

insert into @t

select 1, 'sdAD' UNION

select 2,...

better use "usp_long_running_jobs" SP in job as step.

a lots of facitor,

1) are you taking backup on local drive or on network ?

2) how fast is the disk and is this is dedicated or not ?...

SQL MOD (1/31/2013)

---

Yes

So it means your source table contains duplicate data ? do you have same...

still you are not clear here , are you populating tables on destination ...

then how come PK violation ? restore backup do data copy of exact the content in backup , there cant be PK violation

New to me 🙂

maida_rh (1/31/2013)

---

what do i need to do as i need the restore to commit the change to a single table structure + data .

I tryed the import but got error:

Violation...

Using ROW_NUMBER() with PARTITION .See http://msdn.microsoft.com/en-us/library/ms186734.aspx

maida_rh (1/30/2013)

---

I need to restrict user which was achieved by grant and deny permissions using TSQL in sql server 2008 R2 successfully.

Now i need to update database,For know ,I am...