http://www.sqlservercentral.com/Content tagged T-SQL, Basic Querying, SQL Server 7, 2000 posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)In this article Randy Dyness shows you how to avoid temp tables whenever to maximize the performance of your queries. http://www.sqlservercentral.com/articles/Performance+Tuning/temptabl/662/2008/05/30http://www.sqlservercentral.com/articles/Performance+Tuning/temptabl/662/In this article Randy Dyness shows you how to avoid temp tables whenever to maximize the performance of your queries. http://www.sqlservercentral.com/articles/Performance+Tuning/temptabl/662/2008/05/30http://www.sqlservercentral.com/articles/Performance+Tuning/temptabl/662/Part 2 of Steve Jones' series on beginning SQL Server from the perspective of a system administrator or someone not used to working with SQL Server. If you've been designated the new administrator, take a look at this series for some help in coming up to speed on this product. http://www.sqlservercentral.com/articles/Administering/beginningsqlserverlimityourqueries/1458/2006/04/14http://www.sqlservercentral.com/articles/Administering/beginningsqlserverlimityourqueries/1458/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/In this article, Brian Kelley continues his series on Query Analyzer for SQL Server 2000. Query Analyzer offers a highly configurable integrated development environment (IDE). Some of the areas Brian looks at are how to modify the fonts and colors, set connection settings, choose scripting options, and customizing file and result set options. Learn how to make the most of the IDE and make it work for you. http://www.sqlservercentral.com/articles/Administering/qa2k_3/740/2005/01/07http://www.sqlservercentral.com/articles/Administering/qa2k_3/740/Brian Kelley continues his series on getting the most out of SQL Server 2000's Query Analyzer. In this article he looks at the Object Browser and the Transact-SQL Debugger, new features in the 2000 Edition which can reduce development and troubleshooting time for DBAs and database developers. http://www.sqlservercentral.com/articles/Administering/qa2k_2/622/2004/12/31http://www.sqlservercentral.com/articles/Administering/qa2k_2/622/So you open up the tool a hundred times a day. In this article by Brian Kelley, he shows you how to get the most out of some of the known and unknown features. http://www.sqlservercentral.com/articles/Administering/qa2k_1/614/2004/12/23http://www.sqlservercentral.com/articles/Administering/qa2k_1/614/Part 2 of Steve Jones' series on beginning SQL Server from the perspective of a system administrator or someone not used to working with SQL Server. If you've been designated the new administrator, take a look at this series for some help in coming up to speed on this product. http://www.sqlservercentral.com/articles/Administering/beginningsqlserverlimityourqueries/1458/2006/04/14http://www.sqlservercentral.com/articles/Administering/beginningsqlserverlimityourqueries/1458/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/There may be more ways than you realize to determine the version and service pack of SQL Server. This quick article by Dinesh Priyankara will show you 3 of those methods. http://www.sqlservercentral.com/articles/Service+Packs/versionservicepack/928/2003/02/28http://www.sqlservercentral.com/articles/Service+Packs/versionservicepack/928/In this article, James Travis covers a common performance topic of prefixing stored procedures sp_. Does it really slow down performance? http://www.sqlservercentral.com/articles/Performance+Tuning/sp_performance/850/2002/11/14http://www.sqlservercentral.com/articles/Performance+Tuning/sp_performance/850/This article explains how to use a simple batch file and script file to manage multiple databases on multiple servers. http://www.sqlservercentral.com/articles/Configuring/osql/831/2002/10/24http://www.sqlservercentral.com/articles/Configuring/osql/831/Check constraints can be added to a table to enforce specific rules on one or more columns. This article shows you how to use them to enforce simple and more complex rules. http://www.sqlservercentral.com/articles/Administering/usingcheckconstraints/815/2002/10/03http://www.sqlservercentral.com/articles/Administering/usingcheckconstraints/815/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/The behavior of SQL Server is influenced in many ways by the various settings and options available. This series will examine some of the ANSI options that can be set and changed in SQL Server. http://www.sqlservercentral.com/articles/Configuring/ansioptionspart3ansi_null_dflt_on/736/2002/08/07http://www.sqlservercentral.com/articles/Configuring/ansioptionspart3ansi_null_dflt_on/736/In this article, Brian Kelley continues his series on Query Analyzer for SQL Server 2000. Query Analyzer offers a highly configurable integrated development environment (IDE). Some of the areas Brian looks at are how to modify the fonts and colors, set connection settings, choose scripting options, and customizing file and result set options. Learn how to make the most of the IDE and make it work for you. http://www.sqlservercentral.com/articles/Administering/qa2k_3/740/2005/01/07http://www.sqlservercentral.com/articles/Administering/qa2k_3/740/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/The behavior of SQL Server is influenced in many ways by the various settings and options available. This series will examine some of the ANSI options that can be set and changed in SQL Server. http://www.sqlservercentral.com/articles/Configuring/ansioptionspart1ansi_padding/723/2002/07/08http://www.sqlservercentral.com/articles/Configuring/ansioptionspart1ansi_padding/723/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/Building and executing dynamic sql in a stored procedure - is it the only way to solve problems like supporting a simple search function? Leon offers a couple alternatives that let you continue to provide the functionality in a stored procedure without using dynamic sql. Interesting ideas worth exploring! http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/makingdynamicqueriesstatic/672/2002/05/02http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/makingdynamicqueriesstatic/672/In this article Randy Dyness shows you how to avoid temp tables whenever to maximize the performance of your queries. http://www.sqlservercentral.com/articles/Performance+Tuning/temptabl/662/2008/05/30http://www.sqlservercentral.com/articles/Performance+Tuning/temptabl/662/Brian Kelley continues his series on getting the most out of SQL Server 2000's Query Analyzer. In this article he looks at the Object Browser and the Transact-SQL Debugger, new features in the 2000 Edition which can reduce development and troubleshooting time for DBAs and database developers. http://www.sqlservercentral.com/articles/Administering/qa2k_2/622/2004/12/31http://www.sqlservercentral.com/articles/Administering/qa2k_2/622/Sooner or later everyone who works with SQL Server hears that it is better to avoid dynamic SQL at all cost. Dynamic SQL will force you to give out more permissions than static SQL. This article by Robert Marda shows you some of the security issues with dynamic SQL. http://www.sqlservercentral.com/articles/Security/dynamicsqlversusstaticsqlp1/617/2002/02/27http://www.sqlservercentral.com/articles/Security/dynamicsqlversusstaticsqlp1/617/So you open up the tool a hundred times a day. In this article by Brian Kelley, he shows you how to get the most out of some of the known and unknown features. http://www.sqlservercentral.com/articles/Administering/qa2k_1/614/2004/12/23http://www.sqlservercentral.com/articles/Administering/qa2k_1/614/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/SQL Server DBAs are often curious about the inner-workings of SQL Server. Indeed, it can save your job during disasters to know what's going on inside SQL Server. This article shows you how to use some of the SQL Server internal views to view some meta data about your servers. http://www.sqlservercentral.com/articles/Administering/informationschemaviews/569/2002/01/09http://www.sqlservercentral.com/articles/Administering/informationschemaviews/569/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/