Sho' 'nuf!  You can play around with this...

CREATE

FUNCTION dbo.udf_stripString

(

@prmString VARCHAR(512) = NULL,

@charList VARCHAR(256) =...

Thanks but the semantics/syntax are more of the issue.  I am almost certain there is a way to do this without an iterative procedural solution (i.e. pure set-based SQL nirvana)... ...

If the files are on different filegroups, only objects specifically created on the new filegroup will reside there.

If the files are on the same filegroup, only new objects will be...

A clustered index is part of the physical table.  It must remove the index rows from the table to 'return' it to a heap (table w/o clustered index).

See books online for a...

Hi Susan,

Look for the OPTION clause in the SELECT statement in Books Online.  You can specify the MAXDOP in the query instead of server-wide.

HTH,

Art

Definitely change the query as described by PW - I would go one step further and specify the fully qualified table name in the UPDATE clause - but that's...

Another 'clarification' may help too...

WHERE status = 'New' AND (email = 'xxx' OR creator = 'yyy')

...of course there are indices on the parent, parentcategory, child, childcat... columns, aren't there?

a composite...

dbArtisan

SQLCompare

SQLDataCompare

SEM

SQL Profiler

PerfMon

ER/Studio

Another possible method to shorten the transaction is to:

INSERT INTO TableB SELECT..FROM TableA

DELETE FROM TableA INNER JOIN TableB ON...

Assuming that indices are available for the SELECT and DELETE..JOIN

Yes indeed!  Thank you for pointing out another BUG in my db tool...

They have some splainin' to do!

Thanx!!

Take a look at the OPTION clause for SELECT in BOL.  If you have a multiprocessor system you can 'suggest' MAXDOP.

If the issue is getting something into the resultset, even...

Maintaining open transaction WAS normal.  It is not the preferred mechanism these days.  Unfortunately, older apps may have no other means to prevent changes to data or detect those changes...

You can Boost SQL Server Priority on Windows on the Processor tab in the Server Properties dialog via SEM.  Changing this setting is not usually necessary and will affect other...

...from my experience you cannot change anything related to the base tables - not even columns not referenced in the view.

I misunderstood...  I thought you had successfully restored the system db's and were trying to get the user db's restored.

I noticed that you posted in the http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=24&messageid=202168 thread.  That info...