http://www.sqlservercentral.com/Content tagged Basic Querying, SQL Server 7, 2000, T-SQL, Miscellaneous posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Mindy explores the metadata stored in SQL 2000 to show you how to produce a simple and useful data dictionary! http://www.sqlservercentral.com/articles/Installation/datadictionaryfromwithinsqlserver2000/607/2005/02/04http://www.sqlservercentral.com/articles/Installation/datadictionaryfromwithinsqlserver2000/607/A monster book at 980 pages, it's written in 'how-to' format and has a ton of good material. Andy gave it the once over for us and reports back - see what he thinks! http://www.sqlservercentral.com/articles/Installation/reviewofsql2000fastanswers/959/2003/04/18http://www.sqlservercentral.com/articles/Installation/reviewofsql2000fastanswers/959/We've had a good run of jobs about job management lately, Randy sent us another one that looks at the job of job management and shows us how he tackled the problem. http://www.sqlservercentral.com/articles/Administering/managingjobsusingtsql/945/2003/04/02http://www.sqlservercentral.com/articles/Administering/managingjobsusingtsql/945/If you've been with us for a while you know that Andy started a series last year on worst practices. As he says, maybe you can't always do best practices, but at least dont do the worst ones. Read the article and add a comment, participate! http://www.sqlservercentral.com/articles/Administering/worstpracticesortingbyordinal/811/2002/10/01http://www.sqlservercentral.com/articles/Administering/worstpracticesortingbyordinal/811/Programmers can most commonly relate to interface-based programming in their programming language. This is harder to accomplish in SQL Server though. In this article by Chris Cubley, he shows you how to build interfaced-based SQL. http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/sql_interface_final/732/2002/07/19http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/sql_interface_final/732/Andy sits down with an entry level book to see if he should use it at work as a teaching aid. Did he like it? Should you buy it? Read the review now! http://www.sqlservercentral.com/articles/Installation/reviewofsqlserver2000programmingmspress/694/2002/06/04http://www.sqlservercentral.com/articles/Installation/reviewofsqlserver2000programmingmspress/694/Mindy explores the metadata stored in SQL 2000 to show you how to produce a simple and useful data dictionary! http://www.sqlservercentral.com/articles/Installation/datadictionaryfromwithinsqlserver2000/607/2005/02/04http://www.sqlservercentral.com/articles/Installation/datadictionaryfromwithinsqlserver2000/607/Have you ever experienced a T-SQL query, a stored procedure, view or a trigger returning unexpected results. In this article by Raj Gill, he shows you how ANSI DEFAULTS may be to blame. http://www.sqlservercentral.com/articles/Administering/understandingtheimplicationsofansisql92setoptions/482/2001/10/18http://www.sqlservercentral.com/articles/Administering/understandingtheimplicationsofansisql92setoptions/482/