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)
TechNet Blogs
>
Ward Pond's SQL Server blog
Posts
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Ward Pond's SQL Server blog
The OPENROWSET Trick: Accessing Stored Procedure Output In A SELECT Statement
Posted
over 8 years ago
by
WardPond
19
Comments
Updated 20 Mar 2009: This code is revisited here . This nifty little trick will allow you, with some limitations, to treat the output of a stored procedure as a named SQL record set rather than creating a table and going through an INSERT.. EXEC process...
Ward Pond's SQL Server blog
IF EXISTS (SELECT..) vs. IF (SELECT COUNT(1)..) > 0
Posted
over 6 years ago
by
WardPond
7
Comments
Consider this a coding tip for SQL Server 2000 (as well as a reason to upgrade), and kudos for the SQL Server 2005 development team. In SQL Server 2000, IF (SELECT COUNT(1)..) > 0 will process an entire table or index to complete the count, while...
Ward Pond's SQL Server blog
SQL Server 2005 September CTP Available Now!
Posted
over 8 years ago
by
WardPond
0
Comments
Here's a nice little query on the Microsoft download site that will give you quick links to most all of the essential components of the latest Community Technology Preview edition of SQL Server 2005. Even if you can't install the software (and you should...
Ward Pond's SQL Server blog
Database Programming: Slaying The Time Zone Conversion Beast (or at least rendering it comatose)
Posted
over 7 years ago
by
WardPond
16
Comments
Schema and code for performing time zone conversions is discussed....
Ward Pond's SQL Server blog
T-SQL Update Operations: An Answer For Jared
Posted
over 7 years ago
by
WardPond
4
Comments
SQL Server update processing is discussed in response to a question from a reader....
Ward Pond's SQL Server blog
SQL Server 2005 XQuery Performance Tips
Posted
over 8 years ago
by
WardPond
3
Comments
During some recent Xquery performance work, three discoveries emerged which dramatically improved the performance of my team's component. I'd like to share them here.. Specify A Single Root Node The XML parser in SQL2K5 doesn't assume that the XML...
Ward Pond's SQL Server blog
A Solution For Stripping Invalid XML Characters From varchar/text Data Structures
Posted
over 8 years ago
by
WardPond
6
Comments
One of the more subtle aspects of converting (n)varchar or (n)text data to XML is the fact that XML is choosy about which characters are permitted and (n)/varchar/(n)text is not. Any T-SQL programmer who runs conversions of this type is likely to run...
Ward Pond's SQL Server blog
SQL PASS 2006, Day 2
Posted
over 7 years ago
by
WardPond
0
Comments
Greetings from the last break of the second day of preconference seminars from SQL PASS 2006 . Since my primary goal in attending this week is to get up to speed on BI issues, today I'm attending a seminar called, "Enterprise ETL with Integration Services...
Ward Pond's SQL Server blog
Database Programming: User-Defined Functions And Linked Server Connections
Posted
over 7 years ago
by
WardPond
3
Comments
A limitation of the use of user-defined functions over linked server connections, and a work-around, are discussed....
Ward Pond's SQL Server blog
Loading An XML Document Into SQL Server: Another OPENROWSET Trick
Posted
over 7 years ago
by
WardPond
6
Comments
A quick-and-dirty solution for importing file-based XML documents into SQL Server tables is discussed....
Ward Pond's SQL Server blog
93,000 Concurrent SAP Users In A Free Download?!
Posted
over 8 years ago
by
WardPond
1
Comments
No, you can’t run 93,000 concurrent SAP users on SQL Server Express (you’ll need SQL Server Enterprise Edition and some pretty decent server iron to do that), but you will be able to access up to 4gB of database space and 1gB of RAM – in a free download!...
Ward Pond's SQL Server blog
Database Programming: Set-Based Update -- Hugo's Syntax Outperforms Shaun's; Ward Tweaks Hugo's Syntax Even Further
Posted
over 7 years ago
by
WardPond
6
Comments
A long post continuing last night's discussion regarding the generation of 1M GUIDs. I'm not sure I'd download this one to your PDA......
Ward Pond's SQL Server blog
Database Programming: Everything You Always Wanted To Know About JOIN Semantics, But Were Afraid To Ask
Posted
over 7 years ago
by
WardPond
1
Comments
Every once in awhile, I get an opportunity to look around for new and interesting things to read. With the emphasis my new position places on building world-class training resources for SQL Server types, I'll be spending even more time on this sort of...
Ward Pond's SQL Server blog
Database Programming: One More Point On Recompilations and Temp Tables
Posted
over 7 years ago
by
WardPond
2
Comments
Scott Whigham left a very generous comment on my last post on recompilations and temp tables. Within that comment he made an excellent observation that I don't want you to miss: One thing you might mention with respect to using temp tables and/or...
Ward Pond's SQL Server blog
Field of Dreams: Better Living through Youth Baseball
Posted
over 7 years ago
by
WardPond
5
Comments
Databases are important. Databases pay my bills, and presumably those of many of you reading this blog. But there are more important things in life than databases. I’d like to tell you a short story of how faith and perseverance can move mountains. I...
Ward Pond's SQL Server blog
Database Programming: Applying APPLY -- Solving Parent Axis Access Performance Issues In XML Access In SQL Server 2005
Posted
over 7 years ago
by
WardPond
7
Comments
"Parent axis access", a long-standing performance bottleneck in accessing data stored within XML, is addressed via use of SQL Server 2005's new CROSS APPLY operator....
Ward Pond's SQL Server blog
Database Programming: Game, Set, Match -- Why Writing Code In Transact-SQL Is Different Than Writing In A Compiled Language
Posted
over 7 years ago
by
WardPond
4
Comments
More tidbits from an internal discussion.. it'll take us awhile to get to the answer to the titular question; hopefully you'll find this a worthy journey. Mike asked, in a nutshell, why this batch is taking so long to run: SET NOCOUNT ON DECLARE...
Ward Pond's SQL Server blog
Database Design: Do Not Fear NULLs
Posted
over 8 years ago
by
WardPond
9
Comments
A brief discourse on what NULLity means, how it works in the database, how to use it, and examples of its misuse....
Ward Pond's SQL Server blog
Database Programming: The OPENROWSET Trick, Revisited
Posted
over 4 years ago
by
WardPond
6
Comments
One of the most popular posts in the history of this little corner of the Internets is one from August, 2005, which describes a method for accessing stored procedure output in a SELECT statement which I’ve come to refer to as “ the OPENROWSET trick ....
Ward Pond's SQL Server blog
Database Programming: Denis' Prime Number Challenge: A New Leader
Posted
over 7 years ago
by
WardPond
12
Comments
Well, folks, there's a new sheriff in town.. this is a continuation of a conversation here and here . I've tweaked Hugo's syntax to further filter the initial seive population (similar to the pre-filtering present in the discredited tangent ). Where...
Ward Pond's SQL Server blog
Database Programming: Denis' Prime Number Challenge
Posted
over 7 years ago
by
WardPond
10
Comments
I answer Denis' challenge with another post to refrain from downloading to your mobile device....
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
Database Programming: (Almost) A Decrypter For Omni..
Posted
over 7 years ago
by
WardPond
2
Comments
Omnibuzz saw my comment (I left another one over the weekend and it showed up right away; I wonder if the ones I left previously were eaten by some flavor of the issue I ran into trying to leave a comment here) and left two comments . Omni's first...
Ward Pond's SQL Server blog
Database Programming: Buliding a FOR XML EXPLICIT Statement Containing Both an Element Value and an Attribute Associated With The Element
Posted
over 7 years ago
by
WardPond
5
Comments
Well, the title of this post is so long, I almost don't need to reconstruct Steve's question, but here it is.. I need to construct a FOR XML EXPLICIT statement that essentially produces something like < Product > < Category rank = "...
Ward Pond's SQL Server blog
Non-Technical News: A Brief Update On My Health
Posted
over 6 years ago
by
WardPond
3
Comments
Several folks have been kind enough to ask how I'm doing , so I thought I'd share a brief update. Feel free to pass on this post if it doesn't sustain your interest.. Corrective surgery was attempted on February 5th; unfortunately, the surgeon had...
Page 1 of 16 (394 items)
1
2
3
4
5
»