If you only know two names of SQL Server experts, one should be Ben-Gan, and the other should be Delaney.

Itzik Ben-Gan is a true master of the science and art...

Fantastic work sir! Thanks for sharing!

eddie.caplan (9/24/2013)

---

Joshua Feierman seems to think the developers are supplicants, pleading for help. In fact, the DBA should think of the developers as his customers, and provide better customer...

"...believe me, as a DBA I definitely let the nice people get away with more than the not so nice ones..."

This mindset would result in your termination at every place...

4 *, nice explanation.

Only thing I would suggest adding is explanation on how the data from the clustered instance gets to the AO instance. Since this article takes a ground-up...

sisiralek (9/8/2008)

---

:)This is a good solution

SET NOCOUNT ON

DECLARE @DBName nvarchar(50), @INName nvarchar(50)

DECLARE @ODBName nvarchar(50), @OINName nvarchar(50)

Declare @execstr nvarchar(200)

--PRINT '-------- Vendor Products Report --------'

DECLARE Index_cursor CURSOR FOR

Select A.Name as InName,ob.Name...

(bump) ... I would also like to do this if anyone knows how to go about it. I'm considering doing my CMS work and pointing SSRS to the resultant data,...