Best tool I know of for working with models is Embarcadero ERStudio.

But if you do a search, there are free ones out there, but you're going to get what you...

Richard M. (5/17/2010)

---

James Stover (5/13/2010)

---

I stopped being helpful online about 5 years ago. I'm not interested in helping some stranger in the far reaches of <insert developing nation here> to...

To know if servers are down, you need to enlist yet another server as the monitoring point, pinging the original servers to see if they're alive.

The thing is @@ERROR really doesn't catch errors, it reports them. TRY/CATCH can literally catch, say, a deadlock, and let you retry the query. That difference alone is a great...

Since you're doing updates, you do have to worry about two searches there, the search within the table for the correct records to update and the select statement & join...

There must be differences, index fragmentation, statistics age, contention for resources, available memory, connection settings, lots of these things can cause differences in performance.

Basically if the error will cause a disconnect, SQL Server can't catch or handle the error, so the calling code will have to.

I'm still not getting a total picture with details, but based on what else you've said, I'm going to stand by the original post. A table that stores relationships, user...

GilaMonster (5/14/2010)

---

Apparently he's actually a very nice guy and...

That depends on what was set...

I still don't understand what you're asking for? A query has no selectivity. There is not a measured set of uniquely identifying data about a query. The data stored in...

The Dixie Flatline (5/14/2010)

---

Well said, and too true, Grant. The discussion has been interesting too.

Forums really shouldn't be a resource of last resort, especially in an emergency. ...

TheSQLGuru (5/13/2010)

---

>> I can't count the number of times someone has fired back a "Boy you sure are dumb if you haven't done "X,Y,Z" already" without even reading far enough...

Ben Holcombe-270296 (5/13/2010)

---

I completely agree that demanding requests are arrogant and insulting. I hope that I never have the opportunity to work under those individuals posting these requests. ...

sburcombe (5/13/2010)

---

While I agree with everything you've said, I wonder if perhaps you're forgetting how it is to be one of the little guys.

I'm in the fortunate position where...