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......

The good thing about synonyms if that they can be rebuilt quite easily with a script. Maybe I'd check out that route.

Yup it's the print command... unless you hit a real weird "bug" bu using order by newid() in the concatenation. Otherwise it's the print issue.

Just concatenate the code in varchar(max) var and exec that... fully automated.