SQL SERVER – Comic Slow Query – SQL Joke

Community TechDays at Ahmedabad was a great successful event. In fact, this can be considered the biggest event held in Ahmedabad thus far along with the community. I have posted a detail report of the same at SQLAuthority News – Community TechDays in Ahmedabad – A Successful Event. After the event, I received many emails requesting the comic strip I had shown in my presentation.

I had presented two different comic strips: one before the presentation and the other after the presentation. Both the comic strips are shown here; if you click on the images, you can see the larger version. Let me know what you think of them. If you are interested in the whole session of “The other side of Index,” let me know so that I can present the same at your UG event as well.

Before Presentation

Click on the image to see the enlarged version

After Presentation

Click on the image to see the enlarged version

Let me know what you think about these.

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

9 thoughts on “SQL SERVER – Comic Slow Query – SQL Joke

  1. Sir,

    I was very unfortunate not to join you in Pune for your Gyan fest.No seats were available.I am often asked a particular question but could not find an answer to it.Articles on the internet also didn’t help much.

    ‘WHY TEMDB IS RE-CREATED AFTER WE REBOOT SQL SERVER’?

    Kindly throw some light on it.As a junior DBA,I always look upto you for some guidance.

    Like

    • Hi chandan,
      Tempdb is used to store temporary information(tables, history& etc…..)

      When ever we restart the server, Tempdb will be truncated.

      if not, let me know.

      Like

  2. Hi Chandan,

    Tempdb is re-created everytime when sql server started.

    In simple way..

    1. Tem tables
    2. Stored procs

    are dropped automtically when sql will be down and no connection are in active state, backup and restore operation are also not allowed. Due to that there is nothing to save for later use by SQl server.

    Like

  3. Pingback: SQL SERVER – Weekly Series – Memory Lane – #051 | Journey to SQL Authority with Pinal Dave

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