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

SQL Server Interview Questions and Answers
Print Book Available (207 Pages) | Sample Chapters

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

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

Prize

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 (http://blog.sqlauthority.com)

About these ads

2 thoughts on “SQL SERVER – Data Collector Usage – Quiz – Puzzle – 29 of 31

  1. 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)
    AS
    A VARCHAR2(10);
    B varchar2(10);
    BEGIN
    A := x;
    FOR A in x .. y Loop
    insert into dummy_1 values (A);
    End loop;
    end;

    Thanks in advance
    Hareesh.

  2. Pingback: SQL SERVER – Weekly Series – Memory Lane – #014 « SQL Server Journey with SQL Authority

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s