ALZDBA (5/15/2008)

---

I'm running sql2005 sp2 cu6 (client) and I also have the impression the first start takes longer than before.

btw:

did you disable the InternetExplorer settings / advanced / Security "Check...

Well, looks like I will be going. Hope to see some of you there!

Oops, apparently, I was a little late to this party (even Matt got here before me!), but I believe that it is now apparent what I was saying above: this...

Yes, but it might add "Limitations" of its own. In particular (and what this...

In most respects, a stored procedure is no different from a user/client executing all of the same statements in one batch.

OK, what was the Error?

You cannot remove a Directory in use, no matter what your privileges are. I wold suggest trying to find the directory that it is trying to remove and see...

Thanks, Steve!

achaudhr (5/12/2008)

---

Hi,

Thanks for helping. I tried to create that index but as the titles are lengthy & max is 1109 & it says max length allowed is 900 bytes.......I...

This seems like a compile error, which should mean that the [font="courier"]Print 'Begin'[/font] never executes either. Are you doing this in Dynamic SQL?

Add an index to tb_Titles on TiQueryValue that includes(covers) BibNumber and TiOrderByValue. That should make it run in about 5-6 seconds.

Sorry Topher, I cannot figure what you are actually asking for here.

IS your script broken and you want help with it? If so, please tell us what...

Sure:

1) use SAN mirrors; (split the mirror, copy to dev, rejoin mirror)

2) use DB mirrors (similar)

3) use Prod's daily backups to restore to Dev

3) Log shipping

This is an extremely complex and detailed area and I doubt that any forum can supply the kind of extensive customized support that you need and should be receiving if...

It depends on how they get loaded after they are TRUNCATEd. If they are loaded in one statement, you probably wouldn't need to rebuild them, but if they are...