Hi Jay,

It seems that I did not get my point across. I completely agree that Nested Views are a BAD THING. And I understand your comments about templates,...

As a general rule I do not like views and I discourage developers from using them. My position is based on experience back to SQL 6.5. I find...

Tom may be Pedantic but I agree with him in general. Whether considered a wild card or not "[a]" is clearly not a character. Despite BOL (see the...

Hi Dave,

Life's tough in the trenches. In my last gig I fought a 2 year battle over a Windows2000 SE, SQL2000SE server with 4GB RAM. The management position...

Your problem description is pretty generic (my server is non responsive sometimes) and the Bad Me is tempted to reply, you probably have a performance problem to resolve 😛

Questions that...

A number of folks mentioned that additional tool requirements (e.g., SSIS, SSRS) would be a major factor in their decision.

I understand the rationale and I have applied it myself. ...

It is true that RAID 5 typically shows well in Random Read Testing. However, even a small amout of write activity can quickly tip that apparent advantage over RAID...

btd (5/1/2012)

---

I do agree a well put together document BUT I wish we could get away from the interpretation of RAID. 'inexpensive discs'... The 'I' certainly did not...

Eric M Russell (2/21/2012)

---

Ray Herring (2/21/2012)

---

Hi Eric,

Great tool and very timely for me :).

I wonder about an addition. Of course in SQL 2008 Local Admins are not automatically members...

Hi Eric,

Great tool and very timely for me :).

I wonder about an addition. Of course in SQL 2008 Local Admins are not automatically members of Builtin/Administrators, But it would...

Thanks

Thanks Gail.

The link got me started on the right path. I ended up creating a dummy Replication Publication, running ReplDone, deleting the dummy Replication. That cleared the...

I recall a similar experience about 9 months back. CheckDB would run successfully on DB A, then Fail on B, then fail on A then succeed on C & B....

Jason-299789 (11/5/2009)

---

In interesting solution, for a not so real problem, as any decent organisation has standards in place and will ensure that all code conforms to the corporate standards.

If not...

tim.stevens (8/24/2010)

---

This is one of the best concise treatises on NULL I have seen. Your adminition about a well architected database design not allowing NULLs for any columns is...