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
179 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
50 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
93 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
36 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
497 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
75 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
48 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
59 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
102 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
54 reads
Blogs
The Mystery of the Locked-Up Database -Scooby Dooing Episode 6
No Scooby-Doo story is complete without footprints leading to a hidden passage. In SQL...
The Challenge of Implicit Transactions: #SQLNewBlogger
By Steve Jones
I saw an article recently about implicit transactions and coincidentally, I had a friend...
SQL Server Is Slow – Part 2 of 4(?)
By Kevin3NF
The 10-Minute Outside-In Triage Don’t Blame SQL First It’s 9:05 AM and your helpdesk...
Forums
Changing the Recovery Time
Comments posted to this topic are about the item Changing the Recovery Time
Getting More Time from AI
Comments posted to this topic are about the item Getting More Time from AI
When Page Prefetching Takes a Back Seat – Exploring Trace Flag 652 in SQL Server
Comments posted to this topic are about the item When Page Prefetching Takes a...
Question of the Day
Changing the Recovery Time
I want to change the recovery time for a database running on SQL Server 2022. What are my options for setting the value in my ALTER DATABASE statement. If I run this code, what can I use in place of the xxx to define what 12 means?
ALTER DATABASE Finance SET TARGET_RECOVERY_TIME = 12 xxx;See possible answers