I understand that there is no one way to describe the CPUs and that is the primary reason, why I get a different answer when I try to get CPU details.
Shutdown SQL Server Via T-SQL – SQL in Sixty Seconds #163
I often see the command SHUTDOWN underutilized when it is about turning SQL Server services gracefully. Let us learn about it today.
SQL Server on Linux – SQL in Sixty Seconds #162
I wrote a blog post SQL SERVER on Linux – Commands, lots of people asked me that I should create a video about it as not everyone has Linux.
SQL SERVER on Linux – Version Specific Installation References and Commands
SQL Server on Linux installation requires instructions matched to the exact supported releases. My older customer checklist concerned Ubuntu.
Query Ignoring CPU Threads – SQL in Sixty Seconds #161
I have an interesting experience to share about the Query Ignoring CPU Threads. I was hired by a large eCommerce organization.
OS Threads by Scheduler in SQL Server: Count Them per CPU
OS threads by scheduler shows how many Windows threads each SQL Server scheduler owns. This post joins the scheduler, worker and thread views and counts them per CPU. It compares the counts with the server totals and explains the hidden schedulers that a careless query counts as CPUs.
Convert Empty String to NULL Date in SQL Server: Use NULLIF
To convert empty string to NULL in a date column, wrap the text in NULLIF before you cast it. A plain CAST returns 1900-01-01 and hides the problem. This post tests five expressions on six text values, including a real 1900 date, a run of spaces and a tab, and shows which ones stay correct.