Hi James,

Do you know how Dependency Tracker performs using a plotter to print tables/relationships.  We have enormous amount of tables in our dbs. 

Thanks James, nice programs. 

However, still searching for a tool that will do graphical print outs of tables w/columns like featured in the Database Diagrams except automated for the whole server. 

I honestly can’t tell you why there was this illusion that virtual vmdrives have some magical performance by vmware.  At the time, I thought it...

Thanks everyone and I agree. 

C:\ - os, sql server system files - RAID-1+0 (direct-attached storage, not SAN)

D:\ - Tempdb - RAID-1 (direct-attached storage, not SAN)

Thanks...but that approach is crazy and its too bad MS made these changes...they certainly didn't have the DBA in mind. 

Here you go.

I’m not pushing vmware, I recommended the stand alone blade w/2 cpu’s.  We have a heavy load of stored procedures that need optimization and I would think logically you would...

I ran a batch of stored procedures to compare performance and the vm was one minute longer in duration against the stand alone server.  After the compilation, the vm...

Thanks Brian!

What would happen to the apps(2 tier) that use pagefile on SQL Server?  I've read the virtual server only uses RAM.

CREATE PROCEDURE del_showcode

 @NumId int,

 @TagId int,

 @PartDel bit OUTPUT

AS

DELETE     tableNameA WHERE     (colNameC IS NULL) AND (TagID = @TagId)

DECLARE @Count Int

SELECT @Count = count(*) FROM tableNameA WHERE NumId = @NumID

IF @Count =...

So the virtual server is Server1\SQL1?

Our current task is to set up legato co-standby. The virtual server appears as a created instance with the default instance sharing the data files...

gee mom, I had I'd known you were into SQL I would have called you direct. I know you say not to get involved and not say anything but...

Thanks for the links but I have already read them using the search. It does not address my questions specifically.