|
|
|
|
Aaron is a senior consultant for SQL Sentry, Inc., makers of performance monitoring and event management software for SQL Server, Analysis Services, and Windows. He has been blogging here at sqlblog.com since 2006, focusing on manageability, performance, and new features; has been a Microsoft MVP since 1997; tweets as @AaronBertrand; and speaks frequently at user group meetings and SQL Saturday events.
October 2009 - Posts
-
Light helping this week. I am busy closing out a few projects (or at least chapters within projects) in preparation for PASS next week. ======================================== #506453 : Lock escalation no longer kicks in for INSERTs in SQL Server 2008 Read More...
|
-
Here is your weekly helping of Connect goodness. I added two items from the Connect connection, and an item from the Visual Studio connection. ================================================= #500228 : Default Data Location Not Being Written To Registry Read More...
|
-
If you're planning on attending PASS, you should consider playing Twitter Bingo (put on by Quest ). Basically, you will get a randomized card with names and avatars of 25 Twitter users who post about or are otherwise involved with PASS and/or SQL Server. Read More...
|
-
Some new updates just posted by SQL Server Release Services: For SQL Server 2005 SP2, build 9.0.3355: http://support.microsoft.com/kb/974647 For SQL Server 2005 SP3, build 9.00.4266: http://support.microsoft.com/kb/974648 On first glance, it does not Read More...
|
-
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. Read More...
|
-
In my last post in this series , I talked about using user-defined data types (alias types). Today I wanted to discuss many of the ways in which people subject their date and time columns to very inappropriate query methodologies. It's very easy to say, Read More...
|
-
In my last post in this series , I talked about using the visual designers in SSMS. This time, I wanted to treat the use of alias types. To clarify what I am talking about here, alias types used to be called " user-defined data types ." Then, when CLR Read More...
|
-
In my last post in this series , I talked about abusing triggers. This time I thought I would focus a bit on using the visual designers in SSMS. Table Designer My biggest problem with the Table Designer : many changes you make can force SQL Server to Read More...
|
-
In my last post in this series , I talked about choosing inappropriate data types. This time, I want to touch on a few ways that I see triggers being misused. Using a trigger at all A lot of people think that they need a trigger. They allow direct access Read More...
|
-
In my last post in this series , I talked about the assumptions many people make about IDENTITY columns. In this post, I want to focus on choosing data types. There are several areas where I see frequent mistakes in data type choice, and I'll mention Read More...
|
-
In my last post in this series , I talked about inconsistent naming conventions. This time I want to talk about a few of the assumptions people make when using IDENTITY columns, and what kind of trouble they can cause. IDENTITY will prevent gaps A lot Read More...
|
-
In my last post in this series , I talked about using the schema prefix, with particular focus on dbo-only systems. In this post, I want to treat the use of inconsistent naming conventions. Stored Procedures In one of the systems I've inherited, we have Read More...
|
-
In my last post in this series , I treated the dreadful SELECT * and other ways we get around typing out a column list. This time I want to discuss the use of the schema prefix. This has to do with both creating and referencing objects. Do not make any Read More...
|
-
In my last post in this series , I talked about inappropriately using SELECT, OUTPUT and RETURN in stored procedures. Today I wanted to talk about using SELECT * or omitting the column list entirely. Using SELECT * This is a typical operation when developing, Read More...
|
-
In my last post in this series , I covered the use of "bad" characters in entity names, such as spaces or dashes. In this post I will talk about using RETURN and OUTPUT inappropriately. Jamie Thomson touched on part of this pet peeve in response to one Read More...
|
-
In my last post in this series , I talked about defining varchar columns, parameters, or variables without length. Next I want to talk about using "bad" characters, like spaces or dashes, in entity names. Every once in a while, I see people who have issues Read More...
|
-
In my last post in this series , I talked about using meaningless table aliases. This time I'm going to talk about a pet peeve of mine: declaring varchar / nvarchar variables or parameters without specifying how many characters they should hold. Thankfully, Read More...
|
-
This past week I was reviewing a few bugs surrounding the new DATE, TIME, DATETIME2 and DATETIMEOFFSET data types, introduced in SQL Server 2008. While they are much more like first-class citizens than the CLR-based types that Microsoft tried unsuccessfully Read More...
|
-
In my last post in this series , I talked about using old-style JOINs. Today I'd like to touch on using aliases. No, I don't mean fake passports and a life of crime, I mean using an alias as shorthand for referencing a table or view in a query. Some code Read More...
|
-
In my last post in this series , I talked about using simple loops to populate large tables. This time I'd like to focus on getting rid of old, ANSI-89 joins. I am sure most veterans know better than to use old ANSI-89 JOIN syntax, such as: SELECT o.OrderID Read More...
|
-
In my last post in this series , I talked about using ORDER BY <ordinal position>. Today I'd like to talk about using primitive loops to generate a large number of rows. Okay, I will admit, in most cases you are doing this for a demo or proof of Read More...
|
-
A few weeks ago, I wrote a post about forming a new habit: always terminate statements with semi-colons . Today I thought I would start a series on kicking bad habits that many of us have developed over time. I provided a little more background on this Read More...
|
-
Funny headline, because I'm not a dork, really. Okay, who am I kidding? When introduced to new people, and they ask what I do, my answer is almost unfailingly, "I'm a computer dork." Allen White had the audacity thoughtfulness to tag me in this meme, Read More...
|
-
Background Several weeks ago, I ran some tests on the new implementation of Unicode Compression in SQL Server 2008 R2 - both space-related and performance-related . Of course it was pointed out that my performance tests were somewhat flawed, because I Read More...
|
-
Welcome to October! This week I have five SQL Server items to point out to you, and two Connect-specific issues. /*------------------------------------------------------*/ SQL Server /*------------------------------------------------------*/ #331220 : Read More...
|
|
|
|
|
|