Question: How to Measure Transactions Per Seconds in SQL Server?
I have updated the script for this for Comprehensive Database Performance Health Check.
SQL Job Schedules: Read Every Schedule in Plain English
SQL job schedules are stored as codes, and even the built-in description shows a time such as 60000. This post builds four demo jobs with five schedules and decodes every one with a single query. It also shows shared schedules, disabled schedules and jobs with no schedule at all.
List All Jobs With Owners in SQL Server Agent
To list all jobs with owners, read the job table in msdb and resolve each owner with a join that keeps jobs without a login. This post builds four demo jobs, shows how a common query hides one of them, and reassigns jobs safely. It ends with a cleanup script.
TempDB Metadata Tables: Check, Enable and Count Them
The tempdb metadata tables can live in memory, and four short steps tell you whether yours do. This post checks the setting, shows how to turn it on and off, and counts the tables SQL Server moves. It also says when the feature is worth a restart.
Additional Logging for SQL Server Agent: Three Methods
Additional logging for SQL Server Agent means raising the Agent error log level, so the Agent writes more lines about its own work. This post reads the current level, changes it with T-SQL and restores it in the same script, and shows the Management Studio and registry routes.
Display Rupee Symbol in SSMS and T-SQL With FORMAT
To display rupee symbol and Indian digit grouping in SSMS, format the number with an Indian culture, or use the Unicode character 8377. This post compares en-IN, hi-IN, gu-IN and kn-IN, shows the nvarchar rule that keeps the symbol from turning into a question mark, and formats dates for the same cultures.
What are Different Methods to Know the Row Count of Table? – Interview Question of the Week #261
Question: What are Different Methods to Know the Row Count of Table? The answer to this question is very simple and many.