SQL SERVER – Data Collector Usage – Quiz – Puzzle – 29 of 31

Click here to get free chapters (PDF) in the mailbox

Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There was a constant request from the Community to take the learning of these books to the next level. Here is an article which discusses the Author’s Perspective.

Beyond Relational has come up with a very interesting concept – they have converted a few of the questions from my book into the SQL Quiz. The quiz is indeed focused on my two goals. In addition, it’s going to put the learning of the book to a higher stage. Looking at this novel concept, Vinod Kumar (Co-author) and I have decided to help every participant and reader by giving a few hints and suggestions to solve the quiz.

SQL Quiz

SQL SERVER - Data Collector Usage - Quiz - Puzzle - 29 of 31 29

From Perfmon to SQL Profiler to other third Party tools, there are a good number of performance troubleshooting tools which a DBA can use inside SQL Server. One of the hidden features of most troubleshooting tools is the Data Collector inside SQL Server. What is a Data Collector, anyway? What are the predefined collectors inside SQL Server which can be used?

Link to participate in SQL Quiz

Notes of Vinod Kumar

Data Collector is truly a hidden gem in SQL Server. Data Collector is a great tool to track what is happening inside the SQL Server. Are you using the Data Collector? Have you extended it by any chance? Let us hear your stories and how would you have implemented the same in SQL Server 2005 versions?

Notes of Pinal Dave

Data Collection is our old habit. Isn’t that the very reason why we have reached this far? I think we might have started to count because we wanted to remember how much inventory we have (may be not – but you got the point). Now, collection of the data is not really helpful unless they are arranged, filtered, cleaned up and put together in a nice algorithm. These can make data start talking and reveal its various intelligence. Data Collector is a very important subject, but I often see it not getting the proper exposure as it deserves.

Additional Notes

SQL Server Interview Questions and Answers ISBN: 1466405643 Page#144


There are exciting prizes awaiting the winners. Click here for Prizes and Frequently Asked Questions.

Link to participate in SQL Quiz

Note: SQL Quiz, winners and prizes are administrated by Beyond Relational. The goal of this blog post is to provide additional learning pointers only.

Reference: Pinal Dave (https://blog.sqlauthority.com)

Previous Post
SQL SERVER – Reclaiming Space Back from Database – Quiz – Puzzle – 28 of 31
Next Post
SQL SERVER – Advantages of Partitioning – Quiz – Puzzle – 30 of 31

Related Posts

No results found.

2 Comments. Leave new

  • Hi Pinal,

    I have a query, in one of my informatica mappings wherein SQL server 2008 is the backend, i’m trying to insert rows sequentially by passing parameter values to a stored procedure.

    Eg. i have 2 cols like LOW= 5, HIGH=7, it has to pick both parameters and dynamically do an insert of 3 rows sequentially like row1= 5, row2=6 & row3=7, my range is not specified so it will always do be dynamic & do a
    HIGH-LOW, i tried in Oracle it worked and inserted fine, but finding it difficult to do in SQL server, can u please help me out as its urgent and its and priority deliverable.

    Also i get alphanumeric values in the range like LOW=S1234 HIGH=S1240 how to split and insert seq. rows?

    My Oracle code:
    CREATE or replace PROCEDURE DMDEV.addrowv2
    (x in VARCHAR2 , y in VARCHAR2)
    A VARCHAR2(10);
    B varchar2(10);
    A := x;
    FOR A in x .. y Loop
    insert into dummy_1 values (A);
    End loop;

    Thanks in advance


Leave a Reply