Tuesday, August 09, 2005

SQL Server Adviser: Viewing SQL Server raw data

SearchSQLServer.com: SQL Server Adviser
August 09, 2005
___________________________________
ISSUE SPONSORED BY: SearchSQLServer.com White Paper Library

.....................................................................
IN THIS ISSUE

-- Undocumented stored procedure: View SQL Server 2000 raw data
-- SQL development environment: Best practices for more efficient SQL
-- Chapter Download: SQL Server memory management
-- Glossary Quiz: Resources to enable high availability
-- SQL Server data modeling tools

HEADLINES
---------------------------------------------------------------------
UNDOCUMENTED STORED PROCEDURE: VIEW SQL SERVER 2000 RAW DATA |
SearchSQLServer.com

If you want to view and interpret raw data in your database, this
undocumented command in SQL Server 2000 will enable you to dump data
to the console or log. Contributor Serdar Yegulalp explains how to
use DBCC PAGE in this tip.
http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1114260,00.html?track=NL-464&ad=524306

MORE INFO:

Manipulate the registry with this undocumented stored procedure
http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1111736,00.html?track=NL-464&ad=524306

Check out our complete collection of stored procedures
http://searchsqlserver.techtarget.com/tipsIndex/0,289482,sid87_tax301764_alpD_idx0,00.html?track=NL-464&ad=524306

::::::::::::::::::::::::::::: SPONSOR :::::::::::::::::::::::::::::::

SearchSQLServer.com White Paper Library

Visit the SearchSQLServer.com White Paper Library and access a
powerful resource for IT professionals looking for the latest in
enterprise SQL Server technologies. Search and browse through a vast
database of white papers, webcasts, analyst reports, case studies,
and more to help you expand your knowledge on SQL Server in the
enterprise.
Take advantage of all the white paper library has to offer today!
http://searchSQLServer.com/r/0,,40220,00.htm?track=NL-464&ad=524306

::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

SQL DEVELOPMENT ENVIRONMENT: BEST PRACTICES FOR MORE EFFICIENT SQL |
SearchSQLServer.com

Behind the scenes of a successful SQL development shop, you will find
well-established principles that cover best practices for everything
from creating stored procedure names to properly establishing
regression tests. Contributor Hilary Cotter details these principles.
http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1114251,00.html?track=NL-464&ad=524306

ALSO ON SEARCHSQLSERVER.COM
---------------------------------------------------------------------
CHAPTER DOWNLOAD: SQL SERVER MEMORY MANAGEMENT

This chapter from the book "The Guru's Guide to SQL Server
Architecture and Internals," by Ken Henderson, explores SQL Server's
memory management architecture. It examines the importance the
designers of SQL Server placed on efficient memory management and
maximum system performance.
http://searchsqlserver.techtarget.com/general/0,295582,sid87_gci1103609,00.html?track=NL-464&ad=524306

GLOSSARY QUIZ: RESOURCES TO ENABLE HIGH AVAILABILITY

In a computer system, this is a group of servers and other resources
that act like a single system and enable high availability and, in
some cases, load balancing and parallel processing. In personal
computer storage technology, it is also the logical unit of file
storage on a hard disk.
http://searchsqlserver.techtarget.com/gDefinition/0,294236,sid87_gci211801,00.html?track=NL-464&ad=524306

SQL SERVER DATA MODELING TOOLS

Make sure you're using SQL Server data modeling tools correctly.
Performance and Tuning expert Jeremy Kadlec tells you what to be
mindful of.
http://searchsqlserver.techtarget.com/ateQuestionNResponse/0,289625,sid87_cid956014_tax301360,00.html?track=NL-464&ad=524306

:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
CONTACT US:

Sales
For sales inquiries, please contact us at:
mailto:mkelly@techtarget.com

Editorial
For feedback about any of our articles or to send us your article
ideas, please contact us at:
mailto:rlorusso@techtarget.com

:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
ABOUT THIS E-NEWSLETTER

This e-newsletter is published by SearchSQLServer.com, a targeted Web
site from TechTarget, the most targeted IT media and events company.
TechTarget offers magazines, Web sites, e-newsletters, Webcasts and
conferences for enterprise IT professionals.
Copyright 2005 TechTarget. All rights reserved.

____________________________________________________________________

To unsubscribe from "SQL Server Adviser":

Go to unsubscribe: http://SearchSQLServer.techtarget.com/u?em=pet.computter%40gmail.com&uid=3058509&cid=524306&track=NL-464

Please note, unsubscribe requests may take up to 24 hours to process;
you may receive additional mailings during that time. A confirmation
e-mail will be sent when your request has been successfully
processed.

Contact us:
SearchSQLServer
Member Services
117 Kendrick Street, Suite 800
Needham, MA 02494