How many GBs of data arer you exporting to disk?

Are you reading and writing on the same HD?

The most reads I ever got is around 1B and it crashed the server. So unless you're talking about a TB db+ then yes you may have a...

Well 12 months experience as dev is far from nothing... and recruiters will know that. You don't have anything to worry about.

Free is free. The interview is free too BTW.

It's also a good way to actually meet people and see what it's like to work there. If...

Or... (instead of divide)

Declare @t table (v integer not null primary key, check(v >= 0));

Insert @t values (0)

Insert @t values (1)

Insert @t values (2)

Insert @t values (3)

Insert @t values (4)

Insert...

sqldba_icon (4/7/2011)

---

Thanks everyone for the inputs. Still some of my questions are unanswered.

ii) Using "Option Recompile" for proc is NOT AN OPTION because it takes more than 20 secs to...

You can't have GO statements within the procedure...

And actually I don't see why you would need them in that case.

create PROCEDURE [dbo].[CalChestSum]

with recompile

AS

SET NOCOUNT ON

begin

declare @DateTo datetime

...

Read Gail's article first.

I was asking about most recent backup because as the ABSOLUTE last resort, there's a way to dump the log. BUT you must be able to...

SELECT

*

FROM

(

SELECT

ROW_NUMBER() OVER ( PARTITION BY lastwaittype ORDER BY...

What are your options?

Best way is to take a tlog backup but I'm guessing you tried that already and failed.

Do you have a full backup somewhere? Or are you...

SELECT

*

FROM

(

SELECT

ROW_NUMBER() OVER ( PARTITION BY lastwaittype ORDER BY...

Temp tables are used to divided and conquer. That means you have a huge a$$ query or huge a. table and you have slow performance. Then building the...

I can't help you with SSIS because I've never used it... and never had to.

You can all you need from SS side in a job in a single script. ...

What's the problem? You already told us exactly and clearly what needs to be done.

Generate the drop commands and run them

Truncate all tables

Reimport (already working as I understand)

Reload constraints......