<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Search:
Home
Articles
Editorials
Forums
Scripts
Blogs
QotD
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Advertise
Write for us
Content with tags
T-SQL
,
SQL Server 2005
,
Advanced Querying
Refine your search with one of the following additional tags (with number of items):
SQL Server 2005 - TSQL
(2)
Miscellaneous
(1)
Administration
(1)
Performance Tuning
(1)
games
(1)
Puzzle
(1)
Items 1 to 5 of 5
A Sudoku solution with set based T-SQL utilizing binary operators.
A Sudoku solution with set based T-SQL approach utilizing binary values and operators, to ease the algorithm.
Read more...
By
Kevin Duan
2008/06/09
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
98 reads
Introduction to Parameterization in SQL Server
In a previous article I showed how to look at what query plans are in SQL Server's memory. In this article I'll look at how they got there and how and when they get reused. This is commonly called compiling a query plan. More specifically I'll look at how and when SQL Server can parameterize dynamic SQL
Read more...
By
Additional Articles
2007/08/14
|
Source:
SQLTeam.com
|
Category:
Performance Tuning
Rating:
Rate this
|
Briefcase
|
2,698 reads
Write PIVOT queries in SQL Server 2005
New to SQL Server 2005 is the PIVOT operator, which gives you the ability to rotate row level data into tabular data without the use of the CASE statement, as was necessary in previous versions of SQL Server.
Read more...
By
Additional Articles
2007/01/11
|
Source:
Builder.com
|
Category:
Advanced Querying
Rating:
Rate this
|
Briefcase
|
4,139 reads
Using the OUTPUT Clause to Capture Identity Values on Multi-Row Insert
SQL Server 2005 introducted the OUTPUT clause which we can use to capture values from the inserted and deleted virtual tables.
Read more...
By
Additional Articles
2006/08/25
|
Source:
SQLTeam.com
|
Category:
Advanced Querying
Rating:
Rate this
|
Briefcase
|
2,823 reads
Fast Text Processing in SQL Server
Processing text or long strings usually reduces SQL to a prosaic procedural language. Learn a few techniques for facilitating speedy text processing in SQL.
Read more...
By
Additional Articles
2006/05/10
|
Source:
DevX
|
Category:
Advanced Querying
Rating:
Rate this
|
Briefcase
|
3,670 reads
Items 1 to 5 of 5
Copyright © 2002-2008 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use
