I usually say Sequel, fewer syllables, thus more effiient and we all know performance is important:P

If you are using a sub query you want to use IN like this:

Update TableA

Set ColumnA = 'Test'

Where

ColumnB In (Select...

Glad to help.

I have SP2 installed and did not have any issue creating a job in SSMS. Have you tried creating a job using the job creation SP's directly?

Are you having...

That has been my typical approach as well Grant. I am looking for the hard core performance guru's approach as well.

This question assumes that the update is being done...

Make sure you lookup SQL Injection before releasing any web page that allows this.

Do you want to provide "drag and drop" type functionality to select tables and fields or just...

YOu executing the insert on the remote server not the local server so there is not an identity value being created in the scope of the local server. If...

You need to create Linked Servers between the Servers. Then you they can reference each other.

For instance on ServerA you create a Linked Server to ServerB. On ServerA...

I don't know of any off the shelf components that would do this as I have never given users that kind of permission.

The first thing I would do...

Anthony K. Valley (4/4/2008)

---

Hmmm.... I assumed the question was specifically about pages, extents, and allocations in SQL Server. I had no idea that it was about general computer storage....

I have to agree with Gail. If there are indexes that will help regularly run queries it is a "best" practice to add them.

I'm not sure if this is designed behavior, but this section:

IF @LOCKSTATUS=0

BEGIN

SELECT

@LOCKSTATUS=COUNT(*)

FROM

LOCK (NOLOCK)

WHERE

TABLENAME=@TABLENAME AND

ROWID=@ROWID

IF @LOCKSTATUS=0

BEGIN

INSERT INTO LOCK

(

TABLENAME,

ROWID,

USERID

)

VALUES

(

@TABLENAME,

@ROWID,...

Any value you want to be aware of is going to vary based on your baseline and setup. As I said, this...

Lynn,

I actually had never placed an alert on performance condition, but I knew "how" to do it. I just created one on my local SQL Server on:

SQLServer:Locks - Lock...

J.D. Gonzalez (4/3/2008)

---

I'll take a look at the link provided. But what still has me stumped is when I ran a trace, the SP call is identical when compared...