Lowell (8/17/2010)

---

sgambale (8/17/2010)

---

Thanks for the replies. It makes sense that 1, 2, or 3 blanks is treated the same (with the entire column filled with blanks), but the empty...

removed

select that path and...

IS sys.dm_db_index_usage_stats not a DMV ?

actually , there is one column "last_user_update" which hwe are using to capture all the tables got any kind of insertion/updation/deletion on it.then we...

it should work faster if it doesnt contain any heavy columns ( BLOB type). use can take "BATCH approach"

or looping.

refer this http://www.sqlservercentral.com/articles/Top/63301/

i think sql doesn't care about the blanks ( 2 or 3 or 4 space) for both char or varchar.

I didnt get this statement is the post code so post complete code .

Additionally check the Sp name...

Arjun Sivadasan (8/16/2010)

---

Hey, thanks guys. I will run the particular query in question in both ways - insert into and select into; and go with whichever works in less time....

i would say before moving to conclusion that database is optimized at its best level. we should try few things.like

database settings.

network traffic on both servers.

data volume (same in your...

balasach82 (8/16/2010)

---

Got this error when a job (which was running successfully earlier) runs and fails:

The instance of the SQL Server Database Engine cannot obtain a LOCK resource at this time....

i tested it on my local machine and found the backup file on the path...

Paul two question for you 🙂

first, why optimizer will get confused by rownumber ( it return bigint value) for int type output ?

Second, SELECT ...INTO approach is minimal logged...

Arjun Sivadasan (8/16/2010)

---

I have another question for you Paul. Say, I have an SP which uses a temporary table. The number of rows in the temporary table depends on the...

in perfmon ??? any link/article where...

Adiga (8/13/2010)

---

This will not create the backup file at default location. It depends on what is the value...