During Comprehensive Database Performance Health Check we always go over various SQL Server properties. Lots of people do not know that there are quite a few SQL Server settings which can help us improve our SQL Server performance many folds. While I was discussing SQL Server properties, someone asked me if there are similar settings for SQL Server Agent available which users can tune.
How to List All the SQL Server Jobs When Agent is Disabled? – Interview Question of the Week #171
Question: How to List All the SQL Server Jobs When Agent is Disabled?
How to Schedule a Job in SQL Server? – Interview Question of the Week #160
Question: How to Schedule a Job on SQL Server?
Answer: A very old and widespread question, keep on coming back to in interviews. Let us see how to schedule a job on SQL Server.
SQL SERVER – Express and SQL Server Agent – Free Alternative
“How come my database is only a few MBs big and I am facing performance problems?” My customer asked. I replied, “Well, this is because you are not running job using SQL Server Agent to keep your indexes in the best health.”
SQLAuthority News – Two Promotion to Help Community
In this difficult time of recession I have two promotion to share with SQL Server community. 1) Discount on Microsoft Exams and Free Second Retake Due to bad job market, the ratio to available jobs to available candidates is lower than usual. Microsoft exams are key to stand up in…
Read MoreSQLAuthority News – Help to Find Recession Proof Job
Recently I have been receiving a lot of emails from employees asking where they can find good employee. I was under impression that due to global recession job market is down but from looking at recent increase in emails for looking for right candidate I have to say that there…
Read More