 |
|
8000XXXX Errors ASP.NET 2.0 Classic ASP 1.0
Databases Access DB & ADO General SQL Server & Access Articles MySQL Other Articles Schema Tutorials Sql Server 2000 Sql Server 2005 General Concepts Search Engine Optimization (SEO)Search
ASP FAQ Tutorials :: Databases :: Sql Server 2000 :: Where else can I learn about SQL Server?
Where else can I learn about SQL Server?
There are several resources devoted to SQL Server. Here are Microsoft's:
If you don't already have it installed, download Books Online right now. See Article #2229 for more information (Books Online was updated long after it was initially released).
If you don't own the SQL Server 2000 Resource Kit, you can read the chapters online. The CD is more than worth the cover price.
Microsoft SQL Server Community
Related Communities for SQL Server
SQL Server newsgroups (use NNTP, not HTML — please see Etiquette #5007.)
Microsoft's SQL Server Home
SQL Server 2000 Operations Guide
Some of the TechNet Chat Transcripts might make interesting reading.
FAQ articles in the Knowledge Base
SQL Server resource sites from MVPs:
Aaron Bertrand (SQL Server 2005)
Darren Green
Dinesh.T.K
Erland Sommarskog
Fernando Guerrero
Greg Low
Itzik Ben-Gan
Jasper Smith
Kimberly Tripp
Michael Hotek
Narayana Vyas Kondreddi
Nigel Rivett
Steve Kass
Tibor Karaszi
Umachandar Jayachandran
Vinodk
Other resource / reference sites:
SQL Server FAQ
SQL Server Magazine
SQL Server Professional
SQLDev.Net
SQLXML.org
Database Journal (formerly swynk.com/sql)
SearchSQLServer
SQL Server Examples
SQL Server Central
SQL Server Worldwide Users Group
Professional Association for SQL Server
SQLTeam.com
SQL Server Q & A
SQL-Server-Performance.com
SQL-Tutorial.net
And these are the titles on my bookshelf.
Inside SQL Server 2000 (Delaney)
The Guru's Guide to SQL Server Architect... (Henderson)
The Guru's Guide to SQL Server Stored Pr... (Henderson)
The Guru's Guide to Transact-SQL (Henderson)
Advanced Transact-SQL for SQL Server 200... (Ben-Gan / Moreau)
Pro SQL Server 2005 (Rizzo, Machanic, ...)
Hitchhiker's Guide to SQL Server 2000 Re... (Blackburn, Vaughn)
SQL 2000 XML Distilled (Williams, Likes, et. al.)
Pro SQL Server 2000 Database Design (Davidson)
SQL Server: Common Problems, Tested Solu... (Pike)
SQL Server 2000 Resource Kit (MS Press)
SQL Server 2000 Reference Library (Iseminger)
SQL Server 2000 Performance Tuning Techn... (MS Press)
A First Look at SQL Server 2005 for Deve... (Beauchemin, Berglund, Sullivan)
Programming Microsoft SQL Server 2000 wi... (Dobson)
SQL Programming Style (Celko)
Trees and Hierarchies in SQL for Smartie... (Celko)
SQL for Smarties (Celko)
SQL in a Nutshell (Kline/Kline/Hunt)
SQL Server 2000 Performance Optimization... (England)
SQL Server 2000 Optimization Guide (Fields)
Hitchhiker's Guide to Visual Basic and S... (Vaughn)
Writing Stored Procedures for Microsoft ... (Shepker)
A Guide to SQL Server Transactional and ... (Cotter)
If you don't already have it installed, download Books Online right now. See Article #2229 for more information (Books Online was updated long after it was initially released).
If you don't own the SQL Server 2000 Resource Kit, you can read the chapters online. The CD is more than worth the cover price.
Microsoft SQL Server Community
Related Communities for SQL Server
SQL Server newsgroups (use NNTP, not HTML — please see Etiquette #5007.)
Microsoft's SQL Server Home
SQL Server 2000 Operations Guide
Some of the TechNet Chat Transcripts might make interesting reading.
FAQ articles in the Knowledge Base
SQL Server resource sites from MVPs:
Aaron Bertrand (SQL Server 2005)
Darren Green
Dinesh.T.K
Erland Sommarskog
Fernando Guerrero
Greg Low
Itzik Ben-Gan
Jasper Smith
Kimberly Tripp
Michael Hotek
Narayana Vyas Kondreddi
Nigel Rivett
Steve Kass
Tibor Karaszi
Umachandar Jayachandran
Vinodk
Other resource / reference sites:
SQL Server FAQ
SQL Server Magazine
SQL Server Professional
SQLDev.Net
SQLXML.org
Database Journal (formerly swynk.com/sql)
SearchSQLServer
SQL Server Examples
SQL Server Central
SQL Server Worldwide Users Group
Professional Association for SQL Server
SQLTeam.com
SQL Server Q & A
SQL-Server-Performance.com
SQL-Tutorial.net
And these are the titles on my bookshelf.
Inside SQL Server 2000 (Delaney)
The Guru's Guide to SQL Server Architect... (Henderson)
The Guru's Guide to SQL Server Stored Pr... (Henderson)
The Guru's Guide to Transact-SQL (Henderson)
Advanced Transact-SQL for SQL Server 200... (Ben-Gan / Moreau)
Pro SQL Server 2005 (Rizzo, Machanic, ...)
Hitchhiker's Guide to SQL Server 2000 Re... (Blackburn, Vaughn)
SQL 2000 XML Distilled (Williams, Likes, et. al.)
Pro SQL Server 2000 Database Design (Davidson)
SQL Server: Common Problems, Tested Solu... (Pike)
SQL Server 2000 Resource Kit (MS Press)
SQL Server 2000 Reference Library (Iseminger)
SQL Server 2000 Performance Tuning Techn... (MS Press)
A First Look at SQL Server 2005 for Deve... (Beauchemin, Berglund, Sullivan)
Programming Microsoft SQL Server 2000 wi... (Dobson)
SQL Programming Style (Celko)
Trees and Hierarchies in SQL for Smartie... (Celko)
SQL for Smarties (Celko)
SQL in a Nutshell (Kline/Kline/Hunt)
SQL Server 2000 Performance Optimization... (England)
SQL Server 2000 Optimization Guide (Fields)
Hitchhiker's Guide to Visual Basic and S... (Vaughn)
Writing Stored Procedures for Microsoft ... (Shepker)
A Guide to SQL Server Transactional and ... (Cotter)
Related Articles
Are there tools available for auditing changes to SQL Server data? Can I create an index on a BIT column? Can I have optional parameters to my stored procedures? Can I implement an input mask in SQL Server? Can I make SQL Server format dates and times for me? Can I start IDENTITY values at a new seed? Can SQL Server tell me which row was inserted most recently? How can I learn more about undocumented SQL Server stored procedures? How can I make my SQL queries case sensitive? How do I audit changes to SQL Server data? How do I connect to a non-default instance of SQL Server? How do I connect to SQL Server on a port other than 1433? How do I create a cross-tab (or "pivot") query? How do I determine if a table exists in a SQL Server database? How do I drop a SQL Server database? How do I find all the available SQL Servers on my network? How do I get a list of SQL Server tables and their row counts? How do I get rid of Named Pipes / DBNMPNTW errors? How do I get the correct date/time from the msdb.sysjob* tables? How do I get the nth row in a SQL Server table? How do I get the result of dynamic SQL into a variable? How do I handle REPLACE() within an NTEXT column in SQL Server? How do I hide system tables in SQL Server's Enterprise Manager? How do I know which version of SQL Server I'm running? How do I limit the number of rows returned in my resultset? How do I load text or csv file data into SQL Server? How do I manage changes in SQL Server objects? How do I monitor SQL Server performance? How do I prevent linked server errors? How do I reclaim space in SQL Server? How do I recover data from SQL Server's log files? How do I search for special characters (e.g. %) in SQL Server? How do I start SQL Server Agent from ASP? How do I time my T-SQL code? How do I upsize from Access to SQL Server? How do I upsize my MSDE database to full-blown SQL Server 2000? How do I use a variable in a TOP clause in SQL Server? How do I use GETDATE() within a User-Defined Function (UDF)? How should I store an IP address in SQL Server? Schema: How do I find all the foreign keys in a database? SQL Server & MSDE What are reserved Access, ODBC and SQL Server keywords? What are the capacities of Access, SQL Server, and MSDE? What are the main differences between Access and SQL Server? What do I need to know about SQL Server 2000 SP4? Where is SP4 for SQL Server 2000? Why am I having problems with SQL Server 2000 SP3 / SP3a? Why can't I install SQL Server on Windows Server 2003? Why can't I install SQL Server on Windows XP? Why can't I use LIKE '%datepart%' queries? Why do I get "Login failed for user '\'."? Why do I get 'object could not be found' or 'invalid object name'? Why do I get errors about master..spt_values? Why do I get script errors in Enterprise Manager's 'taskpad' view? Why do I get SQLSetConnectAttr Failed errors? Why do I have problems with views after altering the base table? Why does EM crash when I get an error in a stored procedure? Why does Enterprise Manager return 'Invalid cursor state'? Why does my DELETE query not work? Why does sp_spaceused return inaccurate values? Why is Enterprise Manager slow at expanding my database list? Why is my app slow after upgrading from SQL Server 7 to 2000? Why is tempdb full, and how can I prevent this from happening? Why should I consider using an auxiliary calendar table? Why should I consider using an auxiliary numbers table?