New SQL Express Starter Kit and Sample Apps available on MSDN

Collection Manager Starter Kit Overview The Collection Manager is a rich client application that enables you to create and manage any type of collection. A sample database is included, and you can create any additional number of custom collection types to store unique characteristics about each collection. Internet Explorer Favorites Sample Application Overview Use… Read more

CHECKDB (Part 1): How does CHECKDB get a consistent view of the database?

As you can guess from the title, I’m planning a long series over the summer to go into the guts of how CHECKDB works (both the consistency checks part and the repair part). And as you can guess from ‘CHECKDB’, I’m already bored with putting DBCC in front of it all the time and changing… Read more

Importing UNIX data file

  When bulk importing data, the data can come from any source including the files created in other operating systems like UNIX. Here are two ways that you can use to bulk import a data file created under UNIX.   ·         Without using a format file You can use the following script to bulk load…. Read more

Diagnosing 17883, 17884, 17887, 17888 errors

Have you ever seen an error like: Process 51:0 (dbc) UMS Context 0x018DA930 appears to be non-yielding on Scheduler 0. Or in SQL Server 2005: Process 51:0:0 (0xdbc) Worker 0x036BA0E8 appears to be non-yielding on Scheduler 1. Thread creation time: 12764721496978. Approx Thread CPU Used: kernel 15 ms, user 171 ms. Process Utilization 0%. System… Read more

Common bad advice around disaster recovery

I’ve just been itching to post this one. I’m doing a chalk-talk (AKA cabana session, this year AKA Technical Learning Centre session) at TechEd next Wednesday (8.30am 6/14) called ‘DBCC CHECKDB: Magic, Monsters, and Myths’. A lot of the material in this will be included in the mega-whitepaper on DBCC I’ll be writing over the summer, but… Read more

Repair vs Restore Dilemma

For some reason The Clash’s ‘Should I Stay or Should I Go?’ has been going round in my head today – ‘Should I RE-pair or restore? Nah nah NA-na nana nah’ – must be something to do with Redmond’s good weather. Anyway, I get asked for help with this a lot – more so it seems… Read more

How to recreate the msdb database in SQL Server 2005?

I’ve just spent a bunch time researching an answer to this question on the new disaster recovery forum because I couldn’t find any definitive info on how to do this in SQL Server 2005. I pieced together a method to do this on previous releases of SQL Server and tried it on one of the SQL Server 2005 instances… Read more

Are you coming to TechEd? We’d like to see you there!

Just over half the Storage Engine PM team will be at TechEd June 11-17. Attending will be: Sunil Agarwal – Access Methods PM specializing in locking, concurrency, bulk load, snapshot isolation, performance troubleshooting Kevin Farlee – Transaction Services PM specializing in backup/restore, storage solutions, Scalable Shared Databases Mark Wistrom – Transaction Services PM specializing in Database… Read more

New MSDN forum on Disaster Recovery and Availability

It’s quite evident now that there’s a growing need for a focused forum around disaster recovery and availability so I’m pleased to announce that we’ve created one ( I’ve brought together the experts in the Storage Engine on: DBCC usage and strategy CHECKDB results interpretation backup/restore usage and strategy diagnosing and recovering from hardware issues planning/executing a… Read more

Troubleshooting deadlocks in SQL2005

Deadlock in the context of SQL Server means two or more transactions or tasks are waiting on each other to acquire the resources needed to complete. A resource can be a logical lock or can be memory grant or can be a worker thread and so on.   Normally, when a transaction T1 requests a… Read more