How do you find the Service Account for SQL Server and SQL Server Agent? Here are three ways: Configuration Manager, services.msc, and a T-SQL query.
How Much Work Each Processor (CPU) is Doing in SQL Server? – Interview Question of the Week #178
A client with 56 processors saw CPU always high and wanted to know how busy each one was. Here is a simple DMV query that shows work per Processor (CPU).
How to Find Cardinality or Uniqueness for any Column? – Interview Question of the Week #177
What is Cardinality, and how do you find it for a column? This simple script shows the percentage of unique values, using an AdventureWorks table.
How to Enable Files & Folders Level Auditing in SQL Server? – Interview Question of the Week #176
Files kept vanishing from a client’s SQL Server Binn folder. SQL Server cannot track that, so here is how to enable Files and Folders Level Auditing in Windows.
How to Write Errors in Error Log? – Interview Question of the Week #175
How to write errors in Error Log? A customer asked this in my performance tuning workshop, and here is how to add your own messages to the SQL Server log.
How to Generate Fibonacci Series for the First 1000 Values? – Interview Question of the Week #174
How to generate Fibonacci series for the first 1000 values? Most answers online stop near 70 or 80 values because the numbers get too big. Here is mine.
How to Find Last Full Backup Time and Size for Database? – Interview Question of the Week #173
Too many DBAs I meet have no recent backup. Here is a script that shows when each database had its last Full Backup and how big that backup was.