All Articles - SQL Authority with Pinal Dave

All Articles ConfigurationManagerConsole-600x248

SQL Server – Configuration Manager Console Running Very Slow and Time Out

August 16, 2017Pinal DaveSQL PerformanceDatabase Compatible Level, SQL ServerNo Comments

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

August 15, 2017Pinal DaveSQLSQL Error Messages, SQL Log, SQL ServerNo Comments

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

August 14, 2017Pinal DaveSQLSQL Error Messages, SQL Log, SQL Server, SQL Server AgentNo Comments

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

August 13, 2017Pinal DaveSQL Interview Questions and AnswersSQL Scripts, SQL Server, SQL Stored Procedure1

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?

August 12, 2017Pinal DaveSQL Tips and TricksDatabase Scoped Configurations, Execution Plan, SQL Cache, SQL Scripts, SQL Server1

Question: How to Clear Plan Cache with Scoped Configuration?

SQL SERVER – Difference Between spid, kpid and ecid in sysprocesses

August 11, 2017Pinal DaveSQL Tips and TricksSQL DMV, SQL Scripts, SQL Server, System Object1

Question: What is the difference between spid, kpid and ecid in sysprocesses?

All Articles QueryOptimizerFixes-600x543

SQL SERVER – Database Scoped Configurations – Query Optimizer Fixes

August 10, 2017Pinal DaveSQL PerformanceDatabase Scoped Configurations, SQL Server Management Studio, SSMS, TraceFlags2

During recent SQL Server Performance Tuning Practical Workshop I receive following question about Query Optimizer Fixes.

All Articles performancedashboard1-1-600x378

SQL Download – SQL Server Management Studio (SSMS) – Performance Dashboard

August 9, 2017Pinal DaveSQL PerformanceSQL Download, SQL Reports, SQL Server Management Studio, SSMS3

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?

August 8, 2017Pinal DaveSQL Tips and TricksSQL Function, SQL Scripts, SQL Server, System Object4

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.

SQL SERVER – How to Convert CollationID to Collation Name?

August 7, 2017Pinal DaveSQL Tips and TricksSQL Collation, SQL Scripts, SQL ServerNo Comments

One of my blog readers sent email to me asking if there is a way to convert CollationID to Collation name. I replied asking more details about the requirement. Here is her reply.

Pinal,
I am in a trouble right now. Due to a hardware crash, I lost many of database files. Unfortunately, I don’t have backups, but I was able to retrieve MDF files. I was trying to follow your blog