i was looking more in general. Thanks

Thanks. Doesn't help much. I need to know number of pages,object name also. What do you think about my query?

Second one

Thanks. My goal was to reduce the sub-set by using where clause first and then joining the tables. Any better way to tune this?

Ninja's_RGR'us (5/13/2011)

---

sqldba_icon (5/13/2011)

---

While i am looking at the index structure, i was wondering is it possible to avoid nc-index scan when it is doing and update? Also does clustered index...

Thanks everyone.I am little lost now. First i was able to run the proc from management studio and not through job. I was NOT able to run when i set...

?

rmechaber (5/6/2011)

---

Have you worked with SSIS before? You can execute as many tasks in parallel as you like in SSIS, which is one of the very nice things about...

Nils Gustav Stråbø (5/5/2011)

---

Steps in a job is executed in a serialized manner. So no, a single job cannot execute multiple steps in parallel.

Could you perhaps create an SSIS package?...

thanks everyone.

i want to restore point in time? how can i do that? can i just take a fresh full back and then log backup and then point in time?

Joshua M Perry (4/19/2011)

---

I think I understand what you're asking for now. That's not exposed via TSQL, but you could use some .NET code and expose it through an...

GSquared (4/19/2011)

---

Check this for details: http://technet.microsoft.com/en-us/library/ms175519.aspx

Essentially, an IS lock is "Intent Shared", which allows other shared locks (selects, essentially) to access the same data.

Shared (S) locks allow concurrent transactions to...

chandan_jha18 (4/19/2011)

---

sqldba_icon (4/18/2011)

---

Thanks. None of your queries gave me list of currently running packages (:. In the second query, you do not have any column referring to SSIS package? I...

Thanks. None of your queries gave me list of currently running packages (:. In the second query, you do not have any column referring to SSIS package? I do see...