June 2005 - jokiz -

C style comments and keyword GO in T-SQL

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...

Published Thu, Jun 06 2005 6:57 PM by jokiz

Filed under: SQL, C

Sysinternals’ Process Explorer

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...

Published Thu, Jun 06 2005 9:13 AM by jokiz

Filed under: .NET, techie, tips

ArgumentNullException - API design hall of shame

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...

Published Wed, Jun 06 2005 9:21 AM by jokiz

Filed under: .NET, design guidelines

Pending Checkins Window

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...

Published Tue, Jun 06 2005 6:32 PM by jokiz

Filed under: .NET, bug, sourcesafe

I will use Google before asking dumb questions

found this image in aspnet forums...

Published Sat, Jun 06 2005 4:37 PM by jokiz

Filed under: techie

Stored Procedure Versioning

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...

Published Sat, Jun 06 2005 3:48 PM by jokiz

Filed under: .NET, SQL, tips, version control, stored procedures

SQL BOL(Books Online) Update

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...

Published Fri, Jun 06 2005 9:22 AM by jokiz

Filed under: SQL, tips

COM+ 1.0 and SERIALIZABLE ISOLATION LEVEL

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...

Published Thu, Jun 06 2005 6:44 PM by jokiz

Filed under: .NET, SQL, concurrency, com+

Default JOIN type

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...

Published Thu, Jun 06 2005 10:50 AM by jokiz

Filed under: SQL, tips

IS and AS operator

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]...

Published Sat, Jun 06 2005 6:04 PM by jokiz

Filed under: .NET, C#, performance

Disabling AutoScroll for SQL Profiler

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...

Published Thu, Jun 06 2005 7:04 PM by jokiz

Filed under: SQL, tips

Validating inputs with a Cancel button

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...

Published Thu, Jun 06 2005 9:34 AM by jokiz

Filed under: .NET, windows forms, validation

ASPNET Validation Controls

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...

Published Thu, Jun 06 2005 9:28 AM by jokiz

Filed under: .NET, tips, controls, ASP.NET, validation

Collapse All in Solution Explorer

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...

Published Fri, Jun 06 2005 3:23 PM by jokiz

Filed under: .NET, tips, visual studio

June 2005 - jokiz

Syndication

Recent Posts

Tags

News

Archives

C style comments and keyword GO in T-SQL

Sysinternals’ Process Explorer

ArgumentNullException - API design hall of shame

Pending Checkins Window

I will use Google before asking dumb questions

Stored Procedure Versioning

SQL BOL(Books Online) Update

COM+ 1.0 and SERIALIZABLE ISOLATION LEVEL

Default JOIN type

IS and AS operator

Disabling AutoScroll for SQL Profiler

Validating inputs with a Cancel button

ASPNET Validation Controls

Collapse All in Solution Explorer