How big is the data file (and any indexes)?

If the log file has insufficient free space to handle the logging data from a batch of deletes, then yes the file will grow. Are you manually changing the size...

afuchs 47083 (4/4/2013)

---

Hi guys,

I tried to create a new userdefined function for calculating the average of top 10 values on different columns of my table:

Example:

SELECT AVG(a02) FROM (SELECT TOP...

Deletes are fully...

Even with batching, simple recovery mode and checkpointing, there will be a minimum log space requirement for each batch. If...

MERGE Vacancy.TB_FTSearchData as t -- target

USING vacancy.TB_Vacancy as s -- source

ON t.FTSearchVacancyInternalID = s.VacancyInternalID

AND t.FTSearchContractID = s.VacancyContractID

WHEN not Matched by source THEN DELETE

WHEN not Matched by target...

28.kanikasoni (4/12/2013)

---

Hi All,

I want to use 2 DMLS in When not Matched by target clause ie. first insert and then update.But I am getting problem while executing this code .Please...

Pivot or crosstab. Can you provide a few more details? There's a link in my sig providing posting guidelines.

Something like this?

;WITH Resolver AS (

SELECT [Level] = 1, CompanyID, CompanyName, Heirarchy, ParentCompanyID,

Hpath = CAST(CompanyID AS VARCHAR(50)),

ParentCompanyNames = CAST(NULL AS VARCHAR(100))

FROM Company

WHERE ParentCompanyID = 0

UNION ALL

SELECT [Level] = r.[Level]+1,...

Melanie Peterson (4/12/2013)

---

LitHold and LitHoldDetails are connected via the LitHoldID column, and LitHoldDetails and EmailTemplate are connected via the LitHoldDetailsID column. Apart from that and the table structures, what else...

Can you post up three or four of them please?

Rob-350472 (4/12/2013)

---

I'd like to have time to try the above non CTE approach, time doesn't allow at the moment but hopefully at some point.

FYI the #test replica on my 'real'...

Lynn Pettis (4/12/2013)

---

The CTE and NoCTE versions are comparable on a small data set. I'd like to try them both on a million row data set and see how...

The OP is batching.

Shouldn't templateID be a column in LitHoldDetails? I think you've got the relationship the wrong way round.