Hi John,

You're probably right but

mpe.din is CHAR(3) and mpe.pkgsize is INT

so the join would look ugly again.

Something like

mpe.din + CONVERT(varchar(10),mpe.pkgsize)

I don't like aligning JOIN sides...

Thank you guys.

Both DELETE statements work.

But the one Rajat wrote is easier to understand for me.

Thank you Rajat.

I knew it was possible to do DELETE using JOIN

I just couldn't figure...

WFAGG,

Thank you! This helped.

In second instance of management Studio QA works fine.

Redesign it using SSIS is not an option.

I don't need any DTS or SSIS.

I am redesigning it as a stored procedure.

Transformations are done on the same server.

No need in DTS/SSIS....

Yes. As soon as I close DTS Designer

Management Studio functions fine again.

Any suggestions how to fix it?

Rob

..... one last thing....

To determine which one you have installed, click on the properties for your SQL Server instance, and look on the

GENERAL Page

>>>> Product : Microsoft SQL Server (Standard/Enterprise/Developer)...

Hi,

If you do RESTORE LOG @DBname

is it cumulative? I mean if I have

Log_USFPIMS_20080422090002.TRN

Log_USFPIMS_20080422110002.TRN

Log_USFPIMS_20080422130002.TRN

Can I just apply the latest Log_USFPIMS_20080422130002.TRN

and all the data since last Diff was applied would be...

Does it work for everybodey?

When I run it form QA it keeps creating an empty file.

exec master..xp_cmdshell 'echo "XXX-XXX" >> c:\code\QueryResults.txt'

Thanks,

Rob

Hi Michael,

It's a DEV box. Only a couple of people will use it including me.

I don't need to copy all the users.

Michael,

So you're saying I don't need

REPLACE when run...

Hi Aaron,

It's definitely a fun script. I love this kind of things.

But I got an error:

Query returned no results

I guess I need to test the query first in Query Analyzer.

By...

Hi Mario,

So Parent contains the whole text of Stor proc?

Even if it's 3000 lines?

Thanks,

Robert

Mario,

Thank you very much for your queries.

They seem to be a much faster way to quickly identify

the most "troubled SQL code" in the system.

Question.

What are the Individual Query and Parent...

sysaltfiles.filesize

Is it in KB or MB ?

Gail,

Are you talking about these books?

http://www.insidesqlserver.com/thebooks.html

Inside Microsoft® SQL Server(TM) 2005: Query Tuning and Optimization (Paperback)

by Kalen Delaney (Author), Sunil Agarwal (Author), Craig Freedman (Author), Ron Talmage (Author), Adam...

Hi Gail,

So it means basically that 1643 RowNumber is useless.

I just need to look at 1644 RowNumber? It's the same SQL, User, SPID.

This will show me Duration / StarTime /...