|
| |
| | How to Perform a SQL Server Database Application & Transact-SQL Performance Audit |
 | | Generally speaking, the SQL Server Query Optimizer does a good job of optimizing queries. | | | If SQL Server cannot find the stored procedure in the Master database, then it next tries to resolve the stored procedure name as if the owner of the object is "dbo". | | | In many cases, hints that were needed under previous versions of SQL Server aren't applicable under newer versions, and their use can actually hurt, not help performance. |
|
http://www.sql-server-performance.com/sql_server_performance_audit8.asp
(4373 words)
|
|
| |
| | SQL Server Transact-SQL Query Performance Tuning and Optimization Tips |
| | This is because the SQL Server Query Optimizer does this for you, saving you the effort. | | | Another negative aspect of a table scan is that it will tend to flush out data pages from the cache with useless data, which reduces SQL Server's ability to reuse useful data in the cache, which increases disk I/O and hurts performance. | | | If you have created a complex transaction that includes several parts, one part of which has a higher probability of rolling back the transaction than the others, better performance will be provided if you locate the most likely to fail part of the transaction at the front of the greater transaction. |
|
http://www.sql-server-performance.com/transact_sql.asp
(6081 words)
|
|
| |
| | DevGuru Jet SQL introduction |
| | The Structured Query Language (SQL) is a computer language for accessing and manipulating databases. | | | In general, Jet SQL is not designed to manage a database, but rather, it is used to retrieve information from a database. | | | There are many different versions of the SQL language, but to be in compliance with the ANSI SQL '92 Standard, they must use and support the same major keywords in a similar manner (such as SELECT, UPDATE, DELETE, INSERT, WHERE, and others). |
|
http://www.devguru.com/Technologies/jetsql/quickref/jet_sql_intro.html
(394 words)
|
|
| |
| | Transact-SQL Optimization Tips |
| | Because the SQL Server query optimizer is very clever, it is highly unlikely that you can optimize your query by using optimizer hints; more often than not, this will hurt performance. | | | SQL Server cursors can result in some performance degradation in comparison with select statements. | | | This can result in a performance benefit, as SQL Server will return to the client only particular rows, not all rows from the table(s). |
|
http://www.databasejournal.com/features/mssql/article.php/1437391
(946 words)
|
|
| |
| | Amazon.ca: Books: Transact-SQL Cookbook |
| | SQL (Structured Query Language) is the closest thing to a standard query language that currently exists, and Transact-SQL -- a full-featured programming language that dramatically extends the power of SQL -- is the procedural language of choice for both Microsoft SQL Server and Sybase SQL Server systems. | | | One or two of the chapters do cover problems which baffle a lot of experienced SQL programmers with whom I have worked; a good example is the chapter on the implementation of hierarchical data models. | | | For someone already working in the field, an online subscription to SQL Server magazine (giving access to all of the source code for the articles) would be a better investment. |
|
http://www.amazon.ca/exec/obidos/ASIN/1565927567
(966 words)
|
|
| |
| | Introductory Transact-SQL |
| | Frequently, the would-be SQL practitioner is forced to run a gauntlet of syntax sinkholes and query quicksand while lugging a ten-volume set on database design and performance and tuning on her back. | | | You can use SQL to create or destroy objects on the database server such as tables and to do things with those objects, such as put data into them or query them for that data. | | | SQL is the lingua franca of the database world. |
|
http://www.developer.com/db/article.php/2202631
(1369 words)
|
|
| |
| | Transact-SQL Blog |
| | SQL Server 2005 helps us solve this problem of trying to figure out which indexes are being used and which ones we may be able to drop. | | | In SQL Server 2000, this question is not always easy to answer as you have to rely on scanning all the execution plans or using the Index Tuning Wizard. | | | I have been trying to come up with a SQL Server 2005 tip or practice the last few days and while I have a list of a thousand things to talk about none of them can be discussed without a little research which I am having a hard time doing the past few days. |
|
http://blog.transactsql.com
(5374 words)
|
|
| |
| | 15 Seconds : Introduction to Transact SQL User-Defined Functions |
| | Adding functions to the Transact SQL language has solved many code reuse issues and provided greater flexibility when programming SQL queries. | | | Before the release of SQL Server 2000, temporary tables would likely have been used to generate the interim data to be used for the final query output. | | | SQL Server 2000 supports three types of functions: scalar, in-line table functions, and multistatement table functions. |
|
http://www.15seconds.com/issue/000817.htm
(2169 words)
|
|
| |
| | Using Macros to Produce User-defined Constructs in Transact-SQL -- {\em Introduction\/} |
| | The ideas found in all these sources are invaluable to SQL programmers but extremely difficult to implement and debug because of their notational complexity. | | | In [1], Rogers describes how to solve a very complicated SQL programming problem with just a couple of queries using the Sybase built-in functions abs, sign and charindex. | | | In [2], Rozenshtein et al, previously developed this idea to solve many distinct classes of problems using the same or similar built-in functions. |
|
http://www.edbarlow.com/macros/macro_1.htm
(490 words)
|
|
| |
| | DevGuru SQL Syntax Introduction |
| | Transact-SQL, which is commonly referred to as T-SQL or TSQL, is a sophisticated dialect of SQL used by Microsoft in both SQL Server 7 and SQL Server 2000. | | | The Guru recommends reading Beyond the Basics with SQL for an explanation of some of the advanced features of Transact SQL. | | | Note that this symbol is not part of the code and must not appear in the SQL query. |
|
http://www.devguru.com/Technologies/sqlsyntax/quickref/sql_syntax_intro.html
(527 words)
|
|
| |
| | Create and Manage SQL Server Stored Procedures using Transact-SQL |
| | As we learn more about SQL Server and Transact-SQL it is easy to become overwhelmed with the amount of information out there. | | | SQL Server provides multiple documented and undocumented statements and system stored procedures that we can use to create new stored procedures, drop existing stored procedures and associate/disassociate extended stored procedures in our databases (remember extended stored procedure are only maintained in the master database). | | | Now that we have a stored procedure built in SQL Server or a extended stored procedure added to the master database we have several ways to return information about that stored procedure to our users or to our code. |
|
http://www.quest-pipelines.com/newsletter-v3/0802_A.htm
(1472 words)
|
|
| |
| | MS2071 Querying Microsoft SQL Server 2000 with Transact-SQL |
| | The goal of this course is to provide students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2000. | | | MS2071 Querying Microsoft SQL Server 2000 with Transact-SQL | | | This course is intended for SQL Server database administrators, implementers, system engineers, and developers who are responsible for writing queries. |
|
http://www.webagesolutions.com/training/microsoft/2071
(158 words)
|
|
| |
| | Transact-SQL Cookbook: Chapter 8: Statistics in SQL |
| | Probably the easiest of all statistics to compute using SQL is the mean. | | | In addition, you'll see how SQL can be used to generate a crude graph of the autocorrelation results quickly. | | | The solution query shown here is an example of how you implement a complex formula directly in SQL. |
|
http://www.oreilly.com/catalog/transqlcook/chapter/ch08.html
(8163 words)
|
|
| |
| | Informit Safari Tech Books Online - Transact-SQL Desk Reference |
| | If you're an SQL programmer, you can easily picture how useful a comprehensive, single-volume Transact-SQL command reference manual would be in streamlining your work. | | | But the sheer complexity of all the SQL options and the proprietary extensions, plus the undoubted opacity of the official documentation has spawned an independent sideline of books that provide alternative and presumably clearer views of the databases. | | | This book is intended for programmers of all levels working with Microsoft SQL Server. |
|
http://safari.informit.com/0130293393
(1170 words)
|
|
| |
| | Transact-SQL Overview (Transact-SQL Reference (SQL Server)) |
| | For information about how Transact-SQL interacts with APIs and application components such as transaction control, cursors, and locking, see Accessing and Changing Relational Data Overview. | | | Transact-SQL is central to the use of Microsoft® SQL Server™. | | | All applications that communicate with SQL Server do so by sending Transact-SQL statements to the server, regardless of an application's user interface. |
|
http://msdn.microsoft.com/library/en-us/tsqlref/ts_tsqlcon_6lyk.asp?frame=true
(234 words)
|
|
| |
| | SQL Tutorial |
| | SQL is a standard computer language for accessing and manipulating databases. | | | In this tutorial you will learn how to use SQL to access and manipulate data in Oracle, Sybase, SQL Server, DB2, Access, and other database systems. | | | SQL AND and OR How to use AND and OR to join two or more conditions in a WHERE clause. |
|
http://www.w3schools.com/sql
(606 words)
|
|
| |
| | Transact-SQL Programming -- Sample chapter |
| | Transact-SQL, under Microsoft SQL Server, has grown to support new aggregate operators, such as ROLLUP and CUBE, that are specifically optimized for very large databases, such as those found in data marts and data warehouses. | | | Transact-SQL, an extension to the SQL database programming language, is a powerful language offering many features--a wide variety of datatypes, temporary objects, system and extended stored procedures, scrollable cursors, conditional processing, transaction control, exception and error handling, and much more. | | | These days, relational database management systems (RDBMSs) like SQL Server and Sybase are the primary engines of information systems everywhere--particularly distributed client/server computing systems. |
|
http://www.oreilly.com/catalog/wintrnssql/chapter/ch01.html
(7245 words)
|
|
| |
| | The Guru's Guide to Transact-SQL |
| | I've used several variants of SQL in my life, but Transact-SQL (Microsoft's SQL language, implemented in MS SQL Server) is simply not one of them. | | | Joe Celko is quoted at the beginning of the first chapter, saying that "the single biggest challenge to learning SQL programming is unlearning procedural programming". | | | Much of the information in the chapter on performance-tuning, for example, is worthwhile advice for any SQL database user. |
|
http://www.forum2.org/tal/books/tsql.html
(939 words)
|
|
| |
| | Transact-SQL User-Defined Functions by Andrew Novick |
| | Transact-SQL doesnt always offer the functions needed for a project, but with user-defined functions, introduced in SQL Server 2000, programmers can create their own. | | | The first part of the book explains the SQL syntax required to create, manage, and use UDFs, while the second part describes the system UDFs that Microsoft has added to SQL Server as tools to implement SQL Server functionality. | | | Learn how UDFs can be debugged with Query Analyzer and SQL Profiler. |
|
http://www.novicksoftware.com/transact-sql-user-defined-functions-book.htm
(496 words)
|
|
| |
| | Amazon.com: Books: Transact-SQL Programming |
| | SQL Server 2000 Programming by Example by Carlos Rojas | | | It is a full-featured programming language that dramatically extends the power of SQL (Structured Query Language). | | | I find the information very accurate and relevant to the MS SQL versions (6.5 & 7.0) printed on the cover of the book. |
|
http://www.amazon.com/exec/obidos/tg/detail/-/1565924010?v=glance
(1422 words)
|
|
| |
| | Pearson Education - Guru's Guide to Transact-SQL, The |
| | The accompanying CD-ROM includes the complete set of code examples found in the book as well as a SQL programming environment that will speed the development of your own top-notch Transact-SQL code. | | | Since its introduction over a decade ago, the Microsoft SQL Server query language, Transact-SQL, has become increasingly popular and more powerful. | | | Your journey begins with an introduction explaining language fundamentals such as database and table creation, inserting and updating data, queries, joins, data presentation, and managing transactions. |
|
http://go.theregister.com/pearson/171033
(424 words)
|
|
| |
| | Linkwood Development |
| | Vadim's code and proof of concept was all, unfortunately for me, in Oracle syntax, so a quick bit of conversion over to Transact-SQL syntax and I had created a fully operational example. | | | MSDN only appears to scribe about adjacency lists, a method which is undoubtably performs, but requires an awful lot of (nested) SQL to work with. | | | Harnessing the power of hierarchies in SQL has been a side-fetish for me now for the past 2 or 3 monthes as the necessity to implement something like this in my work has been under increasing demand. |
|
http://linkwood.blogspot.com
(2442 words)
|
|
| |
| | Joseph Sack's Articles |
| | Within the tasks, add the following Transact-SQL code. | | | Viewing the 255 character chunk of history for each step in the SQL Server Agent Job History. | | | This is also the same data as the log file, capturing physical events and steps during the package runtime. |
|
http://www.joesack.com/DTSErrorTrap.htm
(598 words)
|
|
| |
| | 15 Seconds : Transact-SQL Improves Database Error-Handling |
| | The robust Transact-SQL (T-SQL) syntax in SQL Server provides developers with an efficient way to handle errors within stored procedures. | | | All SQL Server error codes can be found within the master.dbo.sysmessages system table. | | | However most of the easy solutions require you to have your own dedicated IIS or SQL Server on the Internet to play with, a privilege not shared by many. |
|
http://www.15seconds.com/issue/010312.htm
(1615 words)
|
|
| |
| | SQL Links -- r937.com |
| | SQL Server Transact-SQL Query Performance Tuning and Optimization Tips | | | The SQL you write starts to become unwieldy, and data anomalies start to creep in. | | | Use a single SQL statement to perform a top-N query. |
|
http://r937.com/sqllinks.cfm
(3670 words)
|
|
| |
| | Optimizing Transact-SQL Code |
| | Home > Articles > Databases > SQL Server > Optimizing Transact-SQL Code | | | Here are some tips and tricks for avoiding common pitfalls and writing good T-SQL code, as well as some advanced options that you might find useful. | | | In previous articles we showed you how to optimize database models and indexes. |
|
http://www.informit.com/articles/article.asp?p=28497
(223 words)
|
|
| |
| | SQL Server Training Courses - SQL Server 2000 Querying with Transact-SQL training course - learn SQL Server - UK |
| | SQL Server 2000 Querying with Transact-SQL - 2 day course | | | Overview: This course teaches you how to use the Transact-SQL language to query a Microsoft SQL Server 2000 database. | | | SQL Server Training Courses - SQL Server 2000 Querying with Transact-SQL training course - learn SQL Server - UK Courses Top Level --> SQL Server --> SQL Server 2000 Querying with Transact-SQL -->Course Outline |
|
http://www.systematix.co.uk/sql-server-training-course-077463.htm
(82 words)
|
|
| |
| | Book review: Transact-SQL Cookbook (O'Reilly Windows) by Ales Spetic, Jonathan Gennick : Narayana Vyas Kondreddi's home page |
| | Yet another interesting chapter that shows you how to import data from heterogeneous, non-normalized data sources like flat files, CSV files etc. into SQL Server, clean the data, handle errors, transform the data and store it in normalized, relational tables. | | | Overall, this is a valuable book for beginning-to-intermediate SQL Server programmers and a great reference for experienced database professionals. | | | Who said data structures can be programmed only in C and C++? |
|
http://vyaskn.tripod.com/transact-sql_cookbook.htm
(801 words)
|
|
| |
| | Product Documentation |
| | The online SQL Server 2000 system table map incorporates the benefits of the visual representation of table relationships from the printed version of the map with the technical detail found in the Transact-SQL Reference system table topics. | | | SQL Server 2005 Community Technology Preview September 2005: Books Online | | | Download Books Online for the SQL Server 2005 Community Technology Preview September 2005—the primary documentation set for SQL Server 2005, with complete setup and upgrade instructions, new feature descriptions, tutorials, and reference information. |
|
http://www.microsoft.com/sql/techinfo/productdoc/2000/default.mspx
(176 words)
|
|
|
