SQLAuthority News – Two SQL Sessions at SQL Data Camp at Chennai – July 17, 2010

I will be presenting two SQL Server advance level sessions at SQL Data Camp @ Chennai.

I am very excited for this event as I am going to meet my friends Sugesh, Deepak, Vidhya and Madhivanan at this event. All of them are SQL Server MVPs. I have come to know that there are two other SQL Server MVPs – Madhu andVenkatesh are also joining the event as speaker. This is going to be one mega fest as so many of SQL Server MVPs are going to be present at same place. The event is going to be world-class event and there is no doubt about the same.

I am very much looking forward to this event on July 17, 2010. The event venue is  Hotel Palmgrove, Vaishali Banquet Hall, 5, Kodambakkam High Road, Chennai – 600034 Tamil Nadu, INDIA.

I will be speaking on following two sessions at the event. I am very excited as Chennai is one of my favorite city and always love to visit the same. I am very glad that both the sessions which I will be doing are on Indexing and Performance Tuning. I love to talk about Index and Performance Tuning.

Spatial Database & Spatial Indexing

Speaker : Pinal Dave
Event Date : 17th July 2010
Session Time : 09:45 to 10:45

Microsoft SQL Server 2008 delivers new spatial data types that enable you to consume, use, and extend location-based data through spatial-enabled applications. Attend this session to learn how to use spatial functionality in next version of SQL Server to build and optimize spatial queries. This session outlines the new geography data type to store geodetic spatial data and perform operations on it, use the new geometry data type to store planar spatial data and perform operations on it, take advantage of new spatial indexes for high performance queries, use the new spatial results tab to quickly and easily view spatial query results directly from within Management Studio, extend spatial data capabilities by building or integrating location-enabled applications through support for spatial standards and specifications and much more.

Good, Bad & Ugly – The other side of Index

Speaker : Pinal Dave
Event Date : 17th July 2010
Session Time : 15:00 to 16:00

Index is often considered as the sure shot tool of improving the performance of any query. Learn the secrets of Indexing with examples and discover the good, bad and ugly sides of Index. This session will help you efficiently write queries in future as well make you go back and defector your earlier code.

I have presented above two sessions earlier as well but for this one specially I have created new demos and they are going to be very interesting. If you are in Chennai, I strongly suggest that you all attend this event, we are really going to do one great event.

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

About these ads

15 thoughts on “SQLAuthority News – Two SQL Sessions at SQL Data Camp at Chennai – July 17, 2010

  1. Hi Pinal,

    I am delighted to welcome you to the Chennai, I am sure this is going to be a Rocking event, which i am more interested to see all the MVP’s in one place.

    I look forward to seeing you and interacting with you during the conference.

    Many Thanks,

    Selva

  2. hi pinal,

    i already registered but, no response from there.i want see you session without fail so kindly help me to watch your session

  3. Dear pinal sir,
    I really would love to attend the session but i cant coz am working as Software Engineer in chandigarh….Few days back i gave a presentation on New Features of sql server 2008 which included the Spatial Datatypes also….I wolud love to learn more from you sir…..can you please find a way so that i also get to know the presesntaions you gave via some documentation or power point presentation

    Thank & Regards

    Sumit Thapar

  4. Enjoy Chennai(the place where i grew up), Don’t miss out on the hot steaming idlis and dosas, if you get a chance make trip to saravana bhavan.

  5. Hello sir,

    Thanks for the insightful sessions on Spatial Databases, Indexing & Other side of Index (The good, bad and ugly sides!!)

    It was a perfect blend of learning and fun :)

    And was a dream come true to meet you sir !

    Cheers,
    Raguram

  6. Hi Pinal,

    Thanks for your two Sessions at Chennai. It was very helpful to many of us. We are expecting more sessions from you in Chennai.

  7. Hi Pinal,

    It was a very exciting & informative sessions at the sql data camp.

    Spatial databases and the good,bad and the ugly side of indexes was really fun to learn

    Best Regards
    Praveen.

  8. Thanks Pinal. The way you conducted the session was really great and thoroughly enjoyed the session and learnt a lot about conducting professional trainings.

    Very happy to meet you personally. You are very humble and affable person, inspite of your MVP status.

  9. Hi Pinal,

    For paging operations, We use below type queries,

    — Selecting Rows using “With” Keyword
    WITH TEMP AS (SELECT ROW_NUMBER() OVER (ORDER BY last_name desc)
    AS RowNumber, first_name, last_name, dept_no FROM employee )

    SELECT first_name, last_name, dept_no FROM TEMP WHERE RowNumber BETWEEN (1 – 1) * 5 + 1 AND 1 * 5

    — Selecting Rows using Temp table
    IF object_id(‘tempdb..#TEMP’) IS NOT NULL
    BEGIN
    DROP TABLE #TEMP
    END
    CREATE TABLE #TEMP(ID INT IDENTITY(1,1), FIRST_NAME VARCHAR(20), LAST_NAME VARCHAR(20), DEPT_NO BIGINT )

    INSERT INTO #TEMP
    SELECT first_name, last_name, dept_no FROM employee ORDER BY last_name desc

    SELECT FIRST_NAME, LAST_NAME, DEPT_NO FROM #TEMP WHERE ID BETWEEN (1 – 1) * 5 + 1 AND 1 * 5

    We can use Temp tables or “With” keyword. In large tables is there any performance improve while using either of those one.?

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