SQL Server Blogs

Voices from the UK SQL Server Community
All Tags » T-SQL (RSS)

Browse by Tags

  • Supercharge your SSDT database projects using T4 to auto-generate T-SQL code!

    There are many techniques that data warehouse developers could learn from other parts of the software industry and automated code generation is one of them. Most database developers have at some point in their careers written T-SQL code to query the SQL Server catalog views to automate the generation...
    Posted to Sparks from the Anvil (Weblog) by DrJohn on Wed, Jul 8 2015
  • Running Massive Updates, Deletes, Inserts

    Firstly with large transactions comes large transaction logs, ensure you grow your log accordingly before running a huge transaction because autogrows can cause overhead during execution for example: why did the query run so quickly on test rather than live… the likelihood is you ran it repeatedly on...
    Posted to Atul Thakor (Weblog) by AtulThakor on Thu, Apr 28 2011
  • The most dangerous SQL Script in the world!

    In my last blog entry, I outlined how to automate SQL Server database builds from concatenated SQL Scripts . However, I did not mention how I ensure the database is clean before I rebuild it. Clearly a simple DROP/CREATE DATABASE command would suffice; but you may not have permission to execute such...
    Posted to Sparks from the Anvil (Weblog) by DrJohn on Tue, Feb 15 2011
  • SSIS: Building SQL databases on-the-fly using concatenated SQL scripts

    Over the years I have developed many techniques which help automate the whole SQL Server build process. In my current process, where I need to build entire OLAP data marts on-the-fly , I make regular use of a simple but very effective mechanism to concatenate all the SQL Scripts together from my SSMS...
    Posted to Sparks from the Anvil (Weblog) by DrJohn on Sun, Feb 13 2011
  • The underused OVER clause!

    Seeing the Steve Hindmarsh’s blog post on the OUTPUT clause got me thinking about what other underused clauses may benefit from greater exposure! You may already be familiar with the OVER clause because it is mandatory when using a ranking function i.e. ROW_NUMBER, RANK, DENSE_RANK and NTILE. The order...
    Posted to Martin Bell UK SQL Server MVP (Weblog) by MartinBell on Sun, Jan 23 2011
  • T-SQL Fundamentals Course

    SQLBits is known for it’s high quality SQL Server training. If you look at the courses available on the SQLBits Website one may stick out as being different to the other in-depth courses; that is T-SQL Fundamentals with Martin Bell . You may ask why I’m putting on an introductory course like this, and...
    Posted to Martin Bell UK SQL Server MVP (Weblog) by MartinBell on Fri, Jan 21 2011
  • T-SQL (SCD) Slowly Changing Dimension Type 2 using a merge statement

    Working on stored procedure recently which loads records into a data warehouse I found that the existing record was being expired using an update statement followed by an insert to add the new active record. Playing around with the merge statement you can actually expire the current record and insert...
    Posted to Atul Thakor (Weblog) by AtulThakor on Mon, Jan 10 2011
  • T-SQL bits - ROW_NUMBER

    About a month ago I found the SQLShare site which provides useful, clear tutorial videos of how to use some SQL functions, or how to fine tune a query. Their videos are roughly 3-5 minutes long and have proved to be very good for me with a strong BI background with less first-hand T-SQL experience. I...
    Posted to MartinIsti MS BI blog (Weblog) by MartinIsti on Thu, Jun 3 2010
  • Good practices - database programming, unit testing

    Jason Brimhall wrote today on his blog that new book, Defensive Database Programming , written by Alex Kuznetsov ( blog ) is coming to bookstores. Alex writes about various techniques that make your code safer to run. SQL injection is not the only one vulnerability the code may be exposed to. Some other...
    Posted to Piotr Rodak (Weblog) by Piotr Rodak on Mon, May 24 2010
  • The penultimate audit trigger framework

    So, it’s time to see what I came up with after some time of playing with COLUMNS_UPDATED() and bitmasks. The first part of this miniseries describes the mechanics of the encoding which columns are updated within DML operation. The task I was faced with was to prepare an audit framework that will be fairly...
    Posted to Piotr Rodak (Weblog) by Piotr Rodak on Tue, May 11 2010
Page 1 of 10 (93 items) 1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems