SQLAuthority News – Virtual Presentation on Practical Tricks and Tips to Speed up Database Queries – December 15, 2011

Performance tuning has been my favorite subject and any time when I have to present on this subject, this itself gives me tremendous pleasure as well. I am always excited to present something new on this topic. Virtual Tech Days is just here around the corner and I am going to present about performance tuning subject once again. However, I am going to focus that instead of theory, I will talk about the practical aspect of the performance tuning and share tips which one can use right away.

Sessions Details

Title: Practical Tricks and Tips to Speed up Database Queries
Timing: December 15, 2011 1:45pm – 2:45pm IST
In this session I am going to discuss various performance tuning related techniques. Here is the agenda of the session.

  • A Quick Start on Performance
  • Denali T-SQL Enhancements
  • Timeless Best Practices
  • The Superlative Performance

Each of the above topics will be associated with very practical solid demo. I am sure you will absolutely enjoy the session.

Giveaways

During my session I will ask a simple question. I will give away 5 copies of my SQL Server Interview Questions and Answers books to five random person who will answer it correctly (more details in the session). If you have already have this book, I strongly suggest you attend this session as this session will take the performance tuning concepts to next level. I will make sure that I autograph and send this copies to your way.

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

Previous Post
SQL SERVER – Fix: Error: Msg 1904, Level 16 The statistics on table has 33 column names in statistics key list. The maximum limit for index or statistics key column list is 32
Next Post
SQL SERVER – A Quick Look at Performance – A Quick Look at Configuration

Related Posts

No results found.

12 Comments. Leave new

  • Pinal – that’s right in the time that my wife has claimed as ‘her time’. Is there a possibility of a podcast/vidcast afterwards? Pretty please!

    Reply
  • I am very much keen on attending this session. How can i attend this one..

    Reply
  • i am ready for this !!!

    Reply
  • how can i join here?

    Reply
  • Kotha Praveen Kumar
    December 12, 2011 2:47 pm

    I am also very interested in joining the session….would be please tell me how to join it…as it is my first experience

    Reply
  • I am interested too. Please forward the details on how to attend.

    Reply
  • Is there an online option to follow the presentation?

    Reply
  • Niall is right actually. I follow you since a short time but you are providing a lot of usefull tips and way to work but actually I live in Canada, more precisely in Quebec.

    If your presentation starts at 1:45pm IST, it means 3:15am in Quebec ! Will it be available as podcast/vidcast afterwards??

    Reply
  • Please provide the details to attend session. that would help a lot of people to plan where to go.

    Reply
  • How can i join here?.

    Reply
  • My query is , I would like to made function for splite string values of column from another table, please correct the given code :

    declare @i int ,@j int ,@k int, @sr varchar(100), @str varchar(100)
    set @str =’This Is John Rambo’
    set @i = 0 set @j = 0 set @k = 0
    begin
    Declare @Cnt int
    Set @Cnt = 1
    while(CHARINDEX(‘ ‘,@str)>0)
    begin
    –set @j = charindex(‘ ‘,@str, @k )
    –set @i = charindex(‘ ‘, @str , @k)+ 1
    set @sr = ltrim(rtrim(substring(@str,1,charindex(‘ ‘,@str) -1)))
    –set @k = @i
    set @str = substring(@str,charindex(‘ ‘ , @str) + 1, len(@str))
    select @sr , @cnt –@i, @k,@j, len(@str)
    set @cnt = @cnt + 1

    end
    Select ltrim(rtrim(@str)) ,@cnt
    end

    I am using sql server 2000 there is no pivoting is done plese let me help.

    Reply
  • hi,
    provide me link and information to join it.
    i don’t want to miss this chance.

    Reply

Leave a Reply