The Scenario: You just restored a production database on a development server. You’ve told the developers that it’s restored, and you start to relax in your chair. 30 milli-seconds later, your phone is ringing… the developers can’t connect to the database that you just restored. You check the server, and the login exists. You check [...]
Book List
Planned books:
- SQL Server 2008 Query Performance Tuning Distilled (Expert’s Voice in SQL Server) by Grant Fritchey, Sajal Dam
- The Red Gate Guide to SQL Server Team-based Development by Mladen Prajdic, Grant Fritchey, Alex Kuznetsov
- Troubleshooting SQL Server – A Guide for the Accidental DBA by Jonathan Kehayias, Ted Krueger
Current books:
-
Microsoft® SQL Server® 2008 Internals (Pro – Developer) by Kalen Delaney, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Adam Machanic
Recent books:
- Threat Vector by Tom Clancy, Mark Greaney
- Poseidon’s Arrow (Dirk Pitt Adventure) by Clive Cussler, Dirk Cussler
- The Tristan Betrayal by Robert Ludlum
- The Race (An Isaac Bell Adventure) by Clive Cussler
- SQL Server MVP Deep Dives Vol. 2 by Unknown
Browsing Posts in Script
SQL Server 2012 introduces several new date/time functions that allow you to build a date/time from the individual parts of a date/time value. As I was experimenting with them, I was thinking that this is pretty neat, and bound to be very useful. And then I started wondering how well it performed. Before I had [...]
One thing that I have seen repeatedly is that (too) many people believe that if you have a clustered index on a table, that you can run a SELECT statement without an ORDER BY clause from that table and the results will be in the order of the clustered index key. Nope, this is absolutely [...]
