Choosing a processor for SQL Server starts with the license, because SQL Server is licensed per core and the cores you buy decide the bill. This post reads what the server reports, counts the cores that matter, and explains the edition limits and the per-core speed trade. It ends with a way to size cores from measured CPU use.
SQL SERVER – Stream Aggregate and Hash Aggregate
Recently during the on-demand consultation, I was asked a very interesting question about Stream Aggregate and Hash Aggregate.
How to Measure Resource Status on Azure? – Interview Question of the Week #264
Every single time when I start working with Azure, I always want to know what is the status of Azure resource status or consumption in the last hour.
MySQL – Download Sample Database – Sakila, World, Employee
Get MySQL sample databases Sakila, World, and Employees. Follow Windows install steps, verify each import, and choose the right dataset.
SQL SERVER – SSMS Install Error 0x80070652 – Setup is Blocked Due to Another Install Currently running. Please Let the Other Install Complete and then Restart the Computer if Necessary
SSMS install error 0x80070652 says setup is blocked due to another install currently running. Here is what fixed it for me.
Index Design Rules: Ten Don’ts and Where They Break
These index design rules came from a client’s list of ten index don’ts, and readers argued with several of them. This post turns the checkable rules into read-only queries on a demo database, and it measures what each rule really costs. The rest are warnings, not laws, and the post says which is which.
DISABLE_PARAMETER_SNIFFING Hint: Turn Off Sniffing for One Query
The DISABLE_PARAMETER_SNIFFING hint makes one query ignore the parameter value it was first compiled for. This post compares it with the default, OPTIMIZE FOR UNKNOWN and RECOMPILE on a table where one customer owns 40 percent of the rows. The reads show which variant fits which workload.