Implementing Infinite Scroll With ASP.Net MVC 4
There are a lot of ways you could implement this but in this case I will be using the following…
ASP.Net...
2012-05-10
176 reads
Gavin Draper
SQL Server Indexed Views Explained
Indexed views are a really powerful and possibly underused feature of SQL Server. It’s basically a way of writing a...
2012-05-02
48 reads
Exposing OData Endpoints using the ASP.Net MVC Web API
The new Web API that comes with ASP.Net MVC 4 has been getting a lot of posts on creating RESTful...
2012-04-28
91 reads
Using Databases on WP7
From version 7.5 (Mango) WP7 runs a version of SQL Server CE which is all setup waiting for your applications...
2012-04-12
35 reads
SQL Server Isolation Levels By Example
Isolation levels in SQL Server control the way locking works between transactions.
SQL Server 2008 supports the following isolation levels
Read Uncommitted...
2012-02-18
496 reads
Building Visual Studio Deployment Projects With MSBuild
I recently hit what I would call a fairly serious limitation of MSBuild and that is that it cant build...
2012-02-17
72 reads
Debugging WP7s Isolated Storage
As part of the Windows Phone SDK you get the IsolatedStorageExplorerTool, this tool allows you to explore and update what...
2012-02-12
47 reads
Thread Synchronization/Locking In .Net
When you are creating multiple threads that need to access a shared resource then you need to implement some form...
2012-02-05
57 reads
App Domains and Their Uses
What is an app domain
An App Domain can be thought of as a kind of lightweight process. So What is...
2012-01-31
99 reads
Using TDD To Create A Working Application In C# : Part 2
Last FM Wrapper
You know that web project we created? You can completely forget about that for now as this is...
2012-01-14
53 reads
Blogs
Understanding Zonal Redundancy in Azure SQL MI
By Arun Sirpal
Do you know what happens when you enable zonal redundancy for your SQL managed...
SQL Server Database Compatibility Levels
By Kevin3NF
Why You Shouldn’t Overlook This Quiet but Critical SQL Server Setting If you’ve...
The PASS Summit on Tour in the Netherlands
By Steve Jones
The PASS Summit goes on tour this year, with the final date the first...
Forums
How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory
Comments posted to this topic are about the item How a Legacy Logic Choked...
Cycle Logs (non-error log)
Hello all, I am hoping that this is an easy question and I'm just...
Execution plan shows enormous number of records
The problem was reported to us by a customer. They shared a graphic execution...
Question of the Day
The Updated Columns List
I have this table in SQL Server 2022:
CREATE TABLE CustomerLarge (CustomerID INT NOT NULL IDENTITY(1, 1) CONSTRAINT CustomerLargePK PRIMARY KEY CLUSTERED , CustomerName VARCHAR(20) , CustomerContactFirstName VARCHAR(40) , CustomerContactLastName VARCHAR(40) , Address VARCHAR(20) , Address2 VARCHAR(20) , City VARCHAR(20) , CountryCode CHAR(3) , Postal VARCHAR(20) ) GOIf I check the columns_updated() function return in a trigger, what is the data returned? See possible answers