Transact-SQL - Factbites

Transact-SQL - Factbites
Where results make sense
About us | Why use us? | Reviews | PR | Contact us

Topic: Transact-SQL

Note: these results are not from the primary (high quality) database.

In the News (Fri 25 Dec 09)

Northern Trust

Marvin Harrison

Peter Chernin

Gary Locke

Match Play

Penelope Cruz

Mickey Rourke

AR Rahman

Danny Boyle

Hugh Jackman

	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.
	blog.transactsql.com (5374 words)

	How to Perform a SQL Server Database Application & Transact-SQL Performance Audit
		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.
		If they are not, then SQL Server must perform name resolution on the objects if the object names are the same but the owners are different.
	www.sql-server-performance.com /sql_server_performance_audit8.asp (4373 words)

	SQL Server Transact-SQL Query Performance Tuning and Optimization Tips
		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.
		If your SQL Server database is not configured to be case sensitive, you don't need to use LOWER or UPPER to force the case of text to be equal for a comparison to be performed.
		This is because the data is already presorted for you and SQL Server is smart enough not to resort the data.
	www.sql-server-performance.com /transact_sql.asp (6081 words)

	Transact-SQL Cookbook: Chapter 8: Statistics in SQL
		SQL Server is not equipped with a mode function, so calculating the mode is a bit more difficult than calculating the mean.
		In spite of the fact that you can use SQL to generate statistics, it is not our intention to promote SQL as the best language for that purpose.
		Since SQL Server provides functions to calculate standard deviation and variance, it is wise to use them and not program your own.
	www.oreilly.com /catalog/transqlcook/chapter/ch08.html (8163 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).
	www.databasejournal.com /features/mssql/article.php/1437391 (946 words)

	Book review: Transact-SQL Cookbook (O'Reilly Windows) by Ales Spetic, Jonathan Gennick : Narayana Vyas Kondreddi's home page
		Overall, this is a valuable book for beginning-to-intermediate SQL Server programmers and a great reference for experienced database professionals.
		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.
		Lot of DBAs and programmers have come up with their own auditing implementations and there are a lot of third party tools out there as well.
	vyaskn.tripod.com /transact-sql_cookbook.htm (801 words)

	Transact-SQL - Wikipedia, the free encyclopedia
		Transact-SQL is Microsoft's and Sybase's proprietary extension to the SQL language.
		In order to make it more powerful, SQL has been enhanced with additional features such as:
		Various support functions for string processing, date processing, mathematics, etc.
	en.wikipedia.org /wiki/Transact-SQL (63 words)

	SQL Tutorial
		SQL AND and OR How to use AND and OR to join two or more conditions in a WHERE clause.
		SQL is a standard computer language for accessing and manipulating databases.
		Describes what SQL is, and how it can be used.
	www.w3schools.com /sql (606 words)

	FIX: When you use Transact-SQL cursor variables to perform operations that have large iterations, memory leaks may occur in SQL Server 2000
		The response from the computer that is running SQL Server 2000 may become slower.
		Rerun your statement when there are fewer active users or ask the system administrator to check the SQL Server lock and memory configuration.
		The behavior that is mentioned in the "Symptoms" section occurs when you set a cursor variable, and you then re-use the same cursor variable without releasing the resources that are used by the cursor variable.
	support.microsoft.com /kb/837957 (792 words)

	DevGuru Jet SQL introduction
		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).
		The version of SQL created by Microsoft is called Jet SQL and it is the database engine behind Microsoft's Access.
	www.devguru.com /Technologies/jetsql/quickref/jet_sql_intro.html (394 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.
		The back of this book claims that "This is the SQL reference you'll reach for first!" and I can personally support their claim.
	safari.informit.com /0130293393 (1170 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.
		This chapter?s recipes show you how to effectively use SQL for common statistical operations from means and standard deviations to weighted moving averages.
	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.
		Add to this the obligatory dose of relational database theory, and the SQL neophyte is ready to leave summer camp early.
	www.developer.com /db/article.php/2202631 (1369 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.
	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.
		Signifies that all, or some portion, of the code elements between the braces are required elements and must appear in the SQL query.
	www.devguru.com /Technologies/sqlsyntax/quickref/sql_syntax_intro.html (527 words)

	Oracle to SQL Server
		Microsoft® SQL Server™ is the fastest growing relational database management system in the industry based on IDC annual database market share reports.
		SQL Server's built-in Data Transformation Services (DTS) utility eases conversion of your database schema and data.
		However, the costs of database migrations may make you hesitant to switch to SQL Server.
	www.artinsoft.com /iproducts/plsqltodotnet/tool.asp (295 words)

	Transact-SQL Programming -- Sample chapter
		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.
		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.
		When the frontend graphical user interface performs certain transactions, they may actually call the stored procedures you've coded and stored on the server, or their application may initiate transactions that fire triggers on some of the database tables.
	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.
		One, Microsoft SQL Server is now on the same playground as the "big boys" in the database world (IBM DB/2 and Oracle, mainly).
		The book holds much value even to those who do not use Microsoft's SQL; while reading it, I've picked up more than one useful point that can be very helpful with other SQL variants.
	www.forum2.org /tal/books/tsql.html (939 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.
	www.webagesolutions.com /training/microsoft/2071 (158 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.
	www.quest-pipelines.com /newsletter-v3/0802_A.htm (1472 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.
	www.15seconds.com /issue/000817.htm (2169 words)

	Transact-SQL Overview (Transact-SQL Reference (SQL Server))
		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.
		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.
	msdn.microsoft.com /library/en-us/tsqlref/ts_tsqlcon_6lyk.asp?frame=true (234 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.
		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.
		In the top pane of my Visual Studio screenshot you can see the SQL to generate the view, the center pane holds the result set and the lower pane the source information (also depicted is a method of working optimistic concurrency, with CreateStamp, UpdateStamp, DeleteStamp).
	linkwood.blogspot.com (2442 words)

	Amazon.com: Books: Transact-SQL Programming
		I look forward to a revised edition of this book that is based upon SQL 7.0 but I would advise anyone who is ready to improve his or her programming skills not to wait.
		It is largely a Microsoft SQL Server book and while it does cover Sybase Adaptive Server it organizes the information in such a way that if you are interested in just one version you can easily stick with that.
		SQL Server 2000 Programming by Example by Carlos Rojas
	www.amazon.com /exec/obidos/tg/detail/-/1565924010?v=glance (1422 words)

	SQL Server - administración de Bases de Datos y programación SQL (Transact SQL)
		SQL Server - administración de Bases de Datos y programación SQL (Transact SQL)
		Para manejar SQL Server diariamente, un equipo de operación necesita realizar una amplia variedad de procedimientos, tales como supervisar el servidor, realizar copias de seguridad, planear la capacidad además de desarrollador y soporte al usuario final.
		Teneis disponible un nuevo sitio sobre SQL y Bases de Datos Relacionales en general, donde podeis encontrar secciones dedicadas a SQL Server, MySLQ y otros.
	www.helpdna.net /bosqlnov.htm (1090 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.
	www.joesack.com /DTSErrorTrap.htm (598 words)

	SQL Server - administración de Bases de Datos y programación SQL (Transact SQL)
		Lenguaje SQL a través de la implementación del mismo en SQL Server 7 (Transact SQL).
		Trata en profundidad prácticamente todos los temas necesarios para administrar SQL Server, aunque desde mi punto de vista, se les a pasado un punto importante como es el tratamiento de los comandos BCP y BULK INSERT dentro del capítulo dedicado a los servicios de transformación de datos.
		En esta página se incluye una relación de los libros interesantes sobre SQL Server, así como una opinión personal y breve descripción de cada uno de ellos.
	www.helpdna.net /bosqllib.htm (1175 words)

	SQL Links -- r937.com
		SQL Server Transact-SQL Query Performance Tuning and Optimization Tips
		Migrating Recursive SQL from Oracle to DB2 UDB
		It can be difficult in a set-based language such as SQL to determine when a number of records in a row (when ordered by a unique key) have the same values in a particular field.
	r937.com /sqllinks.cfm (3670 words)

	Pearson Education - Guru's Guide to Transact-SQL, The
		Since its introduction over a decade ago, the Microsoft SQL Server query language, Transact-SQL, has become increasingly popular and more powerful.
		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.
		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.
	go.theregister.com /pearson/171033 (424 words)

Try your search on: Qwika (all wikis)

Topic: Transact-SQL

Ads by Google

Related Topics

In the News (Fri 25 Dec 09)