Skip to content

Newsletter sign up

You are currently browsing comments. If you would like to return to the full story, you can read the full entry here: “Newsletter sign up”.

Comment (RSS)

21 Comments

  1. tarun sharma says:
    January 17, 2012 at 1:56 am

    when we create store procedure then show the error Must declare the scalar variable

    Reply to this comment
  2. vasu says:
    December 15, 2011 at 7:29 am

    Hi,
    First thing i like this site a lot.
    i wanted to find all relationship of specified tables(for example i am speciying Table ‘A’
    Table ‘A’ has child relationship with Table ‘B’ and Table ‘C’ and Table ‘B’ and Table ‘C’ has again child relationship with Table ‘D’ and Table ‘E’ and also Table ‘A’ and Table ‘C’ has parent relationship with Table ‘G’ and Table ‘H’)
    Now i wanto find all tables when i specify Table’A’

    Thanks in Advance

    Reply to this comment
  3. Joseph says:
    October 20, 2011 at 5:04 am

    Derek,

    As a somewhat OCD developer, I appreciate the succinctness and organization of your site (including how it translates to mobile), as well as your coding explanations and samples. I’ve visited the site several times over the last couple weeks while working through a new SQL Server 2005 project, and even if/when I didn’t find the exact answer I thought I would find (based on Google results), I always stayed and found something ELSE that was useful. That’s always a plus, oh, and worth the [+1] click!

    Job well done, sir! Many thanks.

    - Joseph

    Reply to this comment
  4. Hidayath khan says:
    September 22, 2011 at 7:38 am

    Hi Derek Dieter

    I find your work useful i reach while googlin to your website …but I have one request if you could provide the internal search option in the website itself it will be more good to reach more content and effor you did that will be really helpful for all who are accesing your site.

    Thanks
    Hidayath

    Reply to this comment
  5. shambleyjean says:
    September 17, 2011 at 2:08 am

    Great article, I just given this onto a co-worker who was doing a little research on that. And he in fact purchased me lunch because I discovered it for him

    Reply to this comment
  6. satyanarayana says:
    July 13, 2011 at 7:14 am

    great man….thanks for your help all

    Reply to this comment
  7. Sriyantha says:
    June 30, 2011 at 10:07 pm

    I just found the site while I searching help and I gothru data warehouse code sample from that I felt this is good site to keep remember, which will give more technically
    advancement to my work and knowledge.

    Thanks a lot!

    Reply to this comment
  8. mahesh kumar says:
    June 18, 2011 at 2:28 am

    how find best executin plan in sql server 2005

    Reply to this comment
  9. ak says:
    June 8, 2011 at 8:04 pm

    hi,
    i found the query to find the longest running queries very usefull …but could you suggest me how do i change it to get just to know the store procedures..i wanted to find longest running storeprocs on a sql 2005 server with database compatibility level 80(sql 2000 mode).

    thank you.
    ak

    Reply to this comment
  10. Rick says:
    May 12, 2011 at 1:37 pm

    I was glad to find SQl Server Planet, today.

    I very much appreciate the overall site, efforts, and time involved.

    Tres bien !!

    Rick

    Reply to this comment
  11. Bill Foster says:
    May 6, 2011 at 4:55 am

    Derek,

    I just stumbled onto your site while looking for ways to utilize DMV’s. I am really new to SQL having spent most of my time as a Citrix/Infrastructure guy. At my new job I have been asked to take on a DBA role as well as my Citrix duties. I am finding that SQL is a fascinating subject…. I didn’t see that coming. Your site has some great articles….especially around understanding indexes and has really assisted me in my new role.

    Thank you for sharing your knowledge.

    Reply to this comment
  12. balaraju says:
    March 1, 2011 at 2:21 am

    sir,please tell me..how to improve the performence written procedure when it will take long time..

    Reply to this comment
  13. 2131 says:
    February 25, 2011 at 4:49 am

    211231221

    Reply to this comment
  14. Harvey says:
    February 2, 2011 at 11:26 am

    Hello Dereck.

    Just wanted to let you know that your site has been my crutch in helping me to go from Oracle to SQL Server programming. Thanks a ton for creating this site.

    -Harvey

    Reply to this comment
  15. Phil says:
    August 28, 2010 at 11:53 am

    BTW — what are your consulting fees (if you’re available)?

    Reply to this comment
  16. Phil says:
    August 28, 2010 at 11:52 am

    Derek,

    Having taught computer science years ago at the college level, I must compliment you: yours are the best summaries of SQL (especially DDL) usage I’ve seen, concise and easily understandable.

    Brilliant! Excellent work!

    Regards,
    Phil

    Reply to this comment
    • Derek Dieter says:
      August 30, 2010 at 8:42 pm

      Phil,

      Thank you very much for the compliment! I’m glad these examples are useful, I do try hard to make them inclusive and concise.. but when I re-read them I usually only see the flaws. :)

      As for consulting, I’m currently working at a company full time right now and we have a tight deadline so I don’t have much time on the side. Potentially in the future I will get ramped up.

      Have a great day!

      Reply to this comment
  17. Demissie says:
    July 30, 2010 at 2:24 am

    I want to arange data of custemers in subregions under the regions

    Reply to this comment

post a comment OR Post Your Question on our ASK! Community!