(Tibor Karaszi) Never? You are not alone. None of the maintenance solutions I use includes functionality to rebuild a heap, and that includes Maintanance Plans and Ola Hallengren’s maintenance solution.
Author: SSWUG Research
SSMS Tip: Merging ERRORLOGs from different machines using Log File Viewer
(blakhani) For those who don’t know what/where is SQL Server ERRORLOG, please read this
Increasing Buffer Pool in SQL Server 2014
(Daniel Farina) Under heavy load your SQL Server may not work as intended due to lack of resources. To handle this situation SQL Server 2014 gives us the possibility to use an SSD or Ram device to dynamically increase the Buffer Pool. Keep reading to see how you can take advantage of this new wonder
Using jQuery $() Function and Animation and an Image Carousel Example
(manish.patil) Below is a very simple example of how to consume and use jQuery in HTML pages. The example will show some features of jQuery, like jQuery selectors() and animation. And to tie everything together, we will create a simple image carousel. Our on screen image carousel will loop through a
PostgreSQL 9.3 – Shared Buffers Performance (1)
(Hans-Juergen Schoenig) A lot has been said about PostgreSQL shared buffers and performance. As my new desktop box has arrived this week I decided to give it a try and see, how a simple benchmark performs, given various settings of shared_buffers.
Using IBM Integration Bus in a .NET Environment
(Eric Berg) Many organizations that have made .NET an important part of their IT landscape will start with the belief that BizTalk Server is the logical choice for an integration platform. What I wanted to do in this post is point out some of the capabilities delivered by IBM Integration Bus (IIB)
Index Rebuild, the Need vs the Implications Support Note 989093.1 (Getting Better)
(Richard Foote) Once upon a time, Oracle Support had a note called Script: Lists All Indexes that Benefit from a Rebuild (Doc ID 122008.1) which lets just say I didn’t view in a particularly positive light 🙂 Mainly because it gave dubious advice which included that indexes should be rebuilt if:
Performance Tuning for ASP.Net applications
(Pratap Bhaskar) What I have noticed in most of the projects that I have been part of is that the Performance is considered as a least priority feature. Well its definitely not a feature, performance should be built in each feature and measured as early and frequently as possible.
Create Portlet Using jQuery
(Anubhav Chaudhary) This article explains how to create a Portlet using jQuery.
The MySQL ARCHIVE storage engine – Alternatives
(Przemys³aw Malkowski) In my previous post I pointed out that the existing ARCHIVE storage engine in MySQL may not be the one that will satisfy your needs when it comes to effectively storing large and/or old data. But are there any good alternatives? As the primary purpose of this engine is to stor