Updated SSMS Shortcut Key file
I’ve updated the SQL Server “Denali” settings file to include the CTRL+E and CTRL+X hot keys. You can find the new file in the same location as the old one so you only need to download it once. Denny
Resetting SSMS shortcut keys in SQL Server “Denali” CTP 3
If you did what I did when you installed CTP 3 of SQL Server “Denali” (which happened when I uninstalled CTP 1 then installed CTP 3) you’ll be in for a rude surprise, a lot of your shortcut keys that you’ve been using for years don’t work any more. This is to say the least […]
Database %d was shutdown due to error 9002 in routine ‘HeapPageRef::Update’.
So I hit the error in the title the other night while converting a heap to a clustered index on a production system. After this error poped up, some other nasty stuff showed up in the error log, which I’ve included below. Error: 9002, Severity: 17, State: 4. The transaction log for database ‘%d’ is […]
Transaction log growth best practices
There is a lot of talk online about transaction log growth and what you should do. There are two answers to this question, and in this post I’ll give you both answers. The theoretical answer is that you want to grow your transaction logs in 8 gig chunks. This will maximize the amount of space […]