(Paul Randal) Back in February I ran a bunch of performance tests of DBCC CHECKDB on SSDs, to evaluate the effects of degree-of-parallelism (DOP) and various options and traceflags, and now I’m finally getting around to presenting the results. Make sure to also read the recent post where I talk abou
Author: SSWUG Research
ORA-01466 (SET TRANSACTION READ ONLY – Part 1)
(Andrew Reid) Going through some SQL*Plus course notes from 1990 (as you do) I came across the SET TRANSACTION READ ONLY statement and decided to try it out in an Oracle 11.2 database.
jQuery and JSON dataset binding
(Success_sivagiri) In this tip we will see how to use jQuery and JSON to call a method to bind the grid or get data from a database and loop it and assign to any control at the client level.
Viewing SQL Server Non-Clustered Index Page Contents
(Tim Chapman) In this blog post I’ll take a look at what is actually stored in a non-clustered index and (re)introduce you to some tools that you can use for looking at the contents of a given data or index page.
Fun with CHAR
(chet justice) I’m busy deriving file layouts from PL/SQL. Probably close to 100 file definitions…each of them slightly different, each of them defined in the code. Fun!
How to recover corrupted data blocks using ‘recover tablespace’ RMAN syntax
(Marco V.) This post finishes a series of previous posts related to the recovery process of corrupt data blocks:
WebAPI Tip #8: Working with Tasks
(K. Scott Allen) Message handlers in the WebAPI feature a single method to process an HTTP request and turn the request into a response. SendAsync is the method name, and following the TAP, the method returns a Task.
Java API for JSON Processing (JSR-353) – Stream APIs
(Blaise Doughan) Java will soon have a standard set of APIs for processing JSON as part of Java EE 7. This standard is being defined as JSR 353 – Java API for JSON Processing (JSON-P) and it is currently at the Final Approval Ballot.
Limiting Loop Parallelism
(Richard Carr) For most parallel loops it’s fine to allow the Task Parallel Library to determine the level of parallelism. The number of concurrent operations is set automatically to try to achieve better performance. In other cases it’s important to limit parallelism.
ASP.NET 4.5 – FAQs on SignalR Script Exceptions
(Vincent Maverick S. Durano) ASP.NET SignalR is pretty new and very exciting feature in ASP.NET. You might want to play around with it and may encounter some hiccups during your implementation. This post will cover some issues that you may encounter and how to avoid it.