Email Alerts
-
Connecting to SQL Server using Visual Studio
SQL Server expert Eric Brown provides some helpful information on connecting to SQL Server using Visual Studio. Ask the Expert
-
Troubleshooting database log file error messages
Development expert Greg Low troubleshoots a full database log file error message. Ask the Expert
-
Q&A: Making the jump to 64-bit SQL Server 2005
Running SQL Server on a 64-bit platform has been an option to improve database performance and scalability for quite some time, but your configuration options were limited and not without problems. For one thing, SQL Server 2000 could only run on the... Interview
-
Quick steps: Searching using CONTAINS
Get help searching with CONTAINS in this book excerpt from MCAD/MCSD/MCSE Training Guide (70-229): SQL Server 2000 Database Design and Implementation. Book Excerpt
-
Quick steps: Creating a clustered index using code
Learn to create a clustered index using code in Query Analyzer in this book excerpt from MCAD/MCSD/MCSE Training Guide (70-229): SQL Server 2000 Database Design and Implementation. Book Excerpt
-
Quick steps: Viewing index information using sp_helpindex
Get a routine to view index information in this book excerpt from MCAD/MCSD/MCSE Training Guide (70-229): SQL Server 2000 Database Design and Implementation. Book Excerpt
-
Quick steps: Executing full-text searches using FREETEXT
Get help executing full-text searches in this book excerpt from MCAD/MCSD/MCSE Training Guide (70-229): SQL Server 2000 Database Design and Implementation. Book Excerpt
-
Quick steps: Using the Full-Text Wizard
Learn how to use the Full-Text Wizard in SQL Server 2000 in this book excerpt from MCAD/MCSD/MCSE Training Guide (70-229): SQL Server 2000 Database Design and Implementation. Book Excerpt
-
Quick steps: Querying and updating index statistics
Learn to query and update index statistics in this book excerpt from MCAD/MCSD/MCSE Training Guide (70-229): SQL Server 2000 Database Design and Implementation. Book Excerpt
-
Quick steps: Creating a nonclustered index in code
Learn to create a nonclustered index in code using Query Analyzer in this book excerpt from MCAD/MCSD/MCSE Training Guide (70-229): SQL Server 2000 Database Design and Implementation. Book Excerpt