Books and articles about SQL Rambler's Top100 Сменить язык на: Русский 19 March 2024 11:35:24


www.sql-ex.ru
Skip Navigation Links  

 

MS SQL Server 2005 (part 1)


AuthorTim Chapman
Title

Rebuild indexes online with SQL Server 2005

Annotation Indexes are specialized data structures that operate on tables (and sometimes views) in the database engine used to aid in the searching for and sorting of data. Indexes are vital to the database engine returning results quickly. As data is modified in the underlying tables that the indexes operate on, the indexes become fragmented. Fragmentation is when the logical ordering of an index does not match the physical ordering of the underlying table or view. As the indexes become more and more fragmented, query times can begin to suffer. The remedy to this situation is to either reorganize or rebuild the index in SQL Server 2005. (Note: This feature is only available in the Enterprise Edition of the product.)

AuthorTim Chapman
Title

Invoke UDFs that accept tables with SQL Server 2005's APPLY operator

Annotation A new feature in SQL Server 2005 is the APPLY operator, which allows the database developer to invoke a user-defined function that takes table value parameters. In this article, Tim Chapman shows you how to use this incredibly useful new operator.

AuthorTim Chapman
Title

Write custom trace files in TSQL

Annotation SQL Server 2005's default trace is great for monitoring system information and for finding out what happened on your server after problems occur. However, there are times when the events that the default captures are not what you need. Here are instructions for how you can create your own trace files in TSQL to catch events on your database machine.

AuthorTim Chapman
Title

Monitor system information with SQL Server 2005's default trace

Annotation Sometimes it is difficult to diagnose problems on your SQL Server after they have occurred. So find out why you should use SQL Server 2005’s default trace feature to monitor certain events.

AuthorKevin S. Goff
Title

Take Five with SQL Server 2005: New T-SQL Capabilities in SQL Server 2005 - Part 2 of 3

Annotation This article is part two of a three-part series on new Transact-SQL language features in SQL Server 2005. This edition covers three new language features in T-SQL 2005.

AuthorKevin S. Goff
Title

Take Five with SQL Server 2005: New T-SQL Capabilities in SQL Server 2005 - Part 1 of 3

Annotation This article begins a three-part series on new Transact-SQL language features in SQL Server 2005. Microsoft added many new language features in SQL Server 2005 in response to developer requests and also in following compliance with the SQL-99 standard. These are featured in this article.

AuthorJeff Smith
Title

SQL Server 2005: Using Rank and Partition in your criteria

Annotation The RANK and PARTITION features in 2005 are simply amazing. They make so many "classic" SQL problems very easy to solve.

AuthorTim Chapman
Title

Cut development time with SQL Server 2005's synonyms

Annotation SQL Server 2005's synonyms allow you to give an alias to an already existing object. Realize the benefits of synonyms by using them as a layer of abstraction between the underlying objects and the synonym.

AuthorTim Chapman
Title

Modifying execution context in SQL Server 2005

Annotation ...

AuthorChris Lee
Title

Getting started with SQL Native Client

Annotation I’ll start at a very basic level and talk about how to convert existing applications to use SQL Native Client.

AuthorAcey J. Bunch
Title

Introducing SQL Native Client

Annotation By now you may have heard of a new data access technology called “SQL Native Client” that will ship with SQL Server 2005. But before we go much further in discussing it, let’s be clear about what we mean by “new”. It is new in that this data access library did not exist prior to SQL Server 2005, but rest assured that it is not some radical new design for accessing data!

AuthorFrederic BROUARD
Title

Recursive Queries in SQL:1999 and SQL Server 2005

Annotation Everybody has at one time in his life, had experience with recursion. When I was young, I was on leave in Paris in an old building in which the corridor had two mirrors facing each other. When I passed between theses mirrors my body was reflected ad infinitum, and I was very proud, joyfully admiring my image and having a concrete view of what is the infinite. That is it: recursion... A process which is able to reproduce himself for some period of time.
In mechanical situations, we do not accept infinite recursion. In the real world, we must have a stopping point because our universe is closed. Waiting for the end of an infinite process, which in fact is eternity, is a hard job ! As Woody Allen says : "eternity is really long, especially near the end ..."
In computer management, recursion is a special technique that is able, sometimes, to treat complex algorithms with an elegant coding style : a few lines will do a complete job. But recursion has some perverse effects: the resources to do the job are maximized by the fact that every call of the embedded process needs to open a complete environment space, which has the effect of using a large volume of memory.
A mathematician, whose name I cannot recall, says that every recursive algorithm can be reduce to an iterative one by the use of a stack!
But our purpose in this article is to speak about RECURSIVE QUERIES in SQL, regarding the ISO standard and what MS SQL Server 2005 has done with it.

AuthorJerry Dixon
Title

CTE Performance

AnnotationI just finished reading an article on the net, which says that table variables can be twice as fast as CTEs. This confused me a bit, because I recently tested a complex UDF that used CTEs to replace table variables. The CTE version was over twenty times faster!

AuthorScott Lowe MCSE
Title

How do I… install SQL Server 2005 Express Edition and SQL Server Management Studio Express?

AnnotationWith the release of SQL Server 2005 Express Edition and the SQL Server Management Studio Express, Microsoft has entered the small, free database market with a splash trumping even their own Microsoft SQL Desktop Edition. SQL Server Management Studio Express -- a full-featured management tool comparable to the legacy SQL Server Enterprise Manager -- makes this entry-level database software usable and formidable for running small businesses, small Web sites, and more.

AuthorArthur Fuller
Title

Toying with template parameters in SQL Server 2005

AnnotationArthur Fuller details some slick things that you can do with the template parameters in SQL Server 2005. He also points out a potential problem with this feature, which he says shouldn't deter developers from using it.

AuthorEuan Garden
Title

SQL MythBusters – MSDE/SQL Express has a 5 concurrent user limit

AnnotationOh man, if I had a quid for every time this has been answered in the newsgroups or at conferences it would be time to retire for sure!

AuthorBoris Baliner
Title

SQL 2000 to SQL 2005: Where Have All the Old Features Gone?

AnnotationAlthough Management Studio has some very nice long-awaited features, some of the good old stuff just isn't there.

AuthorScott Lowe
Title

Make the jump to SQL Server 2005 with these notes and tips

AnnotationThere are a number of changes you should understand before you begin planning the leap from SQL Server 2000 or SQL Server 7 to the recently released SQL Server 2005.

AuthorArthur Fuller, Stephen Giles
Title

10 things you should know about SQL Server 2005 features

AnnotationFind out the 10 most compelling reasons why you should upgrade to SQL Server 2005. Several enhancements to the latest edition of SQL Server include Management Studio, SSIS, and built-in business intelligence.

AuthorScott Robinson
Title

10 things you should know about SQL Server 2005 features



Usage of any materials of this site is possible
only under condition of mandatory allocation of the direct link to a site
http://www.sqlbooks.ru
on each page where used materials are placed.

 Main   Articles    Books 
Рейтинг@Mail.ru Rambler's Top100 Alt Упражнения по SQL: обучение, тестирование, сертификация по языку SQL Copyright c 2002-2006. All rights reserved.