In one of the website I have developed, we feature random products displayed on a webpart. This can be done several ways either of the code behind or via t-sql but I think the simplest way to do it is via t-sql with the help of Guid columns. Globally Unique Identifier or GUID is a randomly generated...

dwarvend, a former teammate in my frist company once asked me about data paging large resulsets in ASP.NET. Data paging in SQL Server 2005 is relatively easy with new RowNumber feature but supporting dynamic sorting is little tricky. I have this executable to script to demonstrate this sorting. --check...

When you are developing software product to be catered to diverse customers, it must be a standard to localized your software. With .NET this has never been easy, on .NET 2.0 its even easier with striongly typed resource files. But localizing application must be part of the architectture and should not...

I have been profiling my codes and my scripts trying to debug why I have lost lots of .50 cents every transaction, given I always use the decimal datatype when computing currency values. The business logic layer persists correct values and profiler shows result with its fractional part being passed to...

Maybe some of us are used into copying results of our query and pasting it to Excel for further analysis or reporting, but we are also used into SQL 2000 behaviour. With Sql Server 2005 Management Studio, you can copy and paste the query results including the headers. Just goto, Query -> Query Options...

Last time I blogged about SQL Server Inflectional Fulltext search filters out artiles like "the", "and", "in" etc. This has caused me headaches than fun when a lot of my test cases for searching failed or returns irrelevant results. I just found out thru my boss that I can turned this off by deleting...

I was surprised tonight as I was testing the search engine of my project. It uses SQL Server Inflectional FullText search, but also supports boolean and simple search. Its good to see that it filter out these "and", "in" "of", "the", and other articles and returns 0 results when used as the only keyword...

An SqlParameter with ParameterDirection.Output has default size of 1 , this can be tricky if you use command.Parameters.AddWithValue(parameter, value) method in .NET 2.0. It was caught on my unit test when I want to retrieve the value of an output parameter, the returnErrorMessage variable must contain...

Yesterday, I was bugged by a syntax error that keeps on appearing on my stored procedure. This code seems to work fine , but it wont: .cf { font-family: Verdana; font-size: 8pt; color: black; background: white; border-top: windowtext 0pt solid; padding-top: 0pt; border-left: windowtext 0pt solid; padding...

In our local developer forum a thread on sql standard naming convention was started so I believe its worth sharing my thoughs here. Tables _<applicationName>_<tableName> Example for database project named "efcodd" _efcodd_users _efcodd_user_status _efcodd_roles I am tired of using "tbl_"...