Browse by Tags

Tagged Content List
  • Blog Post: SQL Databases on File Shares - It's time to reconsider the scenario.

    For those who have been around databases for any length of time, the idea of putting a database that you care about from either a reliability or performance perspective on an (SMB – Server Message Block) file share seems like a crazy idea, but recent developments have made SMB-based file shares...
  • Blog Post: CHECKSUM and Tempdb

    You may recall that starting with SQL Server 2005, you have an option available to enable CHECKSUM on the user databases. For details, please refer to http://blogs.msdn.com/sqlserverstorageengine/archive/2006/06/29/Enabling-CHECKSUM-in-SQL2005.aspx . In fact, any new database created in SQL2005 has CHECKSUM...
  • Blog Post: ok - really the last blog post - Mondays, Mystic, and a Museum

    My new blog's not active until September 1st but I wanted to blog about something cool - and totally unrelated to work. Over the weekend Kimberly and I were in Connecticut for the birthday party pig-roast for Carl Franklin (of DotNetRocks fame) along with our good friends Richard Campbell - also from...
  • Blog Post: Splits and unions...

    Hey folks, This is my last blog post on the SQL Server Storage Engine blog as I've made the decision to leave Microsoft and join Kimberly running her company, SQLskills.com. This lets me indulge my passion for teaching and consulting full-time and lets me work with my best friend. My last day at Microsoft...
  • Blog Post: Would you like to join the Storage Engine PM team?

    We have some job openings on the Storage Engine Program Management team - if you're looking for a great career opportunity helping to drive the product you love using, check them out. What does a Program Manager do? This blog entry by Steven Sinofsky (one of our Senior VPs) sums it up nicely. Here...
  • Blog Post: What's the difference between database version and database compatibility level?

    I had a question this week from someone who'd heard me say at SQL Connections (paraphrasing) "database compatibility level is mostly about query parsing" and was having trouble trying to forcibly attach a 2005 or 7.0 database to a 2000 server. His confusion is between database compatibility level...
  • Blog Post: SP2 Maintenance Plan bugs fixed

    From the tools team here in Redmond: We recently posted updates to address an issue in two SP2 Maintenance Plan tasks. The KB article describes the symptoms as follows: FIX: The Check Database Integrity task and the Execute T-SQL Statement task in a maintenance plan may lose database context in certain...
  • Blog Post: New whitepaper on Online Indexing Operations

    A great new whitepaper has just been published on TechNet - Online Indexing Operation in SQL Server 2005 . It gives a detailed explanation of the online index build process plus guidelines and best practices for implementing online indexing in production. Well worth reading. While I'm on the subject...
  • Blog Post: Can you INCLUDE columns of type TEXT, NTEXT, or IMAGE?

    I was sent a question today that seems like it could be something that many people get confused about – why can’t an NTEXT column be specified in the INCLUDE list of a CREATE INDEX statement in SQL 2005? (In one of my internals posts from last year there’s a long explanation of included columns...
  • Blog Post: How to create fake statistics for testing query plans

    This is very cool - an undocumented option to UPDATE STATISTICS that allows you to fool the server into thinking a table has more rows or pages than it actually has - very useful for testing. See this blog post on the old Query Optimizer team blog. Thanks to Tony Rogerson for pointing it out.
  • Blog Post: Sometimes life throws you a curve-ball...

    Many apologies to those who were hoping to see my presentation on corruption detection and recovery at SQL Server Open World in Denmark last week. An emergency came up after the class Kimberly and I taught in England and we ended up flying a *lot* further than we'd planned - basically all the rest of...
  • Blog Post: CHECKDB, User Groups and .NET Rocks!

    A few things to cover with the first cup of coffee this morning before doing a meatier post or two later today. First off - I've had a bunch of good responses to my CHECKDB runtime survey and I've got data on 66 databases ranging from 10.5GB up to 2.8TB. I'd like to get some more responses, and I...
  • Blog Post: SQL Server 2005 Best Practices Analyzer CTP released

    Folks, The much-anticipated SQL Server 2005 Best Practices Analyzer has been released for on the Microsoft Download Center. There are a ton of things in there, including some checks around backup and CHECKDB frequency. SQL Server 2005 Best Practices Analyzer (February 2007 CTP): http://www.microsoft...
  • Blog Post: Wow - over 40 blogs from the SQL Product Team

    Seeing the new blog from the doc team inspired me to ping the extended SQL team to see what active blogs there are. Here's the list I've compiled of active (or "I'm working on content right now") blogs run by members of the SQL team - grouped by area and in no particular order. Lots of cool stuff here...
  • Blog Post: How is Books Online put together?

    One of the Technical Writers in the SQL Product Group, Buck Woody, has started a blog about SQL documentation. His first post is an overview of how Books Online is created. Check it out at http://blogs.msdn.com/buckwoody/archive/2007/02/14/sql-server-books-online.aspx .
  • Blog Post: How to move databases using detach/attach functions?

    Quickie post this morning. I was in a review of customer support cases yesterday lunchtime and noticed a trend of cases where people get into trouble moving databases around. There is a good KB article ( http://support.microsoft.com/kb/224071/ ) which explains how to do this for user databases, master...
Page 1 of 1 (16 items)