(Serge Rielau) Remember the days when DB2 re-entered the TPC-C fight after a long hiatus?
Other News
Parameter Wednesday – DB CFG – pckcachesz
(Ember Crooks) Specifies size (in 4KB pages) of the area of memory used for caching static and dynamic SQL statements and information about those statements that is summarized across executions.
Under the Hood With SQL Server 2012
(Kurt Mackie) SQL Server 2012 is a large, complex product that represents Microsoft’s vision of where data is headed.
Configuring SSRS the easy way
(Roman Rehak) Configuring SQL Server Reporting Services (SSRS) was difficult in the first release of SSRS. You would have to use several command-line tools, and users had difficulty making SSRS work without calling technical support. We’ve come long way since then. There’s a new tool called Reportin
Common Table Expressions (CTE) for SQL Server Developers
(Dinesh Asanka) A CTE is a temporary view that exists only in the scope of running query. A CTE is similar to a view but a CTE is embedded into the query. CTEs can be used in Stored Procedures, User Define Functions (UDFs), Triggers and Views but not in Indexed Views.
SQL SERVER – Identify Columnstore Index Usage from Execution Plan
(Pinal Dave) I think there was a time when lots of questions were coming via either email or blog comments. Now a days, the trend is changed in recent time. Most of the question I receive is through social media. Here is the latest question I received through twitter.
Different type of threads used by MySQL
(nilnandan) MySQL uses different type of threads for running specific utilities like mysql_install_db, flushes MyISAM tables, Replication, TCP/IP sockets etc. All threads can run with four different priorities like Interrupt, connect, wait and query priorities.
Implementation of XML Information Retrieval by LINQ
(farzaneh ansari) We describe all concepts according to XML corpus by its full set of words based on the tags Term frequencies, Inverse document frequencies, words from the given document are used. One of the interesting features of Language Integrated Query (LINQ, pronounced “link”) is LINQ to XML
HTML5 Inline SVG Filters
(Gaurav Gupta) In this article we are going to learn about the SVG Tag in HTML 5. SVG stands for Scalable Vector Graphics and is used to define vector-based graphics for the Web. It defines the graphics in XML format and the XML is then rendered by an SVG viewer.
How to Design Different Display for View & Edit List Item
(Bobby Chang) There are certain user scenarios that would require to display a SharePoint List Item differently in View mode vs. in Edit mode. Good news is if you have SharePoint Server 2010 Enterprise, this can be achieved within a few steps.