June 2005 - Posts

C style comments and keyword GO in T-SQL
Published 06-30-2005 6:57 PM | jokiz
I've just encountered a weird error caused by a GO keyword lost inside a commented block using C style comment (/* */). My hunch is that the GO keyword (which is normally on a separate line) is treated differently by T-SQL parser. I will research on this...
Filed under: ,
Sysinternals’ Process Explorer
Published 06-23-2005 9:13 AM | jokiz
I have long wanted to have a utility to know what particular windows process is using a particular assembly. Sometimes you want to delete an assembly which you can’t because a process, most of the time a windows service is still using it. I finally googled...
Filed under: , ,
ArgumentNullException - API design hall of shame
Published 06-22-2005 9:21 AM | jokiz
I have read this before but just want to make a permanent reference to it in this blog. Brad Adams explains why the ArgumentNullException class violates the Design Guidelines here for not following the exception constructor patterns. http://blogs.msdn...
Filed under: ,
Pending Checkins Window
Published 06-21-2005 6:32 PM | jokiz
I always use the "Pending Checkins" window once in a while so I've assigned a shortcut for it. One feature that I would want with VSS and VS integration is the ability to browse the code sheet of an item from the said window. Anyways, checkout the bug...
Filed under: , ,
I will use Google before asking dumb questions
Published 06-18-2005 4:37 PM | jokiz
found this image in aspnet forums...
Filed under:
Stored Procedure Versioning
Published 06-18-2005 3:48 PM | jokiz
I have been wanting to put stored procedures in our current project under source control. Although changes to SPs will be minimal, we all know what we can get when we keep history of parts of our code and the ease of comparing them side by side. Searching...
SQL BOL(Books Online) Update
Published 06-17-2005 9:22 AM | jokiz
I have just updated my SQL 2000 BOL for the first time and so far, I have noticed the annotations which are majority perf issues (my major concern in programming). You might just want to update yours as well... http://www.microsoft.com/sql/techinfo/productdoc...
Filed under: ,
Published 06-16-2005 6:44 PM | jokiz
Knowing the scenarios involved with the different Isolation Levels for SQL Server, I was surprised to find out a number of stored procedures being used in a project I'm involved with, has retrieval operations with a NOLOCK switch. I was searching for...
Filed under: , , ,
Default JOIN type
Published 06-16-2005 10:50 AM | jokiz
Just bumped into a stored procedure made by a teammate using just a JOIN operator on two tables: FROM authors JOIN titleauthors ON ... Confused me a bit until I asked her what it does and she told me that it defaults to an INNER JOIN operation. As usual...
Filed under: ,
IS and AS operator
Published 06-11-2005 6:04 PM | jokiz
Boxing and unboxing in C# has a performance cost and the use of the IS and AS operator in casting objects is trivial for me. I thought before that: [code language="C#"] if (boxed is Person) { Person unboxed = boxed as Person; //do something } [/code]...
Filed under: , ,
Disabling AutoScroll for SQL Profiler
Published 06-09-2005 7:04 PM | jokiz
The SQL Profiler is one of the tools that I used in monitoring an SQL Server. The problem I have before was since I always watch the central database during development, I just want to watch a specific block of execution so I use the Pause or Stop buttons...
Filed under: ,
Validating inputs with a Cancel button
Published 06-09-2005 9:34 AM | jokiz
I have seen a number of posts like this on newsgroups and it is trivial especially for developers who misuse the events of normal WinForms controls. First are those who use the inefficient TextChanged event of the Windows Forms Textbox for validating...
ASPNET Validation Controls
Published 06-09-2005 9:28 AM | jokiz
I was reading Stephen Walther’s ASP.NET Unleased book when I found this excellent behavior of Validation Controls. Initially, I thought they just generate client-side scripts to validate them inputs. Then he raised the issue on some browsers with disabled...
Collapse All in Solution Explorer
Published 06-03-2005 3:23 PM | jokiz
I always use the collapse to definitions/toggle all outlining feature of VS editor. I have long wanted to be able to do the same with solution explorer and this afternoon, I was able to find a macro just for the collapse all through usenet. http://www...
Filed under: , ,