Optimizing Nested Query in SQL Server
My friend has been asked to optimize the SQL query for a forum application. Basically the Query is used to list the thread as well as the last person who posted on the forum. He and…
-
-
Recursive SQL using CTE in SQL Server 2005
How to do a recursive query in SQL Server 2005, Recursive in the terms of you got a table where it has foreign key to the other record on the same table. Assume a table employee…
-
Paging in Order BY using LINQ
This is a simple way of doing the paging in LINQ. If I do the paging before the ORDER BY then it will give me different result set. The paging is should be after the ORDER…
-
Inserted Table and Deleted Table On SQL Server
this is only a simple trigger and table to monitor the activity on an update activity to “members” table. it tracks the date when the update query is being executed and who execute it, it will…
-
Undo compressing old files by windows
My computer was losing its graphic card driver and somehow losing sound as well and I realised that i’ve been compressing the old files via disk clean up. I thought i want to do reformat my…
-
Find a control in ContentPlaceHolder
I have a user control and I would like to hide a control on the page container that host this user control. I try to use Page.FindControl(“litContent”) But It throws an error of object not found.…
-
AJAX Update Panel Timeout Issue
I have an asp.net page where the page will query the report from the database. To query the report itself might cause timeout exception on the page itself before the report result is being returned from…
-
Simple LINQ Tutorial
I’ve started learning about LINQ because I need to keep up to date with the latest technology out there. I’ve created a simple Business Layer which interact directly with Linq to SQL(DBML). It includes Insert, Update,…