yessen (6/24/2010)

---

GilaMonster (6/23/2010)

---

You're confusing concepts. Log chain has to do with whether you can do point in time restores (restore a database to any time) using RESTORE DATABASE and RESTORE...

balasach82 (6/24/2010)

---

Dave,

right now, a bit confused. "The trace file wont tell you how many transactions there have been , for that you need to summarise the perfmon data"... any idea...

Yeah, the planet should send that second down to SA.

Yep, it really is down to the OS.

In general file fragmentation shouldn't be that big a deal. Have you eliminated all other issues on the server that could cause performance...

Whoa! No, don't do that. You'll be shooting yourself in the face (yes, face, not foot). I put out a small blog post[/url] on this, just today, that addresses this...

Ninja's_RGR'us (6/22/2010)

---

2 or 3?

They're not even sure they need the technologies,...

In general, especially for the size of systems you're talking about, I'd seperate these installs to seperate machines.

GilaMonster (6/22/2010)

---

What happens if the user goes for lunch leaving the screen open, then decides to...

Inserts or deletes are occurring on the system at the same time that you're trying to read it, but the information that was being scanned has been moved. One of...

A little help over here would be appreciated

Just as a starting point, what happens if, within the transaction you're holding open, you need to read...

mshah23 (6/22/2010)

---

Basically On UI screen, if user select any case(Radio Button) for modication and start any modification that particualt case needs to be locked for other user.

That's why I want...

By and large in SQL Server you don't want to try to control locking. In general it does row level locking by default, all on it's own.

Why are you...

Greg Edwards-268690 (6/22/2010)

---

Paul White NZ (6/22/2010)

---

I guess it's because...

Assuming that you're using SQL Server 2005 or above since you're posting in the 2005 forum, why not use TRY/CATCH syntax for the error handling? This eliminates messy GO TO...