(Pinal Dave) This is a very interesting wait type and quite often seen as one of the top wait types. Let us discuss this today.
Other News
Size Matters
Kalen Delaney Virtual Workshop: SQL Server 2008 Indexes – Internals and Best Practices – This Friday Feb. 25, 2011 – Along with a good database design I would say that Indexes are a cornerstone to good database performance. There are a lot of other skills you can develop in relational databases; but without these two skills, you’re going to find […]
Does Your SQL Server Service Have Too many Permissions?
SelecTViews Shows to Watch: SelecTViews – Open source projects and SQL Server, FrontPage Lives?!, Business Intelligence is profiling…. or is it? SQL Server tools and the cloud, featured blog, Chris Shaw on the show and MUCH more. [Watch the Show] Previously… Database applications and tablet devices, toasters (er, appliances), and the SQL Server Tip of the Day. Also, Wendy Pastrick, […]
Tips for Easier Unit Testing in C#
(Patrick Steele) Many of the complaints of writing unit tests are that they take a long time to write or that they are “boring” to write. While I can’t help conquer the “boring” part, this article will look at approaches that make writing unit tests easier so that you’re more inclined to do it.
Oracle XML capabilities in Oracle Database 11gR2, part 2
(Jeff McCormick) Now that our XML and relational structures are defined, we can query and manipulate the XML data. Notice the following insert, update and delete code statements operate directly against the XML table.
What is DocBook
(Darla Ferrara) DocBook is a division of standards originally designed for technical documents. When writing pages in DocBook format, you use basic XML rules to produce valid code. However, unlike standard XML, DocBook provides definitions for the elements.
Behavioral Design Pattern for .NET: Part 2
(Nipun Tomar) Behavioral Design patterns are the patterns for .Net in which there is a way through which we can pass the request between the chain of objects, or we can say that it defines the manner to communicate between classes and object.
Add Simple Ajax Paging to Grids in ASP.NET MVC
(Chris Bennett) In standard ASP.NET it is very easy to implement a full featured data grid with paging. With the help of an UpdatePanel you can improve the user experience of paging data in grids by taking advantage of Ajax (Asynchromous JavaScript And XML).
When DataTable.Select() Is Slow, Use DataView.FindRows()
(Arno) ADO.NET’s DataTable.Select() comes with a runtime complexity of O(N). This turns into a problem when DataTable contains a lot of rows, and/or when DataTable.Select() is invoked many times.
Why SELECT-INTO, eh?
(Michael McLaughlin) Somebody raised the question about writing stored functions while we were discussing scalar subqueries against COMMON_LOOKUP tables. Common look up tables store collections of possible elements. They’re basically generalized tables that contain a set of smaller tables,