Increase the maximum number of errors allowed in the properties of the datapump

There are two parts to the problem.

If you look at the query plan on SQL Server you will be surprised that sometimes (when it is possible) your where expressions are...

..... I know, I know, It will always depends on how the process is but I just posted for the fun of it

I...

Here is a wild try:

insert into users

          (

          InsertDate

          ,ADT.Username

          ,ADT.initials

          ,ADT.facsimileTelephoneNumber

          ,ADT.streetAddress

          ,ADT.manager

          ,ADT.whenCreated

          ,ADT.uSNChanged

          ,ADT.DN

          ,ADT.objectClass

          ,ADT.[name]

          ,ADT.objectGUID

          ,ADT.[description]

          ,ADT.displayName

          ,ADT.userAccountControl

          ,ADT.sAMAccountName

          ,ADT.sn

          ,ADT.givenName

          ,ADT.memberOf

          ,ADT.homeMTA

          ,ADT.proxyAddresses

          ,ADT.homeMDB

         ...

Your function and <> is converting the expression in not "SARG"able the not Like 'cy%' can be converted into like '[^cy]%' which is SARGable therefore your speed!

>>Do you guys consider it wrong to write code like:

Declare @value1 as int

Select @Value1 = @Column1 From Table1

IF @Value1 is > 0

begin

     Exec stored_Procedure1 @Value1=@Value1

end

ELSE

begin

     Exec stored_Procedure2

end

. <<

Oh...

Well,

It has been my experience that restore is slower than attach.

I do agree though that the backup/restore (as a whole)  may be faster depending on file size  (specially whe using...

The name of the problem is : OUT OF SCOPE 

Believe me I've had that feeling too

 >> Correct me if I'm wrong...

If you delete a record using the query tool in Enterprise Manager (NOT Query Analyzer) I believe its not logged.  Thats why its so dangerous to mess...

try:

SELECT Invoice.pk as InvoiceId, LastCharges.chrgtype, LastCharges.chrgamt, LastResponses.respamt, LastResponses.resptype

FROM Invoice

       LEFT JOIN  (select fk_Invoice, chrgtype, chrgamt

           from InvoiceCharge ic1

                  where chrgdate = (select Max(chrgdate)

       from  InvoiceCharge ic2 

       where ic2.fk_invoice...

Believe me I know the feeling

And what the heck kind of attribute is a "tblpupil" -- are you reaching furniture instead of kids?

Joe,

With all the respect you deserve I think you are crossing...

Did you checked REGIONAL SETTINGS on the OS and @@language on SQL Server

I don't really understand the purpose of that many conversions but you may want to try this:

DATENAME (weekday, DATEADD...

use start/continue from sql server service manager