I agree. If you're just moving the box, there's little you need to sweat on the server. But, you will need to validate that the clients aren't using IP &...

Oh, true, didn't think about...

There isn't one hard & fast number for most of these values. Almost all of them are dependent on your particular hardware and it's configuration. But, most performance monitoring or...

One thing you can use to look at "hung" processes is to go after the dynamic management view sys.dm_exec_requests. This will show you the active processes in the server including...

WayneS (1/25/2010)

---

GSquared (1/25/2010)

---

Grant Fritchey (1/25/2010)

---

I think a lot of this, for me anyway, is just habit. Is there a good reason any more to put idx or ix at the...

That's good. Buck Woody also did a fantastic presentation about it at the last PASS Summit.

They can be any number of things. Lots of resources use tempdb within SQL Server, sort operations, table spools, hash joins, cursors, lots of stuff. You'll see that encrypted name,...

Phil Factor (1/25/2010)

---

OK, but even if one accepts that constraints or index need some sort of indication of their type from their name, why not just put, for example,...

I would strongly suggest you take a look at the Enterprise Policy Management Framework. It's from a Microsoft developer and it's free. It extends PBM for use with 2000 and...

GilaMonster (1/25/2010)

---

Didn't need to (and I think Grant has the crystal ball this week)....

I think a lot of this, for me anyway, is just habit. Is there a good reason any more to put idx or ix at the beginning of index names?...

I think you could store this in tables, but I'm not sure that you should resolve these in TSQL. However, if you did, then probably you'll need to apply a...

homebrew01 (1/21/2010)

---

Grant Fritchey (1/21/2010)

---

homebrew01 (1/21/2010)

---

I just looked it up ... Not exactly "down the...

Oh,...

Unfortunately no. That's just too vague a question to be able to answer it with any meaning or depth.

The first question I'd ask, when you say that you're storing business...