THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » stored procedures   (RSS)
  • Performance impact: stored procedures, SQL batches, and CPU usage

    What is the simplest way to drive a CPU to 100% using T-SQL? If it’s a language like C++ or C#, the simplest way is to create a tight loop and perform some work that uses CPU cycles inside the loop. For instance, the following tight loop in C# can peg a CPU to 100%:         while (true) ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on July 21, 2011
  • High Performance Dimensional Data Loads With SSIS Presentation

    Just finished giving the SSIS High-Performance Dimensional Data Load presentation at SQLSaturday #59 NYC.  Here are the slides in PDF format.  I'll upload the Try-N-Save code and sample data later for attendees to play with. Thanks to everyone who attended my session and thanks to Melissa D. and NJSQL for putting this ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on November 20, 2010
  • Encrypt it in .NET/Decrypt it on SQL Server?

    A common question on the newsgroups is ''how do you encrypt data in a .NET [or other] client application and then decrypt it on SQL Server [or vice versa]?'' I actually ran down my list of answers to someone who asked this in the newsgroups a few weeks ago. I won’t get into the details, but the answers all pretty much say the same thing -- ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on January 29, 2010
  • Trick Question – Part Två

    This post is part two of an effort to examine, in brief, the decisions entailed in designing the interface between database and application. We’re in a strange place at this moment, where both the possibilities and the liabilities of techniques like ORM have come to a head, and it seems vital to go into data tier design at least equipped with all ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on October 24, 2009
  • Bad habits to kick : using SELECT or RETURN instead of OUTPUT

    In my last post in this series, I covered the use of ''bad'' characters in entity names, such as spaces or dashes.  In this post I will talk about using RETURN and OUTPUT inappropriately. Jamie Thomson touched on part of this pet peeve in response to one of the other posts in this series.  So let me ask, do you see anything wrong ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on October 9, 2009
  • Parameters, Perms and Procs: Are You Really Protected from Injection?

    In my last post, Top 10 T-SQL Code Smells, I caught some flack got some feedback for including one (#3) about the use of Stored Procedures for Select statements. Several people expressed objections over the risk of SQL Injection, and how Stored Procs would prevent it, but some of the correspondence I've gotten made me worry that, perhaps, some of ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on August 24, 2009
  • Why use Stored Procedures?

    There are as many opinions for and against using stored procedures as there are database-related roles. I believe the position that is most qualified to speak to stored procedures is the data architect’s role. Data architecture is the role that studies the various methods, patterns, standards, and best-practices that result in databases that will, ...
    Posted to Paul Nielsen (Weblog) by Paul Nielsen on May 9, 2009
  • My stored procedure "best practices" checklist

    When developing stored procedures, there seems to be a lot of emphasis on ''get it done fast.'' Which means type all lower case, pay little attention to formatting, and sometimes throw best practices out the window. Personally, I would rather front-load my development time; I think that the costs I pay in initial development far outweigh what ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on October 30, 2008
  • Yet Another Stored Procedure vs. Ad-hoc Query Discussion?

    Earlier today, Will Sullivan posted a blog entry, My Statement on Stored Procedures, in which he emphatically states his official opinion of stored procedures as: ''I prefer not to use them.'' He then goes about dismissing most of the misinformation about why stored procedures are better than ad-hoc (parameterized) queries. The first bit of ...
    Posted to Peter DeBetta's SQL Programming Blog (Weblog) by Peter DeBetta on April 3, 2008
Privacy Statement