None of these things are to be taken lightly. Each must be considered.

sivaprasad (4/1/2010)

---

I am performing audit of SQL Server Instances in our environment. I like to know how to find out the details of below. It applies to SQL Server...

Yes there needs to be foreign keys in the database. Furthermore, there needs to be indexes built on those keys.

What kinds of indexes are you seeing that actually increase in fragmentation?

How many pages are on each of the indexes?

What is the before and after fragmentation % level?

What is your backup schedule?

Weekly full, and then daily diff? Something else?

GregoryF (4/1/2010)

---

You can create a job that reads the errorlog every five minutes (insert the errorlog into a temp table), if there's a deadlock in the last five minutes (or...

I agree that it is more complicated.

Imagine the implications of having a 1TB database, would you also have 1TB of memory?

Your max memory setting would not correlate to aggregate of...

There is a high probability of it self-resolving by upgrading....

Chad Crawford (4/1/2010)

---

Dedicated lurker there. Haven't missed a post for at least a year!...

Trey Staker (4/1/2010)

---

CirquedeSQLeil (4/1/2010)

---

Trey Staker (4/1/2010)

---

I can't believe of few of the whiney comments in the editorial discussion. I guess some people are born without a sense of humor.

I...

rainleta (4/1/2010)

---

CirquedeSQLeil (4/1/2010)

---

rainleta (4/1/2010)

---

CirquedeSQLeil (4/1/2010)

---

In that article I gave it discusses how the Browser Service is used for Named Instances. If you specify a different than default port for...

I have an excellent script for that. I also have a blog post explaining the workings of the script.

Check it out at:

http://jasonbrimhall.info/?p=263

Even...

rainleta (4/1/2010)

---

CirquedeSQLeil (4/1/2010)

---

In that article I gave it discusses how the Browser Service is used for Named Instances. If you specify a different than default port for the default...

Looks like Paul has improved his daily post average.

He is now at 100.9333 posts a day.