Welcome to Geekdojo
Sign in
|
Join
|
Help
<Nathan H. Omukwenyi>
{The view from a very fast moving technology train};
Blogs
Photos
Home
About
Email
Links
Technical
(RSS)
Technical
Multiple Parameter Scalar MAX() function
T-SQL provides functions for determining the greatest and the lowest values in a column of data using the MAX() and MIN() aggregate functions respectively. The functions only work with one variable and may require the use of the GROUP BY clause if other
Read More
posted
27-01-2010 01:10
by
nathan
|
0 Comments
Filed Under:
Technical
,
Rants
T-SQL Damerau–Levenshtein Distance
The Damerau–Levenshtein distance or the “edit distance” between two strings can be used in SQL Server database applications to search for strings when you’ve reached the limit with the LIKE clause or the full-text indexing features. Used directly in T-SQL,
Read More
posted
22-01-2010 11:42
by
nathan
|
0 Comments
Filed Under:
Technical
Structural Binding as a Best Practice
SQL Server allows us to decide whether query objects we create referencing tables can be tightly or loosely bound to the table structure. When you create a view or stored procedure you can specify the WITH SCHEMABINDING option to indicate that the view
Read More
posted
13-02-2009 02:23
by
nathan
|
0 Comments
Filed Under:
Technical
A login has got to do what a login can do
As an SQL Server admin, there are times when the combination of many users, groups, roles, logins and the various permissions that can be given to each to do stuff on various databases and objects within your server may just be too
Read More
posted
26-04-2006 06:36
by
nathan
|
1 Comments
Filed Under:
Technical
ASP.NET on XP Home
A little while ago, I ranted about the inadequacies of XP Home (bundled with my new Toshiba) as far ASP.NET development was concerned. Well, I finally got down to installing the VB.NET Resource Kit and Voilà! What do I see? The Cassini
Read More
posted
29-09-2004 08:31
by
nathan
|
2 Comments
Filed Under:
Technical
Services
SOA and Installing Windows Service Applications
Read More
posted
06-02-2004 01:48
by
nathan
|
2 Comments
Filed Under:
Technical
,
Rants
News
Now in Rwanda....
Post Calendar
<
March 2010
>
S
M
T
W
T
F
S
28
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
1
2
3
4
5
6
7
8
9
10
Search
Go
Post Categories
Rants (5)
Technical (6)
What's going On (7)
Archives
January 2010 (2)
February 2009 (2)
August 2008 (2)
February 2007 (1)
November 2006 (1)
July 2006 (1)
May 2006 (1)
April 2006 (8)
January 2006 (1)
December 2005 (3)
November 2005 (1)
October 2005 (1)
September 2005 (1)
August 2005 (2)
July 2005 (1)
October 2004 (1)
September 2004 (3)
May 2004 (1)
April 2004 (2)
March 2004 (1)
February 2004 (2)
January 2004 (3)
December 2003 (4)
Syndication
RSS 2.0
Atom 1.0
SkinName:iroha_Blog2
Hosting provided by by
Colossus Interactive