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 » performance » T-SQL   (RSS)
  • For the Better Developer: When indexes are not enough

    Another month, another session for the PASS Application Development VG. This time I will be both the host and the guest :), talking about something is very close to my interests and, I think, also a key point for any developer to have success in future of AI. Here’s the session title and abstract: For the Better Developer: When indexes are not ...
    Posted to Davide Mauri (Weblog) by manowar on October 3, 2017
  • T-SQL Window Functions

    I’ll soon post something on this, but let me tell you right here. If you don’t want AI to take you DEV/DBA/BI job you *need* to be smarter than AI (which is not AI at all right now, but let’s keep on playing the marketing game): one way to become smarter is to - guess! - use your brain and train it to think out of the box, practice lateral ...
    Posted to Davide Mauri (Weblog) by manowar on July 10, 2017
  • Performance Tuning with SQL Server Dynamic Management Views

    From Red-Gate website you can download (for free) the ebook Performance Tuning with SQL Server Dynamic Management Views written by Louis Davidson (@drsql) and Tim Ford (@sqlagentman). DMVs are objects that publish information about the health state of a SQL Server instance. They allow you to monitor the heart of the system to diagnose ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on March 14, 2014
  • One more reason to to understand query plans, not directly performance related

    One of the things that separates a good programmer from a great one is a firm understanding about what is going on inside the computer. For some programming languages, it is very obvious what is going on inside the computer because you are working at a very low level. For example, if you are a C/C++ programmer writing an OS, you will know a lot ...
    Posted to Louis Davidson (Weblog) by drsql on January 22, 2013
  • OUTPUT clause and windowing functions

    A few days ago I was asked a question how to remove duplicates from a table. As usually in such cases, the duplicate values were related only to several columns, not all of them. So classical approach, to copy distinct data into temp table, truncate the table with duplicates and then copy the data back wouldn’t work. In such cases I find one of ...
    Posted to Piotr Rodak (Weblog) by rodak.p@gmail.com on July 31, 2011
  • What PASS sessions will I try to attend?

    Every year at PASS, I do the same thing. I hmm and haw over which sessions I want to go to, and I end up making some tough choices at game time.  This year I believe I'll be pretty busy, so my typical pie-in-the-sky view of how much I'll be able to attend just isn't going to pan out.  Instead, I have selected 5 sessions that I really ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on October 29, 2010
  • 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
  • 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
Privacy Statement