You could force a page lock by using the paglock hint. I'm not sure on the implications on doing this but Kalen Delaney wrote a good article in SQL...

UDBNT (3/28/2008)

---

I am trying to create an MI copy of a live database as a daily backup from Server A to Server B. Scripting this via a maintenance plan...

At first glance I can't think of a way of doing this without a cursor. But essentially you'd want to cursor through each row and then split the agencies...

I just realised that my previous post didn't necessarily give you a solution.

You could try and filter the number of rows you're returning even further. This will...

This isn't so much how the optimizer works but how locking works.

It all depends on how many rows your query returns. If it returns too many rows then SQL...

Don't think so. I just created a test function and created a comment that was 11,000 lines long and it made no difference to the execution times. I...

Unfortunately there aren't any T-SQL commands for this.

You'd have to track data modifications yourself by implementing your own solution. For example, you could add a Last_Modified column and ensure...

Kiran,

Try dbcc show_statistics.

dbcc show_statistics('kiranaddress.table_a', )

--you can supply statistics name or column name (assuming there are stats on the column you specify) in place of index_name.

Pam Pinnacle (3/26/2008)

---

This seems to me to be a really simple thing but I am stumped.

I am going to create login names by removing the @companyname.com from...

Jeff Moden (3/26/2008)

---

How do you know that, Matt? ...

Hey George,

Looks like this is related to the problem you posted...

Ankit Mathur (3/26/2008)

---

Hi,

Can you please tell me how did you got IO stats for just one query.

I'm new to SQL and am trying to learn some techniques for Performance Tuning....

I think you might need to add the user to some of the roles in the msdb database - in addition to the TargetServerRole. I can't quite remember now...

As far as I'm aware the only thing that could be affected are the statistics, so when you're detaching make sure that the @skipchecks parameter is set to false (or...

vijay (3/25/2008)

---

I did that but. once running the Job its blew up with following error:

Non-SysAdmins have been denied permission to run DTS Execution job steps without a proxy account. ...