|
Author | Tim Chapman |
Title |
|
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.)
|
|
Author | Tim Chapman |
Title |
|
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.
|
|
Author | Tim Chapman |
Title |
|
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.
|
|
Author | Tim Chapman |
Title |
|
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.
|
|
Author | Kevin S. Goff |
Title |
|
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.
|
|
Author | Kevin S. Goff |
Title |
|
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.
|
|
Author | Jeff Smith |
Title |
|
Annotation |
The RANK and PARTITION features in 2005 are simply amazing. They make so many "classic" SQL problems very easy to solve.
|
|
Author | Tim Chapman |
Title |
|
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.
|
|
Author | Tim Chapman |
Title |
|
Annotation |
...
|
|
Author | Chris Lee |
Title |
|
Annotation |
I’ll start at a very basic level and talk about how to convert existing applications to use SQL Native Client.
|
|
Author | Acey J. Bunch |
Title |
|
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!
|
|
Author | Frederic BROUARD |
Title |
|
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.
|
|
Author | Jerry Dixon |
Title |
|
Annotation | I 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! |
|
Author | Scott Lowe MCSE |
Title |
|
Annotation | With 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. |
|
Author | Arthur Fuller |
Title |
|
Annotation | Arthur 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. |
|
Author | Euan Garden |
Title |
|
Annotation | Oh 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! |
|
Author | Boris Baliner |
Title |
|
Annotation | Although Management Studio has some very nice long-awaited features, some of the good old stuff just isn't there. |
|
Author | Scott Lowe |
Title |
|
Annotation | There 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. |
|
Author | Arthur Fuller, Stephen Giles |
Title |
|
Annotation | Find 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. |