No issues that I can see.

Andy

http://www.sqlservercentral.com/columnists/awarren/

I typically add 'set nocount on' at the very top, saves sending back info generally not used on the client. Agree with others about not using dynamic sql. If you...

We're moving to mostly HTML, most reports we do arent that complex. We've used Crystal some but dealing with the ocx or java install have been an annoyance when getting...

Log shipping isnt a good fit unless you're going to really keep the latency high, only do the restore a couple times per day or at some defined period where...

One second is incredibly long for a trigger. I'd dig into why the associated activities take so long, could be you need better indexing somewhere. Short term if you need...

Thats a lot of growth! Might try stopping service and deleting tempdb (rename the mdf is safer), let SQL create a new one from model. If it grows that much...

Maybe this will help. Your problem is really two parts, one is running the query, the other is exporting the results. For the first part you could run the query...

Whats it say in the event log?

Andy

http://www.sqlservercentral.com/columnists/awarren/

Sure you checked the correct object? I'd try DBCC CheckDB as well. Any recent hardware issues? I'd make sure you have a good backup (dont let your maint plan delete...

Maybe of you guys can either find or repost the script and post the link back here? Others will be interested Im sure.

Greg, have you looked to see what performance...

Gotcha. Running sp_change_users_login does try to update sysusers which would fail if the db was read only. No reason you can't reverse the process yourself, update sysxlogins so that the...

Shouldnt take much longer. Might want to talk to your network admin, see where the nearest domain controller is and work to reduce the delay. I doubt the issue is...

I guess you could script it out and stuff back into a blob. Why is there too much overhead with VSS? Bill Wunder has a free utility posted here on...

You can use replace and a little concatenation to convert to an XML document, then use OpenXML to treat it like a table.

Andy

http://www.sqlservercentral.com/columnists/awarren/

I think log shipping does make sense for you. Its simple and effective, and given the allowable latency, a great fit. From what I've seen clustering (and replication to a...