Working with many customers for performance issues in our DB, we realised that one of the important questions we ask them is about system configuration. So instead of asking this every time, we decided to come up with T-SQL script that can be included in our process document and even L1 support can run it …
Continue reading Getting OS and hardware details using T-SQL
Recently I faced a requirement where I need to find duplicate tables. Our system has hundreds of jobs and all jobs creates set of tables. System is so old and complex no one knows exactly. So, the objective was to find duplicate tables and then start brainstorming about how to redesign current system. Below script …
This article is the part of series Mastering Index, in this particular article we will be exploring Unique Index. Take a look at the content of this series - Mastering Index One of the most interesting and talked about topic in database field is Index. I am writing this Series of article to cover all the different …
I will be writing this series of articles for the Special Indexes in SQL Server. In this series we will cover following Index – XML Index Full Text Index Spatial Index Columnstore Index Prerequisites If you are reading this article, I am assuming that you know Index basics like type of Index, how it works …
Index Utilization Report One day my manager came and told me that he need Index Utilization Report. He felt that during development of the project we have created so many indexes but he is not sure about how useful those are. So he wants a report which shows all the Indexes on user defined table …
1. Tell me about yourself. Answer - Give summary of your past education and work, skills, and achievements and include your strong points. 2. Where you see yourself after 5 years? Or what are your Goals? Answer - Explain about your ambitions and plans but be realistic. 3. What do you know about our organization? Answer - Do …
Pro MSBI 