Home > Tech, Tweaks > my hash table

my hash table

December 14, 2004 Leave a comment Go to comments

[Read bottom-up]

Connecting to a SQL server instance running on non-default port (other than 1433)
I got to this problem only while trying to use SQL Server 2005 express manager. One way is to configure an alias in the Client network utility. However, the syntax for specifying the absolute instance name is “protocol:servername\instancename,portname“, e.g tcp:northwind.apac.hp.com\uat,2048

Specifying the version of .NET framework for each WebApplication
aspnet_regiis.exe utility lets me view and assign the .NET framework version to each individual web-app. This way my quickstarts can be running on Fx 2.0 and the my Project on Fx 1.0.3705.6018 (this corresponds to version 1.0 with SP3)

Tab-completion in Windows 2000 command window
This feature allows you to begin entering in a long filename from the command prompt, and to press the Tab key to have the rest of the long filename automatically completed.

Navigate: HKEY_LOCAL_MACHINE\Software\Microsoft\CommandProcessor
Name: PathCompletionCharData
Value: 9

Select rows as a single value
If you ever had a requirement to select a concatenated-delimited string of few string data in few rows of a table, here is the SQL for it.

declare @list varchar(255), @delimiter char(1)
set @delimiter = ‘,’
select @list = coalesce(@list + @delimiter, ”) + title_id from titles
select @list as RowsAsSingleValue

Somethings that I’ve come across and want to remember.

Categories: Tech, Tweaks
  1. November 14, 2004 at 11:03 pm

    hmm the select row thing was pretty cool!

  2. December 15, 2004 at 9:28 am

    how appropriate that i should stop by your site and your blog mentioning hash tables. I was just reading up this article called “bringing the tree down” and its about a new indexing technology called coppereye, a proprietary indexing technology that aims to replace b-trees and hash indexing in databases. The results they have are really exciting and it seems Informix already has a product shipping out with it. Well its a long take to bring down the good old tree but if you are intrested check it out http://www.coppereye.com–>

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: