I should know better than to throw myself into the SQL Server vs. Oracle religious war, but clients and potential clients often ask me the question Which is better, Oracle or SQL Server? I have to …
Sticker Shock
Microsoft Ups the Ante For Licensing SQL Server A couple of newsletters ago, I wrote nice things about the new features for Standard Edition in SQL Server 2014. In this issue I am writing mostly …
Free SQL Server Advice
It is often said that Free Advice is worth what you pay for it, but I hope that the answers I give to reader's questions have some value. I answer a lot of questions, but that should not be …
SQL Server 2014 for Standard Edition Users
Last month this newsletter described some of the most important benefits in SQL Server 2014 for Enterprise Edition users, notably Memory-Optimized OLTP, but complained once more about the dearth of …
Continue Reading about SQL Server 2014 for Standard Edition Users →
Tune SQL With Wait States
When your SQL Server is not performing as well as you would like, the fastest way to find out what's wrong is to look at the wait statistics available in the dynamic management …
Memory-Optimized Tables in SQL Server 2014
Ancient History In the first versions of SQL Server (4.21a through 6.5) there was a feature with the self-explanatory name "Tempdb in RAM". Due to the immature state of memory management in SQL …
Continue Reading about Memory-Optimized Tables in SQL Server 2014 →