Subscribe to this blog
Archives: June 2012
Is SELECT Identity() … INTO Minimally Logged in Simple Recovery?
Is SELECT Identity() … INTO Minimally Logged in Simple Recovery?
I was having a discussion with Idera (@idera_software) dev lead Vicky Harp (blog|@vickyharp) about minimizing log impact when performing schema changes on really large tables. One option discussed was using SELECT INTO Read more
3 comments, 675 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 30 June 2012
Troubleshooting Database Mirroring Error 1418 Updated
Troubleshooting Database Mirroring Error 1418 Updated
Last night I was helping someone with a database mirroring setup problem via email. It has been a long time since I came across a new cause for the infamous 1418 error for database mirroring. This time the error was accompanied by an error… Read more
0 comments, 1,269 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 28 June 2012
5 Second Rule Doesn’t Apply to Dropped Databases or Does It?
5 Second Rule Doesn’t Apply to Dropped Databases or Does It?
Imagine you get a frantic call from someone, we’ll call him George, who just dropped a busy production database, and if he can’t get it back up ASAP,… Read more
1 comments, 3,097 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 22 June 2012
T-SQL Tuesday #31 – Bulk-Logged Recovery Model and Point-in-time Restore
T-SQL Tuesday #31 – Bulk-Logged Recovery Model and Point-in-time Restore
This blog entry is participating in T-SQL Tuesday #31, hosted this month by Aaron Nelson (Blog|@SQLVariant). You are invited to visit his blog to join the blog party. You are welcome to write your own… Read more
0 comments, 879 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 12 June 2012