Michael Maddison
michael at ddisolutions.com.au
Tue Apr 4 21:05:08 CDT 2006
David, >From BOL DBCC INDEXDEFRAG (Northwind, Orders, CustomersOrders) GO Did you compare execution plans? regards Michael Maddison DDI Solutions Pty Ltd michael at ddisolutions.com.au Bus: 0260400620 Mob: 0412620497 www.ddisolutions.com.au -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of David Emerson Sent: Wednesday, 5 April 2006 10:04 AM To: accessd at databaseadvisors.com; dba-SQLServer at databaseadvisors.com Subject: Re: [dba-SQLServer] Optimizing Stored Procedures and Views The server is just my local machine not connected to any network. However, the same results occur on the networked server on the Client site. Physical Memory 512MB Virtual Memory 2 GB As far as "hdd, raid, and of course... index defrags" are concerned, where do I find the information on these? David At 4/04/2006, Francisco Tapia wrote: >David, > I might have missed your first post. I'm curious to know what is >your server configuration like?, memory, hdd, raid, and of course... >index defrags. _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com