Aadhar Joshi (12/5/2012)

---

If i go with job, i need to give time that executes job, the minimal time i consider is 30 seconds so after every 30 seconds it will...

trigger ? you want to work on row level ? i dont think its a good idea...

can you please explian this ?

sqlnes (12/4/2012)

---

Hi,

I tried to modify the size of autogrowth for one of the data files in my database. However, it took a long time and could not be done. After...

can you explain it ?

And for reading http://www.mssqltips.com/sqlservertip/1667/sql-server-join-example/

it this case too , you need to trigger job, job itself doesnt put any...

Bhuvnesh (12/4/2012)

---

this cant be the case as OP posted above that he is abble to connect with other databases.

This might be...

I am completely aware of the approach you people take during the release night. see there is no any specifc procdure to deply these kind if scripts. totally based on...

this cant be the case as OP posted above that he is abble to connect with other databases.

This might be bacause...

you need to make JOIN with second table with first one.

NO use of here as both the tables are going for table scan plus parallelism too for puling out...

are you sure for this no ? and task manager can give you estimated value for sqlserver.exe

Jayanth_Kurup (12/3/2012)

---

I am not sure if I understood the context of the question so let me rephrase . The TL wanted you to compare the application business flow and then...

MyDoggieJessie (11/29/2012)

---

If you create a custom alert for SQL Error # 1101 or 1105 (not sure exactly which is which, you can Google that) it will send you an alert...

1. take create temp table approach instead of select into approach coz it also lock the main base table and i dnt think here you require to...