The other day, I received an email asking – What does elastic scalability mean?
SQL Server – Configuration Manager Console Running Very Slow and Time Out
SQL Server Performance Tuning is my hobby, passion and a job. During my recent consulting engagement for Comprehensive Database Performance Health Check, I had to face a very interesting situation which I had never faced before. I personally take any consulting gig where SQL Server is running slow, it does not matter if it is Configuration Manager Console, Dynamics, NAV, SharePoint or any other application which runs SQL Server as a database.Â
SQL SERVER – Database Files Initial Size Changing Automatically
One of my clients reported an interesting issue and I was needed to wear detective cap to solve it. The mystery, for which they hired me was as below for Database Files Initial Size Changing Automatically.
SQL SERVER – SQL Agent Not Starting. The EventLog Service has Not Been Started
Many companies do hardening of servers to make sure they are protected from any known vulnerabilities. It is important to test all the application in test server before doing hardening. Let us learn about how to fix Eventlog Service not starting.Â
How to Show Results of sp_spaceused in a Single Result? – Interview Question of the Week #135
Question:Â How to Show Results of sp_spaceused in a Single Result?
Answer: When I hear this question from my co-interviewer, I objected. I think it is not a good interview question. I do not expect any of the candidates to remember any of the syntax. Remembering basic syntax should be a good idea, but it should not be the sole requirement of the hiring a good candidate. I believe I am a good DBA but trust me personally I do not remember all the syntax.
SQL SERVER – How to Clear Plan Cache with Database Scoped Configuration?
Question: How to Clear Plan Cache with Scoped Configuration?
SQL SERVER – Difference Between spid, kpid and ecid in sysprocesses
Question: What is the difference between spid, kpid and ecid in sysprocesses?
SQL SERVER – Database Scoped Configurations – Query Optimizer Fixes
During recent SQL Server Performance Tuning Practical Workshop I receive following question about Query Optimizer Fixes.
SQL Download – SQL Server Management Studio (SSMS) – Performance Dashboard
It has been quite a long time since I stopped posting about various SQL downloads available on the interest. The reason was that many users were not interested in learning about it. However the latest release of SQL Server Management Studio (SSMS), requires a mention about it. The latest version contains Performance Dashboard by default.Â
SQL SERVER – How to Build Three Part Name from Object_ID – Part 2?
Earlier this week, I posted an interesting interview question How to Build Three Part Name from Object_ID? – Interview Question of the Week #134. In its response, I have received a very interesting reply from Rin Sitah over here.