You need to break it down into batches, and run t-log backups between inserts. Is there a common primary key or unique between the two tables?

Does anyone else get the feeling that some people think we are here to not only help and mentor others but to actually do their work for them with no...

Gift Peddie (7/19/2009)

---

That is very nice point get random...

Gift Peddie (7/19/2009)

---

Considering that obtaining Vendor Certifications is voluntary, I really don't think there are legal grounds for any governmental organization to make such requests. If these certifications were required...

Gift Peddie (7/18/2009)

---

... Microsoft, Cisco and now Oracle if it buys Sun knows one day Uncle Sam and EU may want some docs showing why there are so few...

You mention Novell's CNE in your editorial, and twenty years ago I had considered trying to earn that certification as the company I worked for at the time had a...

Curious, but would this work as well?

select

FiscalMonthDTTM,

left(datename(month,FiscalMonthDTTM),3) Mth,

Sum(case when TimeType='YVW Crib'

...

Here is a way to accomplish your task. First, you need the following function (or one similar):

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE function [dbo].[DelimitedSplit] (

@pString varchar(max),

...

Assuming that you are updating existing records, why not put a ModifiedDate column on the table and update that column when you update the row? Then you just have...

So, how about DDL for the table(s), sample data, expected results based on the sample data, and most importantly what you have done so far to solve your problem.

Need help...

First, I'd recommend...

jcrawf02 (7/17/2009)

---

Lynn Pettis (7/17/2009)[hr

So, what's stopping you from getting back out there? I'm sure that you could be used and abused just like the rest of us. It...

First, remember that no all errors can be trapped in in a TRY/CATCH setup.

Code your trigger to use TRY/CATCH. For the errors that can be caught, capture the error...

Just realize that it may not take all 14 GB of RAM. Not saying I wouldn't set the maximum memory available to SQL Server, I would; but the best...

jcrawf02 (7/17/2009)

---

Lynn Pettis (7/17/2009)

---

I try to work 3 or 4 tournaments a year. Depending on the tournament, that can be anywhere from 2 days to 7 days long. ...