SQL Consulting: SQL Server Is Our Only Business.
posted on
I have answered that question many times. I think the reason I hear it so much is that ‘Large’ sounds better than ‘small’ and my questioner assumes that Larger Pages might improve performance on their …
Continue Reading about Should You Enable Large Pages on Your SQL Server? →
posted on
It has been a long time since Microsoft put the INCLUDE option into the Create Index command. Still I find that many developers and even DBA's don't use it much or not at all. I find that some don't …
Continue Reading about Using the INCLUDE Operator For Better Indexes →
posted on
Judging from my email and phone calls, almost every SQL DBA wants to be an independent SQL consultant. However they do not want to give up the security of their 9 to 5 job. Because I made that …
posted on
Back in March my monthly newsletter was about parameter sniffing, exploring why a specific query might execute quickly in one case and very slowly in another case. This month I would like to drill …
posted on
In its quest to sell SQL Server as a database that can be installed and maintained by someone who is completely untrained, Microsoft has added some questionable functionality to SQL Server over the …
posted on
While I was searching for a subject for this month's newsletter the phone rang. A client was having a problem that sounded very much like bad parameter sniffing and that is what it turned out to be. …
Continue Reading about When Good Parameter Sniffing Goes Bad →