Sign in
Ward Pond's SQL Server blog
Ruminating on issues pertinent to the design and development of sound databases and processes under Microsoft SQL Server 2008, SQL Server 2005, and SQL Server 2000 (while reserving the right to vent about anything else that's on my mind)
Options
About
Email Blog Author
RSS for posts
Atom
RSS for comments
OK
Blog - Link List
SQL Server Resources
Michael Rys' blog
Kimberly L. Tripp's blog
Adam Machanic's blog
SQL Server 2005 Service Pack 3
Books OnLine For SQL Server 2005 SP1
Hugo Kornelis' blog
SQL Server Customer Advisory Team blog
Tips, Tricks and Advice from the SQL Server Query Processing Team
Gert Drapers' blog
"Data Dude" Development Manager
PSS SQL Server Engineers' blog
Microsoft Certified Masters program blog
RBarryYoung's blog (movingsql.com)
News
Keith Olbermann
How Mark Felt Fooled The FBI
Music
Little Feat
Planet Earth's House Band
Warren Zevon
an American original
Jordan Zevon
Warren's progeny; a singular talent in his own right
Wolfgang's Vault
Forty years of Bill Graham concerts streaming online!
Pat Metheny on Kenny G
The jazz guitarist editorializes, employing several of George Carlin's seven words in the process
Published Articles
XML To The Max: Get More Power Out Of Your SQL Server
a primer on XML manipulation in SQL Server 2000
XML Programming In SQL Server 2005
a primer on XML manipulation in SQL Server 2005
Other Publications
SQL Q&A - Technet Magazine, Winter 2005
SQL Q&A - Technet Magazine, October 2006
SQL Q&A - Technet Magazine, January 2007
SQL Q&A - Technet Magazine, February 2007
SQL Q&A - Technet Magazine, August 2007
Panel Discussions
SQL PASS 2006: The Growing World of SQL Server: Surviving the Data Avalanche (Nov. 19)
A Bit More From Me
Ward Pond's TechEd Developers 2008 Resource Page
slide decks and demonstration scripts from my TechEd Developers 2008 presentations
The Pond's Laws Home Page
a compendium of the Pond's Laws posts
WardPond.net
my personal web page
zPond's Ponderings
my personal blog (pardon the extraneous character, but these items are alpha sorted)
Search Blogs
Tags
Baseball
Business Intelligence
Career
Charitable Works
Conferences
Contests
DWWTWT?
Home Office
News
Optional Parameters
Personal Technology
Pond's Laws
Prime Numbers
Programming Methodology
Quality
Set-Based Thinking
Software Release Announcements
SQL Server 2000
SQL Server 2005
SQL Server 2008
TechEd Developers 2008
Technical Content
Vista
Windows 7
XML
Archive
Archives
October 2010
(1)
September 2010
(2)
August 2010
(1)
July 2010
(1)
June 2010
(3)
February 2010
(1)
January 2010
(2)
December 2009
(2)
November 2009
(2)
October 2009
(11)
September 2009
(12)
August 2009
(7)
July 2009
(9)
June 2009
(12)
May 2009
(7)
April 2009
(17)
March 2009
(14)
February 2009
(18)
January 2009
(15)
December 2008
(17)
November 2008
(18)
October 2008
(11)
September 2008
(18)
August 2008
(6)
July 2008
(5)
June 2008
(9)
May 2008
(20)
April 2008
(25)
March 2008
(33)
February 2008
(21)
January 2008
(8)
December 2007
(18)
November 2007
(25)
October 2007
(17)
September 2007
(6)
August 2007
(24)
July 2007
(20)
June 2007
(22)
May 2007
(16)
April 2007
(12)
March 2007
(18)
February 2007
(24)
January 2007
(21)
December 2006
(25)
November 2006
(46)
October 2006
(34)
September 2006
(39)
August 2006
(40)
July 2006
(35)
June 2006
(26)
May 2006
(4)
April 2006
(10)
March 2006
(7)
February 2006
(7)
December 2005
(1)
November 2005
(3)
October 2005
(4)
September 2005
(3)
August 2005
(2)
July 2005
(4)
June 2005
(2)
July, 2006
TechNet Blogs
>
Ward Pond's SQL Server blog
>
July, 2006
Posts
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Ward Pond's SQL Server blog
New SQL Server 2005 Books OnLine Available For Download
Posted
over 7 years ago
by
WardPond
1
Comments
The July, 2006 update to SQL Server 2005 Books OnLine is available here . At the moment, the new version is available only in English. Here's a summary of what's covered: New Conceptual and Task Topics Breaking Changes to Integration Services...
Ward Pond's SQL Server blog
Pond's Seventh Law, Applied: Avoiding Random Elegance
Posted
over 7 years ago
by
WardPond
4
Comments
Another application of Pond's Laws comes to light from an exchange on an internal SQL Server discussion list. My good friend and colleague John Huschka, a Senior Software Development Engineer for Microsoft Business Solutions' FRx Software Corporation...
Ward Pond's SQL Server blog
Database Programming: Temp Tables or Table Variables?
Posted
over 7 years ago
by
WardPond
9
Comments
On the occasion of this blog's one hundredth post, I thought I'd pass along some information I recently discussed with my youngest cousin, Tom, who is like me an otherwise rational person who's been bitten by the database development bug. In a conversation...
Ward Pond's SQL Server blog
Pond’s Eleventh Law Emerges From Reflection Upon The Perils Of Going Fast
Posted
over 7 years ago
by
WardPond
1
Comments
When I first published Pond’s Laws, I promised it would be a living document. Herewith is the first evidence....
Ward Pond's SQL Server blog
Non-Technical Content: Home From Moses Lake A Day Early
Posted
over 7 years ago
by
WardPond
1
Comments
My final dispatch re: the Northern Washington Babe Ruth 13U Tournament (edited on 18 July to include final result) : The game against Central Kitsap didn't fall the Raiders' way. They fell to a 7-0 deficit after two innings and rallied to within 9...
Ward Pond's SQL Server blog
Non-Technical Content: Redmond Raiders Win Thriller
Posted
over 7 years ago
by
WardPond
0
Comments
Another dispatch from the Northern Washington Babe Ruth 13U Tournament.. Last night, the Redmond Raiders came back from a 4-1 deficit to defeat the host team, the Moses Lake Desert Dogs, 7-4. The boys scored three runs in the fifth to tie the game...
Ward Pond's SQL Server blog
Non-Technical Content: Raiders Now 1-1 In Tournament Play
Posted
over 7 years ago
by
WardPond
0
Comments
Today's action in the Northern Washington Babe Ruth Tournament saw our Redmond Raiders fall to the Ellensburg Pounders, 12-5. The boys were up 3-0 after the top of the first inning, but the Pounders responded with five runs of their own in the bottom...
Ward Pond's SQL Server blog
Optional Parameters: Adam Hopes I'm Joking, But The Joke's On Me
Posted
over 7 years ago
by
WardPond
5
Comments
This is absolutely my last gasp on optional parameters. Adam Machanic left some syntax in a comment here which shows just how far off base my "last gasp" in this post was. My syntax produced 594 logical reads to resolve a query while the equivalent...
Ward Pond's SQL Server blog
Non-Technical Content: Redmond Raiders Win First Game
Posted
over 7 years ago
by
WardPond
0
Comments
Frequent visitors to this space will recall that I'm spending the rest of this week in Moses Lake, WA, watching my son Kyle play in the Northern Washington Babe Ruth Baseball 13U Tournament. This afternoon, Kyle's Redmond Raiders played their first...
Ward Pond's SQL Server blog
Database Programming: One Last Gasp On Optional Parameters
Posted
over 7 years ago
by
WardPond
6
Comments
July 12 update: Everything that follows is WRONG . See Adam's comment and my follow-up . You might think I'm obsessing over this, and you may well be right, but I wanted to make one more comment about handling optional parameters. The issue with...
Ward Pond's SQL Server blog
Technical News: The Develop Without Borders Contest
Posted
over 7 years ago
by
WardPond
2
Comments
Word of another great programming contest has made its way to my inbox. Sponsored by Microsoft and HP , it’s called the Develop Without Borders Challenge and it encourages developers and architects to submit a solution design that helps a non-profit...
Ward Pond's SQL Server blog
Database Programming: No Better Options For Optional Parameters
Posted
over 7 years ago
by
WardPond
0
Comments
Well, the current leg of the great "optional parameter code-off" has been completed. You definitely want to party with me on a national holday. :) Previous posts in this thread (many filled with questionable advice, as least that coming from me) may be...
Ward Pond's SQL Server blog
Redmond Raiders Update: Moses Lake, Here They Come!
Posted
over 7 years ago
by
WardPond
0
Comments
A brief update for those of you interested in Babe Ruth basball: Kyle's team, the Redmond Raiders, won the District 3 All-Star Tournament, sweeping three games without a loss. The team will be the 3A representative to the state tournament, which starts...
Ward Pond's SQL Server blog
Database Programming: Nearing Capitulation On Optional Parameters
Posted
over 7 years ago
by
WardPond
1
Comments
Adam and Tony both left comments indicating that either flavor of my proposed optional parameter syntax will result in a table scan, and that performance will (to appropriate Tony's characterization) suck. That's quite correct. There's one more syntax...
Page 1 of 1 (14 items)