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 21 (206 total posts)
  • 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
  • Speaking this weekend at SQL Saturday 277 - Richmond

      One of my favorite locations to speak or attend is when Richmond has a SQL Saturday. (though if you are an organizer of another SQL Saturday's I have submitted to, note that I said ''one of my favorites'' :)). This will be the third time I go to Richmond. I like it for several reasons:   The people - I have coworkers coming up ...
    Posted to Louis Davidson (Weblog) by drsql on March 19, 2014
  • 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
  • Capturing query and IO statistics using Extended Events

    The commands SET STATISTICS TIME ON SET STATISTICS IO ON return information about query executions and are very useful when doing performance tuning work as they inform how long a query took to execute and the amount of IO activity that occurred as a result of that query. These are very effective features however to my ...
    Posted to Jamie Thomson (Weblog) by jamiet on March 5, 2014
  • Parameterization and filtered indexes (part 2)

    In my previous post, I demonstrated how the presence of a filtered index can get in the way of successful parameterization, possibly resulting in too much query compilations and procedure cache bloat. I suggest reading that first, because I will go straight where I left off.   Use the Force, Luke   If you read the previous post very ...
  • Building Your T-SQL Tool Kit: Window Function Fundamentals

    The session Building Your T-SQL Tool Kit: Window Function Fundamentals by Christina E. Leo (@christinaleo) has been published on channel SQLPASS TV. Abstract Have you pulled a script to identify duplicates from a blog post but couldn't quite get it to work because you weren't sure what that ROW_NUMBER() function was doing? Maybe you ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on January 21, 2014
  • First release of my own personal T-SQL Code Library on github

    Like many (most???) T-SQL developers I keep a stash of useful code that I’ve garnered down the years because I know its all going to come in useful at some point in the future. It includes code I’ve written myself and also code that others have shared on their own blogs. For example my code library includes the following: vwdiskfileLatency – ...
    Posted to Jamie Thomson (Weblog) by jamiet on January 12, 2014
  • Beware the ß

    I stumbled upon an interesting little nuance of SQL Server’s behaviour over the past few days that I was not aware of and I figure its worth talking about it here so others are aware. It concerns the handling of the german character “ß” which I understand to be german shorthand for “ss” (I’m no expert on language or linguists so don’t beat me up ...
    Posted to Jamie Thomson (Weblog) by jamiet on December 13, 2013
  • Relational Database Design Pre-Con at PASS

    Well, here we go again.  I am making my final preparations again for my ''How to Design a Relational Database'' pre-conference seminar coming up at PASS. If you want to know what the ''official'' abstract is, you can find it here and if you are already convinced and have credit card in hand, click here and register before the price ...
    Posted to Louis Davidson (Weblog) by drsql on September 9, 2013
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement