Interview is a three stage process. Before => Interview => After Before Interview - Most important, ready your Resume/CV. Be confident about what you has mentioned in your CV and don't speak any think which contradict with CV. Dress according to your job profile and company's work culture. Do your homework and read about company's history, …
Category: SQL Server
Sql Server – Finding Duplicate Indexes
If you are reading this article, I assume that you have basic knowledge of Index, its types and usage. Over the years of development and chasing high performance we build and update many indexes. Due to shear number or complexity for forget to keep track of number, quantity and utilization of the indexes. For index …
Sql Server Special Table Types
Special Table Types Objective of this post is to provide a list of special tables available in Sql Server and brief description of that. If you wish to study them in details, I will be providing the links. Let's get started – There are following special types of table are available in Sql Server. Temporal …
SQL Server Interview Questions And Answers
This is post going to be more like a list of question for self assessment. So I will not be providing answer, instead of that I will provide the link for the best answer I can find on internet. I am pretty much sure you know most of the answers. I will be adding new …
Interview Questions for Companies
In this article I will be posting interview questions by companies. Whenever I am facing any interview or someone shares the question , I will be adding here. Sutherland Hyderabad Telephonic Round What is cursor in SQL Server? Tell me the Difference between Replace and Coalesce functions with examples? What is objects in SQL server? What is …
Sql Server – Detecting and Monitoring Memory Pressure
Introduction - Detecting and Monitoring Memory Pressure I will be writing this article in four parts because this topic is huge and amount of information can be overwhelming for readers and for me also. So we will be exploring it step by step. DBCC MemoryStatus Using DMV Alert and perfmon counters As a DBA or …
Continue reading Sql Server – Detecting and Monitoring Memory Pressure