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)

Browse by Tags

Related Posts
  • Blog Post: Scott's Answer, Completed: Temp Tables and Recompiles In SQL Server 2005

    When I posted yesterday on this topic (first broached here ), I'd found some good information pertinent to SQL Server 2000 in Tom Davidson's MSDN article . However, at that point I hadn't had much luck finding the equivalent information for SQL Server 2005. I dropped an email to Tom, and he very helpfully...
  • Blog Post: SQL Server 2008 R2 August CTP Available for Download

    If you’re interested in the next release of SQL Server, the BI-focused SQL Server 2008 R2, you’ll be pleased to know that the August CTP is available for download here for MSDN and TechNet members. Here’s the skinny from the download page: SQL Server 2008 R2 expands on the value delivered in SQL Server...
  • Blog Post: An Update For Cousin Tom: Classroom Stories, Business Intelligence, and Career News

    Hey there cousin.. It’s been almost two months since we discussed data warehousing here. I apologize for the long delay since my last correspondence. It’s been a very busy time here; we’ve been preparing the first offering of our four-week SQL Server Microsoft Certified Architect OLTP/Ranger certification...
  • Blog Post: Data Warehousing: A Open Note To Cousin Tom

    Dear Tom, It's been almost three weeks since you wrote. I've been real busy with work and summer and everything, so I haven't had a chance until now to do the thinking I need to do to answer your questions. You do remember your questions, don't you? It's been that long? Okay.. My company...
  • Blog Post: Database Programming: Temp Tables or Table Variables?

    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 on the subject topic, Tom wrote: My concern...
  • Blog Post: New To SSIS? Come Take A Guided Tour..

    One of the more interesting and perhaps challenging aspects of a SQL Server 2000 to SQL Server 2005 upgrade is the migration from DTS to SSIS for ETL (Extract-Transform-Load) activities. SSIS isn't an upgrade of DTS, but is in fact an entirely new, and greatly enhanced, component. While it's possible...
  • Blog Post: The Start of An Answer For Scott: Temp Tables and Recompiles

    Kimberly Tripp, one of the most incredibly astute SQL poeple on the planet, calls her blog , "Improving *my* SQL skills through your questions". I would never steal her line, but after a bit of research on MSDN this afternoon, I can certainly relate to it, thanks to Scott Whigham of LearnSQLServer.com...