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...
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...
Posted to
Rodel E. Dagumampan
by
dehran ph
on
11-07-2006
Filed under:
Filed under: .NET, sql server , ASP.NET, usability and design, Development Process, how to, L10N, localization, scripts, stored procedures, user interface, sql, sequel server
scottallen has started a "what's wrong with this code" series. some items are trivial and good to think about so you might want to check them out... http://odetocode.com/Blogs/scott/archive/2006/07/31/5474.aspx http://odetocode.com/Blogs/scott/archive/2006/08/07/5515.aspx
i've been seeing a number of posts lately about ado.net connection pooling in msforums and i noticed that some are rather confused about how they work. i myself was also confused year ago about the concept until i read more about it and examined the ado.net code using reflector. i only want to list some...
you want to know the queries being executed by your application which uses ADO.NET. sql profiler comes in. however you got agents running (whatever they are), you also browse the tables using Enterprise Manager or Visual Studio and you want them to be excluded in the watch list. Filter is the key, Under...
For most of you who have been using stored procedures and following the MS guidelines in .NET Application Development, you must have been using SET NOCOUNT ON as stated in Chapter 12 of the Improving .NET Application Performance and Scalability . Although the MSDN docs was enough to tell me that with...
I just got my copies. Thanks keith!
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 usenet as usual, it brought me to this KB: How...
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 answers why they have designed the said SPs that way...
Sahil and Bill are having funny conversations on real life meaning of concurrency violations. You might want to peek here .