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 (https://blog.sqlauthority.com)
15 Comments. Leave new
Hi Pinal,
Any pre-registration is needed for this?Or is this a open camp?Pls confirm.
Hi Veera,
It’s a free event; you can participate by registering in the Chennai SQL Users Group
–
Selva
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
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
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
may i attend this session
Hi Pinal, welcome to Chennai. It is nice to have such SQL Data camp in Chennai.
Hi Pinal,
When you have SQL Data Camp in Pune :)
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.
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
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.
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.
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.
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.?