SQLAuthority News – Ahmedabad SQL Server User Group Meeting Review – March 21, 2009

We had fun session with Ahmedabad SQL Server Usre Group last week on March 21, 2009. It was short session but one interesting one. We discussed about how query profiler works and how to find most popular query from SQL Server instance. We had also prepared Trace Template as well query which can ran to identify longest running query along with popular query. I received nearly 10 questions after my session and lots of time was spent answering them. The whole session was very interactive.

I want to congratulate everybody who attended it, if you need my Profiler Template and Query to identify longest running query as well popular query, please let me know and I will send them to you.

Reference : Pinal Dave (http://blog.SQLAuthority.com)

About these ads

5 thoughts on “SQLAuthority News – Ahmedabad SQL Server User Group Meeting Review – March 21, 2009

  1. Hi Pinal,

    I have seen your website and you have started meeting in Ahmadabad.
    That’s very good news for our gujarat IT eng.
    in your meeting you had a great fun with knowledge shared with each others member . I see on this post and I am happy to see your meeting photo………:) all are looking good. :)

    I have one suggestion…..Please record video of your meetup and upload in youtube and share that video with all groups member who are not able to attend meeting. for some reason.

    Have a great day !

    Regards,
    Shailesh Kavathiya

  2. Sir,

    Many people loves you very much. We have big fan base here in B’lore.

    Come down here and we will have big event ready for you.
    Do not publish my name. Email for you only.

    Your Big Fan

  3. Can you tell me what is the use of ROLLUP keyword. can we use it practically.

    Ex.

    SELECT SC.CustomerID,
    SUM( soh.TaxAmt) AS TotalTax_Amount,
    GROUPING(SC.CustomerID) AS ‘Grouping1′,
    GROUPING(soh.TaxAmt) AS ‘Grouping2′

    FROM Sales.Customer SC
    INNER JOIN Sales.SalesOrderHeader soh
    ON SC.CustomerID = soh.CustomerID
    GROUP BY SC.CustomerID,soh.TaxAmt
    WITH rollup

    **
    why doesn’t the Grouping1 coloumn gives 1 when customerID change.

  4. Will you be able to send me your Profiler Template and Query to identify Longest running query?

    It will be a great help from your side to resolve my high connection as welll as deadlock issues.

    Thanks in advance
    Sneha Shah

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