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)
October, 2007
TechNet Blogs
>
Ward Pond's SQL Server blog
>
October, 2007
Posts
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Ward Pond's SQL Server blog
Update/Clarification: I Might Start To, Like, Like LIKE..
Posted
over 6 years ago
by
WardPond
1
Comments
.. but it's got to have a COLLATE with it. A couple of updates are necessary to my recent post on LIKE, PATINDEX, and COLLATE . A bit of this is covered in the comments to the original post, but I'd like to tie it all together and make sure that it...
Ward Pond's SQL Server blog
See You Even More In Barcelona: Two Additional Chalk Talk Sessions Added
Posted
over 6 years ago
by
WardPond
0
Comments
I'm pleased to report that the organizers of TechEd have scheduled repeat offerings of two of my sessions (so much for my earlier belief that the schedule was finalized *grin*): Set-Based Thinking for the T-SQL Developer: Insights from Microsoft...
Ward Pond's SQL Server blog
See You In Barcelona: Schedule Finalized For TechEd Developers 2007 Chalk Talks
Posted
over 6 years ago
by
WardPond
1
Comments
The PowerPoints are done. All of the demos save one are complete. A few days ago, the final pieces fell into place when the final schedule for TechEd Developers 2007. I'll be delivering the following "chalk talk" sessions: Set-Based Thinking...
Ward Pond's SQL Server blog
Database Programming: Why I, Like, May Never Write Another LIKE, Like, Ever Again
Posted
over 6 years ago
by
WardPond
5
Comments
[ UPDATE 30 October 2007 : There are significant ambiguities in this post which are addressed in the comments and in this follow-up , which I recommend reading after you've read this post and its comments. -wp] I've been doing some performance tuning...
Ward Pond's SQL Server blog
Lubor Offers a Wonderful Synopsis of Partitioning
Posted
over 6 years ago
by
WardPond
0
Comments
One of the best parts of my current job is that the email distribution lists I'm on allow me to be a "fly on the wall" for some very interesting, educational conversations. Terry started this one off by asking a question: I’ve heard it recommended...
Ward Pond's SQL Server blog
Microsoft TechEd Developers: New Session Added
Posted
over 6 years ago
by
WardPond
1
Comments
Late-breaking news related to my earlier announcement that I'm presenting at next month's TechEd Developers 2007 in Barcelona: It's my pleasure to announce that I'll be moderating a third session, largely demo-oriented, called Version-stamping of Database...
Ward Pond's SQL Server blog
There's More To GO Than Meets The Eye
Posted
over 6 years ago
by
WardPond
2
Comments
This little tidbit originated with Kalen Delaney , and was forwarded to me by Lance Larsen, a colleague here at Microsoft. I've verified that this works in all versions of SQL Server since SQL Server 2000 SP4. Here's Lance's note: I did...
Page 1 of 1 (7 items)