I’ll be speaking for the SQL PASS Performance Virtual Chapter next week. It’ll be on July 6 at 12 PM Eastern time. The topic will be Performance Impacts Related to Different Function Types. The abstract for the event is the following: User defined functions provide a means to encapsulate business logic in the database tier. … Continue reading Webcast Next Week – Performance Impacts Related to Different Function Types
Tag: T-SQL
Doing Something About Auto Generated Names
I like my name. It provides a point of reference to who I am. If I am at work and someone calls for “Jason Strate”… that’s me. If I am at home, the same thing can happen and I still know that it’s me. I know that no matter where I am, my name will … Continue reading Doing Something About Auto Generated Names
The Power of N
A peer the other day was having some trouble storing some some Chinese characters in a database. Every time he would insert the data into his table, the results would look similar to the following. The phrase he was adding was similar to the following: 烟肉独角兽彩虹乳酪 The T-SQL he was using was forwarded to me … Continue reading The Power of N
ABCs of CTEs at PASSMN
Last week I presented at the March Minnesota SQL Server User Group (PASSMN) meeting on using CTEs in SQL Server. The session is meant as an overview and introduction to CTEs with some examples of their use and what some of the effects can be. Overall the session was well received and I got the … Continue reading ABCs of CTEs at PASSMN
SSWUG Spring ’10 Ultimate Virtual Conference
The SSWUG Spring 2010 Virtual Conference is coming up. On April 7, 8, and 9, attend a conference from the comforts of your living room, office, or couch. And while you are at it you’ll get to sit on on some incredible presentations, interaction with speakers, chat with other attendees, make new contacts, lots of … Continue reading SSWUG Spring ’10 Ultimate Virtual Conference
Find Tables with Forwarded Records
A while ago I had read about the hidden threat of forwarded records. These silent killers are like storm troopers in the bush waiting to get you when you least expect it. And then the other day I saw a T-SQL Tuesday post by Sankar Reddy on (blog – twitter) on determining if your SQL … Continue reading Find Tables with Forwarded Records
Grouping and Rounding Dates
Ever need to group dates and round them to intervals? I had this exact need for a report on wait stats I was working on for an upcoming post. I wanted the flexibility to be able to group a list of dates by either minute, hour, date, etc. And then also round those dates within … Continue reading Grouping and Rounding Dates
Please, no TRIM()?
A couple weeks back I was asked “How come Microsoft has yet to put TRIM() in SQL?” I don’t really know why there isn’t a TRIM() function in SQL Server. There is an LTRIM for function removing leading spaces. And an RTRIM function for removing trailing spaces. But there isn’t a TRIM function. Let’s be … Continue reading Please, no TRIM()?
SQL Saturday 32 — ABCs of CTEs Deck
I’d like to thank Pam Shaw (twitter as @pamshaw) and Jorge Nunez (twitter as @sqlchicken) for letting me come down to Tampa this past weekend to present at SQL Saturday #32. Jeez, that picture doesn’t make me look very happy. For someone like me that tends to forget to take time off, this is a … Continue reading SQL Saturday 32 — ABCs of CTEs Deck
Speaking at Tampa SQL Saturday
I've been selected to speak at the Tampa SQL Saturday coming up at the end of January. I'm a bit pumped to be going down there since I woke up this morning to below zero weather for yet another day. Not that I'm complaining, but my feet could definitely use a little bit of heat. … Continue reading Speaking at Tampa SQL Saturday
Strate SQL 