What about an incrementing id column?

why do u need such a thing ?

Left joins will work inside a procedure the same as they will work outside a proc. Your problem will be the query as a whole. check the query.

Pls give more details specially regarding your hardware , volume of data and about the process happening.

WHERE REG_DATE BETWEEN ISNULL(@REG_START_DATE,REG_DATE)

AND ISNULL(@REG_END_DATE,REG_DATE)

check out this forum topic

http://www.sqlservercentral.com/Forums/Topic571247-338-1.aspx

I do not know about the HEAT program but a backup/restore or a move will keep the stored procs and triggers. You will not have to re-create them.

How ever its...

The reason "shravan" is being returned is becoz he has visited the site during the past 3 days. You are taking distinct of 5 columns - U.UserName,C.ClientId,Ua.UId as UserId,convert(varchar,ReportDate,101)...

Did u check the condition of your indexes. Are they fragmented?

BitBucket - Pls be carefull next time. We are here to discuss/debate SQL server and not language issues.

Jeff Moden (9/23/2008)

---

Not sure what you mean... what did you do to get it to show ProcA has a ProcC dependency? I can only see ProcB. Maybe I'm...

Hi

It all depends on the size of your database and the amount of data that gets inserted/deleted/modified. If size of db is huge and the data modifications is also huge...

Are'nt CTE's available in SQL 2008 ?

Nice article Gail.

The pages from the source database get written to the snapshot's sparse file the first time the page gets modified in the source database. Is that right?

If...

Jeff Moden (9/19/2008)

---

Chirag (9/18/2008)

---

another way is to right click on the proc in SSMS and select view dependencies. It will show all objects that depend on the proc and...