4 Replies - 4461 Views - Last Post: 02 December 2013 - 02:32 PM Rate Topic: -----

#1 modi123_1  Icon User is offline

  • Suitor #2
  • member icon



Reputation: 9187
  • View blog
  • Posts: 34,489
  • Joined: 12-June 08

[link] Understanding how SQL Server executes a query

Posted 02 December 2013 - 02:02 PM

http://www.codeproje...xecutes-a-query

A fun visual graph, and super detailed explanation, of all the gears that turn in a query's execution! A solid read for new and experience folk alike,

Quote

If you are a developer writing applications that use SQL Server and you are wondering what exactly happens when you ‘run’ a query from your application, I hope this article will help you write better database code and will help you get started when you have to investigate performance problems.
...
Developers that interact with databases have two main pain points: troubleshooting performance and troubleshooting data loss issues. This article will not help you much with the later, if you do not have a backup, nothing will save your, sorry! But I hope that understanding how things work will shed some light into the performance troubleshooting problems.


Is This A Good Question/Topic? 0
  • +

Replies To: [link] Understanding how SQL Server executes a query

#2 DarenR  Icon User is offline

  • D.I.C Lover

Reputation: 454
  • View blog
  • Posts: 3,148
  • Joined: 12-January 10

Re: [link] Understanding how SQL Server executes a query

Posted 02 December 2013 - 02:09 PM

and here i thought they would show it in real world sense with smurfs and mushrooms but nooo they had to make a visio diagram--- ughhhhh

good read modi non the less
Was This Post Helpful? 0
  • +
  • -

#3 modi123_1  Icon User is offline

  • Suitor #2
  • member icon



Reputation: 9187
  • View blog
  • Posts: 34,489
  • Joined: 12-June 08

Re: [link] Understanding how SQL Server executes a query

Posted 02 December 2013 - 02:15 PM

Pffst.. it's not like you cannot take that Visio diagram and bake it into a fantastical allegory with smurfs, mushrooms, and data transferring Snorks in bondage to their blue overlords.
Was This Post Helpful? 0
  • +
  • -

#4 DarenR  Icon User is offline

  • D.I.C Lover

Reputation: 454
  • View blog
  • Posts: 3,148
  • Joined: 12-January 10

Re: [link] Understanding how SQL Server executes a query

Posted 02 December 2013 - 02:29 PM

View Postmodi123_1, on 02 December 2013 - 05:15 PM, said:

Pffst.. it's not like you cannot take that Visio diagram and bake it into a fantastical allegory with smurfs, mushrooms, and data transferring Snorks in bondage to their blue overlords.



lol snorks

you pulled that outa the blue(water) lol
Was This Post Helpful? 0
  • +
  • -

#5 modi123_1  Icon User is offline

  • Suitor #2
  • member icon



Reputation: 9187
  • View blog
  • Posts: 34,489
  • Joined: 12-June 08

Re: [link] Understanding how SQL Server executes a query

Posted 02 December 2013 - 02:32 PM

The secret is it is Snork underoo Mondays.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1