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   (RSS)
Showing page 1 of 22 (214 total posts)
  • SQL Server DML Triggers - Tips & Tricks - Part 3 ("Trigger debug")

    This is the third blog post in the series dedicated to the Tips and Tricks of DML Triggers development. The first and the second parts can be found here: SQL Server DML Triggers - Tips & Tricks - Part 1 (''Intro'' & ''Triggers activation order'') SQL Server DML Triggers - Tips & Tricks - Part 2 (''Thought to work on ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on March 21, 2015
  • Off to Richmond for SQL Saturday

    I got the email prodding speakers to blog about our upcoming sessions, so I got myself up and started to write this blog. It has been such a long time since I have done much side SQL work (other than doing quite a bit of tech editing, along with doing some work for PASS leading up to speaker submissions), that my blog didn't even show up in the ...
    Posted to Louis Davidson (Weblog) by drsql on March 13, 2015
  • SQL Server DML Triggers - Tips & Tricks - Part 2 ("Thought to work on multiple rows")

    This is the second blog post in the series dedicated to the Tips and Tricks of DML Triggers development. The first part can be found here: SQL Server DML Triggers - Tips & Tricks - Part 1 (''Intro'' & ''Triggers activation order'').   Triggers must be thought to work on multiple rows One of the most frequent mistake I have seen ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on March 5, 2015
  • New Book! T-SQL Querying with Itzik Ben-Gan, Dejan Sarka, Kevin Farlee

    I'm excited to announce that after a year of work, T-SQL Querying is now available in e-book form (dead trees will ship next month)!  As you might guess from the author list, this book goes deep into various aspects of T-SQL -- both from querying and query processing perspectives. The book includes Itzik's signature T-SQL coverage, data ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on February 26, 2015
  • SQL Server DML Triggers - Tips & Tricks - Part 1 ("Intro" & "Triggers activation order")

    This is the first blog post in a series of posts about Tips & Tricks of SQL Server DML Triggers. Introduction Triggers are often one of the main reason of quarrel between Developers and DBAs, between those who customize a database application and those who provides it. They are often the first database objects to be blamed when the ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on December 29, 2014
  • How TOP wrecks performance (part 1)

    The TOP keyword in the SELECT clause may not be ANSI standard, but I am sure we have all used it. But do you know that it comes with two optional keywords? And have you used them? They are PERCENT and WITH TIES.   TOP   Let’s first look at the based functionality of TOP, and how it affects performance – which in fact, contrary to the ...
  • Database Mail … and then the SMTP Server changed

    The database I inherited when I started my current job sends out lots of mails. It does so using Database Mail, and it has lots of mail accounts and mail profiles defined. I know that several of those profiles are used, I suspect that some are not, and I have no idea about the rest – one day I will find the time to clean up, but so far there ...
  • Geek City: Lost Identity

    Way long ago, when Sybase first added the IDENTITY property, it took people quite a while to get the hang of using it. Along with being able to automatically generate sequential numbers for each row, we had to tune a configuration option with the geekiest of names: “Identity Burning Set Factor”.  And figuring out how to use this value seemed ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on June 17, 2014
  • Unexpected SPID change

    A few time ago I had the opportunity to investigate about an unexpected SPID (Session Process ID) change. The inquiry began when a customer of ours starts to complain for locks, and lock time out error. These locks sometime were more frequent and sometimes not. To investigate about this issue, I have taken two SQL Profiler trace files ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on April 3, 2014
  • SQL Saturday #262 : Boston

    Today I gave my T-SQL : Bad Habits & Best Practices session at SQL Saturday #262 at Microsoft in Cambridge. Fun event with a lot of friendly faces. A few mishaps along the way:had to wake up at 5:00 AM to take the only sensible commuter rail option to get me there on time;spilled, then proceeded to smear, bagel droppings all over my pants on ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on March 29, 2014
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement