unfortunately using defaults on table is not an option here. company policy.

all numeric characters prior to the first blank character

Actually in my case I need to select street number from a address string, which means if the string is '1234 dummy789 road', I only want to get '1234', not...

If there any other techniques to minimize the table lock?

do you think I should add updlock too? WITH(UPDLOCK, ROWLOCK)

So adding WITH (ROWLOCK) to INSERT and UPDATE will tell SQL Server not to lock the whole table?

I read http://support.microsoft.com/kb/323630 and it said SQL...

I will post the query in a short time. One thing I need to mention is if we reboot the db server, the same query runs about 0.01 seconds, but...

How to speed up the query, does that mean I don't have enough memory?

Friends,

I have modified the script as follows, it works fine, the only problem is the result returns in batch like this:

rep1 rep2

1      100.0

2      200.0

...

rep1 rep2

1001 100.0

1002 100.0

...

But I want the result to...

"And why do you want all of the rows?" It is a business requirement, this resultset will be feeded to some other program.

tab1 has about 1 milllion rows, tab2 has about 5 million rows. The idea is not locking these two tables one time for 5 minutes, instead, hopefully, multiple times, but...

Mark,

Thanks for your reply. I think the sp_add_alert statement itself it fine because I just used sp_user_counters1 to set the user settable counter 1 to a number 103 and then I change...

Another thing I want to mention is if I highlight that line, I saw the following two words:

Table lock

Can anyone answer this question? Sorry but it is very urgent, because of license problem, I can't install the tool itself on a PC. I am waiting online. Thanks a...

OK, here are what I found out.

1. Even I choose the remote server as the "default server" in the Tools -> Options, it still doesn't work.

2. I tried to pick...

Correct me if you think I did something wrong here:

1. In the menu, go File -> New -> Trace...

2. The "Trace Properties" windows appears, clicke "General" tag page.

3. In the...