Luis Cazares (9/27/2012)

---

I would like to know more about those methods. Could you tell me where to find information? I couldn't find much.

This is what I came with. It's doing...

Mark F-428640 (9/27/2012)

---

I am trying to get an idea of how much records I will be processing from a transactional table during a rollup process.

I have been running about...

sanjay684 (9/27/2012)

---

First off all candidate id in the first table had primay key and after all the table have foregion key..When i have try to delete any row of tblcandidate...

There's a few...

Sanjay,

If you're looking for a solution to remove duplication from a set of those tables, provide the schema, some sample data, and your rules for removing duplicated data for those...

As Luis mentioned above, Hierarchial Tables (think Org Charts) are the typical reason...

Couple of questions:

Is this oversimplified or is it a homework question? If homework, what's the chapter's subject so we can help you find the right place with this?

If...

vandana_j79 (9/26/2012)

---

I have setup job which run ssis package. In this job i pick data from oracle server with link server. When i run job manually it complete in 20...

+1 to what Matt provided. INSERT INTO opens an implicit transaction, and then anything ran under that ends up in the transaction. What's the default isolation level on...

Is that the only error in the log? There should be a bunch more information alongside it and additional errors neighboring it... otherwise I'd call microsoft because you don't...

Backwards compatibility.

Yep.

Is there an easy way to figure out which...

rburko (9/26/2012)

---

I'm taking the recordset, saving it to a variable, and using it in a subsequent loop.

I'm sure I can cajigger the subsequent step to read from a temp table...

antonio.estima 4150 (9/26/2012)

---

In SQL Server 2K or 2K5 the WHERE clause where SUBSTRING(nomeint,1,1) = 'P' is run first in the subquery and then it does the join. However, in SQL...

Do not trust sysdepends, it lies like a rug.

There is no easy method to be sure of how often a table is used, particularly for select statements. You'd start...