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 » Development   (RSS)
  • How to calculate barcode check-digit using T-SQL language

    Introduction In order to scale, it's imperative that companies stay ahead of competition. So how can they identify, store, manage and deliver goods to customers efficiently? The answer is: Barcode! A barcode is the graphical representation of a sequence of numbers and other symbols. The representation is made by lines (bars) and spaces. A barcode ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on June 23, 2017
  • The biggest table in your database

    You may need to know which is the biggest table (in terms of disk space usage) in the database that you are currently connected. Sometimes, this information is very useful to check the indexing strategy of these tables. There are several methods to know which is the biggest table of a database, one of these methods is to use the standard ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on February 11, 2016
  • 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
  • Utility Queries–Structure of Tables with Identity Column

    Edit: At the suggestion of a much knowledgable commenter who shall remain named Aaron, I changed from using schema_name() function to using sys.tables. When writing code that is expected to have reuse, it can be safer to use the tables rather than functions because the tables will work in the context of the database that is in the from ...
    Posted to Louis Davidson (Weblog) by drsql on September 2, 2012
  • Sometimes it's the small things : match column names in subqueries

    The behavior of column matching in subqueries is a little peculiar, to say the least.  If you've been bitten by this behavior once, you're unlikely to have been bitten a second time, but for some of us it just takes a while to sink in. This morning I wasted a good five minutes ''troubleshooting'' a query that wasn't working out the way I ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on January 27, 2010
  • Code that Writes Code

    I have scripts that re-create my databases for testing and development purposes. But sometimes I want to take the data from a set of tables and move it as well – I could use SSIS, or a SELECT INTO statement, but what if I want to “re-set” the data to a point in time? In other words, load it with some “base data”? I thought this might be a good ...
    Posted to Buck Woody (Weblog) by BuckWoody on November 25, 2009
  • Connect digest : 2009-10-17

    I've been fairly distracted this past week with my ''Bad habits to kick'' series, so apologies for being so late with the Connect digest.  I stumbled upon a few pretty interesting items from the past two weeks; I hope you find them interesting as well. #498082 : Allow direct usage of scalar functions in RAISERROR() It has bugged me that in ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on October 17, 2009
  • disallow results from triggers

    A setting that I noticed a while back when looking at sys.configurations was disallow results from triggers.  Triggers are one of my favorite subjects, and you will find a lot of good uses of them in my book (triggers are also well named, as poor usage of them will allow you to shoot your foot off in a heartbeat as I discussed in my earlier ...
    Posted to Louis Davidson (Weblog) by drsql on June 6, 2009
Privacy Statement