Data Compression before or after loading operations? [SQL Server]
Based on what we have experienced, it appears that its more efficient to just immediately insert into a compressed table, with a partitioned clustered index.
Read moreWho needs DBA Skills? [#TSQL2sDay]
DBA skills are not just a nice-to-have. It is a requirement. Do it right the first time and avoid the hassle of fixing in the future.
Read moreMy SQLPass Schedule [Training]
My SQLPass Schedule
Read moreIncorrect Bios Settings Can Reduce Database Performance [SQL Server]
It turned out that the issue was not Hyper Threading related, but a Bios misconfiguration instead.
Read moreCredit Card Statistics [Debt]
Convenience or credit? Or both? CreditCardProcessing.net
Read moreSD Card unexpectedly removed [Android]
Today while I was trying to take a picture of my son wearing his costume with my new HTC G2, got the error message “SD Card unexpectedly removed”.
Read moreEditing a Profile in MSDN Social Forums returns “Sorry, we were unable to service your request. Please try again later.” [MSDN]
I was unable to post a question, reply or even edit my profile for over a month. Microsoft support took[…]
Read moreSummarizing Performance issues and workarounds after migrating from 2005 to 2008 R2 [SQL Server]
We were able to tune the offending processes and go from 85% sustained CPU utilization to almost nil.
Read moreMost Developers Have No Business In The Database World
I have been around superb developers that understand the concept of approaching efficient code that needs to be ran on[…]
Read moreKerberos Double Hop and Delegation between different Active Directory Accounts [SQL Server]
In the past, when I had bare knowledge of Active Directory, I dealt with double hop queries using SQL Server[…]
Read more