If you perform the update within a transaction, other users should not be able to access.

Are you doing this to create an identification generation engine? Or, to put it another...

I agree with what everyone else has said. I think they've caught the obvious stuff. Now, to keep going, can you post the execution plan from the query, preferably after...

I'm not seeing anything radically different either.

The only exception is, I'd move the BEGIN TRAN inside the BEGIN TRY statement so that if there are errors on the initiation of...

OK. I've narrowed it down a bit. It's not a limit on number, it's specific feeds from SSC. The 2008 backup forum doesn't work, but the General & TSQL ones...

Thank you. I hope the book has been useful.

There's also Red Gate SQL Virtual Restore, that would allow you to "restore" the database to a different location and pull the data off. The nice thing about this is,...

You have a lot of options. We do this at work just using the nightly backup to perform a restore. It does two things. It gets us that test environment...

I would be extremely cautious about taking the missing index reports at face value. They are frequently more than a little bit inaccurate and can lead to too many indexes...

pascalbjr (1/7/2011)

---

Well, good point there. We need row locks for several critical tables updated by our application server, to serialize access to them, and avoid deadlocks due to some denormalized...

Another vote for Red Gate tools. They're pretty amazing. They primarily will help in development and maintenance. In terms of performance, they have a new tool, SQL Monitor that will...

Craig Farrell (1/7/2011)

---

Donalith (1/7/2011)

---

I was told that both types of restore require the same space requirements. Is this true? If I have a 400 gig database do I need another...

Do you think Documentum or SharePoint are the best document management tools? Hard to say right? But they each one use a different schema, so saying, "This schema is best...

If I recall the chapters in Kalen's book correctly, there is a strong bias to row locking, but, no you can't really guarantee the locking type, and to a degree,...

johnl 80306 (1/7/2011)

---

Well we do delete the previous night's file just before the new dump file is created. The issue is that we are going to start utilizing an off...

Yeah, it could be an implicit conversion on the date causing the issue. Either way, because the strings are different and the values are different, you can't guarantee that you'll...