Typically the OS is going to want to grab up to 2GB of RAM. However, with Advanced Server, if you have 4 GB, you can use the 3 GB switch...

Since you are on Windows 2000 Server (not Advanced Server), the following article applies:

http://support.microsoft.com/default.aspx?scid=kb;en-us;291988

Key part of the article:

quote:

---

When the /3GB switch is...

Don't feel that way. It's not intuitive. Kinda like the difference in parameter order for sp_addsrvrolemember and sp_addrolemember. These little things will drive you nuts.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish...

GO is a batch separator used by Query Analyzer. Your best bet would be to parse the script, using the GO as a separator as well. For instance, execute all...

Well, there went Oracle's marketing in ComputerWorld, too. Nice to see the game's afoot!

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

Put it in single quotes:

EXEC sp_help 'PRODDTA.tablename'

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

Hehehe, I'm not a big fan of partitioned views, either. You also have to consider that for it to work efficiently you have to be able to segment your data...

You can change the default, but if you want to actually move the databases, that's more of a manual process. To change the default path, do the following from inside...

The system stored procedure sp_helptext will give you the view definition. Is that what you're needing?

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

On my list to do this weekend, but I have to build my stylesheet to add to my website. BTW, is Eurgeeka officially dead?

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide...

You can also use the various trace stored procedures that are provided... same functionality as Profiler but without the app running interactively. If you tailor your traces, you can minimize...

We're hoping Yukon answers a lot of the high-scalability requests. Keep in mind that you have some method of load balancing using partitioned views (see Vyas' article at http://vyaskn.tripod.com/) and...

Not much info is out on Yukon yet. Microsoft is being very tight-lipped except for the demos they've shown.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring...

Try installing MDAC 2.7 SP1 manually. That has fixed it for some folks (like it did with SQL 2K SP3).

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server...

Good catch, John. Database, not server, is in standby. My goodness it has been a LONG week.

We don't like idle boxes, either. All of our clusters...