THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » T-SQL » performance   (RSS)
Showing page 2 of 3 (30 total posts)
  • Partitioned views

    I must say I am a big fan of views. They give flexibility of changing the logic of the data retrieval without affecting DAL layers in your application. I posted series of articles about updateable views and triggers on views, their application in SSIS for example. Recently we finished development of system that loads data from several external ...
    Posted to Piotr Rodak (Weblog) by rodak.p@gmail.com on September 10, 2010
  • What Happened Today? DATE and Date Ranges Over DATETIME

    A few days ago Aaron posted yet another fantastic entry in his Bad Habits series, this one discussing mishandling of date ranges in queries. This is a topic near and dear to me, having had to clean up a lot of poorly thought out code in the past few years. Aaron's post includes many examples, all of which boil down to the proper way to do the job, ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on October 20, 2009
  • Let's deprecate UPDATE FROM!

    I guess that many people using UPDATE … FROM on a daily basis do so without being aware that they are violating all SQL standards.   All versions of the ANSI SQL standard that I checked agree that an UPDATE statement has three clauses – the UPDATE clause, naming the table to be updated; the SET clause, specifying the columns to change and ...
  • Who's On First? Solving the Top per Group Problem (Part 1: Technique)

    Relative comparison is a simple matter of human nature. From early childhood we compare and contrast what we see in the world around us, building a means by which to rate what we experience. And as it turns out, this desire to discover top and bottom, rightmost and leftmost, or best and worst happens to extend quite naturally into business ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on February 8, 2008
  • Cumulative Totals Screencast

    Prompted by a daily ''SQL Tip'' email a few days ago that recommended the correlated subquery to solve the cumulative total problem, this 5 minute screencast (5:02) demonstrates that the cursor solution indeed out-scales the set-based correlated subquery for this particular problem.
    Posted to Paul Nielsen (Weblog) by Paul Nielsen on December 6, 2007
  • T-SQL Cursors -- the Case of the Published TPC-E Tests

    Within the SQL Server community, there is so much publicity on T-SQL set-oriented processing as good practice and the use of T-SQL cursors as bad practice that  T-SQL cursors are effectively being seen as a plague to be avoided when in fact it's not the use of T-SQ cursors, but their misuse, that should be avoided. To be fair, I must say that ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on October 8, 2007
  • How NOT to pass a lot of parameters

    Did you know that SQL Server allows stored procedures to have up to 2100 parameters? And more important: do you care? Well, some people do care, and Joe Celko seems to be one of them.   If you are a regular reader of SQL Server newsgroups, you probably know Joe Celko from his always unfriendly and often incorrect replies. Here is a typical ...
  • Speed Up Performance And Slash Your Table Size By 90% By Using Bitwise Logic

    You have all seen websites where you can pick a bunch of categories by selection a bunch of check boxes. usually what you do is store those in a lookup table and then you create another table where you store all the categories for each customer. What if I tell you that you can store all that info in 1 row instead of 10 rows if a customer picked 10 ...
    Posted to Denis Gobo (Weblog) by Denis Gobo on May 29, 2007
  • Multiple-Valued Parameters

    So I was doing some research on which is the best way to pass multiple-valued parameters into a stored procedure or user-defined function when I found some interesting results. I had always used a string-based user-defined function to parse a delimited list of values and I knew I could use XML to do the same thing, yet I had never compared the two ...
    Posted to Peter DeBetta's SQL Programming Blog (Weblog) by Peter DeBetta on February 12, 2007
  • Medians, Actual Query Cost, and Statistics

    I was going to comment on Adam's post ''Medians, ROW_NUMBERs, and performance'' (which was a follow-up to Aaron's post ''Take the high road to middle ground'') and I realized that I needed to show some code and alas, comments are not so nice about formatting code, so I am posting a follow-up post... At the PASS Summit back in November, ...
    Posted to Peter DeBetta's SQL Programming Blog (Weblog) by Peter DeBetta on December 20, 2006
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement