Community

Community

Using TABLE Variables

Table variables are just plain cool. If you’re using temporary tables and don’t need transactions on those tables and want better performance I’d strongly consider using table variables instead. Table variables were introduced in SQL Server 2000. You create a table variable the same way you c

Community

SQL Server & XML integration

By Jonathan Lurie & Timothy Stockstill – Microsoft was initially slow to develop an Internet product. I recently read a quote from a ranking Microsoft employee who said, “If you cut us, we bleed XML.” While this may seem a little dramatic, it happens to be true: XML seems to be everywhere in Microso

Community

Comparative Jabber book review

John Zukowski – Jabber is an open, XML-based protocol you can use to add instant messaging to your applications. If you're interested in learning about Jabber but aren't quite sure where to begin, here's a review of three books on the subject to help you get off to the right start.

Community

Pull Parsing in C# and Java

by Niel Bornstein – In my first article in this series, I wrote about porting a SAX application called RSSReader to the new Microsoft .NET Framework XmlReader. After publication, I received a message from Chris Lovett of Microsoft suggesting I revisit the subject. As he said, while the code I presen