It depends on the fragmentation percentage , What says isheej :-)?

homebrew01 (9/9/2010)

---

The error sounds as though the job does not have permission on the folder. Perhaps folder permissions have changed, or the job is running under a different account than...

Has the volume of data been increased ? means heavy data will take longer time.

above of all , have you made any kind of changes like, script change, privilege changes...

i am not good while dealing with replication but i guess below script might help you.but read it carefully

use database_name

go

create table shrinkfile(

col1 int,

col2 char(2048)

)

dump tran database_name with no_log

dbcc shrinkfile(logical_name_of_log,...

it might be anything above initial size + auto growth size(percentage). please...

premkuttan.lakshmanan (9/5/2010)

---

I have 30 tables in a Db whereas in 1 table i dont have any rows or (0 rows)

but still it takes 10 to 20 seconds to give 0...

Did you restart the sql agent ? and did you try to execute plan plan...

What are your backup plan strategies ( in case of log files) ?

GilaMonster (9/7/2010)

---

Just note that it is not a requirement that a CTE start with a ;. It's a requirement that the statement before be terminated with a ;. Since this...

...

any specific reason to use ROWLOCK ? ...i think sql server itself decides to use locking mechanism.. i am just curious:-)

GilaMonster (9/7/2010)

---

Bhuvnesh (9/6/2010)

---

How would you get data from deleted table in case of INSERT trigger. there...

Chan Wai Yin (9/7/2010)

---

Yes, all kinds of transactional locks like read lock,...

'select' + @oc +'from inserted' will not work...

Are you using the correct profile/account name ? i...