Apply SQL best practices through ten reasoned rules for data meaning, predicates, parameters, indexes, ordering, and workload measurement.
PowerShell: How to Find Logical and Physical Processors on SQL Server?
With core based licensing, a DBA friend asked how to count cores. Here is a PowerShell script using WMI to find logical and physical processors on SQL Server.
SQL SERVER – Puzzle – DISTINCT Values in NVARCHAR
Why does SELECT DISTINCT treat ‘ß’ and ‘SS’ differently under each collation? A short puzzle on DISTINCT values in NVARCHAR, born from an SSIS unique key error.
SQL SERVER – Enhancing Reference Data in Master Data Services – Notes from the Field #089
Reeves Smith shows enhancing reference data in Master Data Services, building on data he added earlier with the MDS add-in for Excel.
SQL SERVER – Process ID X was killed by hostname ABC, host process ID Y
Seen the ERRORLOG message that a process ID was killed by hostname, with a host process ID? I explain each placeholder in error 18100 and what it tells you.
SQL SERVER – Querying Performance Counters from SQL Server
When SQL Server is slow, where do you start? I look at querying performance counters from inside SQL Server as a quick way to see what is going on.
SQL SERVER – How to Change Server Name?
I renamed my VM and needed SQL Server to match. Here is a query that shows the host and server names from every source, and how to change server name.