Hi guys, This is a tip for you who want better performance when executing your programs, and also wants a clean and simple syntax. Let’s understand a little more about Yield definition before we show how to use it. The… Continue a ler »Improving Performance using Yield on C#
People who had contact with Oracle and already used the function that enumerates the rows of a query (RowNumber) perceive a certain ease to use this functionality. However on SQL Server you are faced with a need to enumerate rows… Continue a ler »RowNumber on SQL Server
Hi, Our Facebook Page Plugin Widget for BlogEngine.Net is finally ready for download*! I hope you like it and please let me know what you think about it! The plugin has been submitted to BlogEngine.NET gallery, and I will update… Continue a ler »Facebook Page Plugin Widget for BlogEngine.Net
Hi guys, This post is for all WebDevs that use Visual Studio as web development tool. Who never needed to develop something using jQuery and questioned yourself why Visual Studio Intellisense doesn’t work for jQuery? Sometimes we make small mistakes… Continue a ler »Intellisense for jQuery on Visual Studio
Hi guys,
Views need to be refreshed if the underlying tables change at all. You shouldn’t have to run sp_refreshview for altering a view. Only for altering its underlying tables.
The following T-SQL script can be used to refresh all view inside a database:
Continue a ler »Script to Refresh All Views in a SQL Server Database
Hi guys, Regarding this error we have 2 options, which is either you want to enable your site to list the contents of the directory or you don’t want to enable to list the contents of the directory. If you… Continue a ler »HTTP Error 403.14 – Forbidden – The Web server is configured to not list the contents of this directory
Hi guys, Firstly let’s clarify what currency symbols and currency codes are. Currency symbols are symbols that are used to represent a currency and it can vary from each country. See below some currency symbols as examples: € – Euro £… Continue a ler »How to return currency symbol from currency code using C#
Hi guys, This is a tip on how validate a email field with one or more emails, using column or semi column. I was developing a validator for a ASP.net MVC3 with attributes using JavaSctipt/jQuery as well, and I developed… Continue a ler »Email Validation using JavaScript/jQuery
Hi guys, Today I will give you a simple tip, more than a tip it is an script ready to run. You will be able to test an insert setting a value for a identity column on SQL Server. This… Continue a ler »SQL Server – Insert records with value in identity column
Hy guys, Today I will give you a useful tip that can make your life as developer a bit easy. This tip is for you that is using SQL Server Management Studio with activated intellisense. You know when you create… Continue a ler »SQL Server Management Studio Outdated IntelliSense