Next pet project is to move my blog on Community Server to the Cloud. I spend too long making sure my database size does not go over 500 MB, the size limit on my hoster. So once every 3 months I have to do some clean up of the database: DELETE FROM cs_statistics_Site DELETE FROM cs_Visits DELETE FROM...

I just found out something really weird about HTML comments. Apparently, according to standards, you can't do this: <!-- comment ------------------------ --> That is, you can't put two or more ‘-‘s inside a comment. It works as expected in IE7, but it breaks down horribly in FireFox. FireFox simply...

We decided to use FilteredViews instead of FetchXml for an internal project, but we ran into couple of problems. You can't access data from the FilteredViews using ASP.NET since it runs under NETWORK SERVICE (by default (app pool)), FilteredViews filter the data by Users. If you set the <identity>...

This is something I have come across during our SQL migration which I didn't even think about. You can zip up your bak files and save considerable hard drive space. We have a 14 gig database which happily compresses down to 2 gig. With hard drives coming down in price, you may think why bother. Well...

/// <summary> /// This webservice is used with AJAX AutoComplete Extender /// to populate possible car makes for textbox on Sell Your Car form /// </summary> [ ScriptService ()] [ WebService (Namespace = "http://tempuri.org/" )] [ WebServiceBinding (ConformsTo = WsiProfiles .BasicProfile1_1...

Hi All, Following my previous post I have solved this issue. Somehow accidently I discovered that if the field has allow nulls set on it VB.NET will add the Where Coalesce in your query hence in my case slowing it down dramatically. It seems that C# does not do this. So finally I have my VB.NET sql comming...

Hi All, I am currently working on a project and we are using VB.NET, I am using LINQ to SQL for my data access. I have just implemented my search query and thought I would check the generated SQL's execution plan and found that the subtree cost was about 7.3. I know that I get different SQL between C#...

In the world of .NET programming, ADO.NET has become the De Facto standard for accessing database of all types (relational or otherwise). The purists among us will be quick to point out that ADO.Net should be the only option and that as developers we shouldn’t even be thinking about bypassing ADO.NET...

Hey All, Had a query which I was paging on the front end. I knew that a certain product was meant to be in my display but could not see it. But on page 2 a product would repeat itself. Odd, got into profiler and looked at the queries. The first page would get a select top 9 which would not do any orderby...

Hi All, Have run into some issues with using default values in my SQL database with LINQ. I set AutoGenerated in the LINQ Designer to true which made use of my default values but this did not let me update this manually as it would throw an exception. I got a good suggestion from Young Joo to keep autogenerated...