(Bobby Durrett) I have a table with interval partitioning and subpartitions and I want to extract the DDL including all the system generated partitions and subpartitions which get created as new rows with dates beyond the last partition’s high value get inserted.
Author: SSWUG Research
Write Your Own jQuery Plugin
(Puneet Gupta) Writing your own jQuery plugin isn’t as hard as it might seem at first. This article shows the process of writing a simple plugin, adding some options and even performing a callback.
Enable and monitor ASP.NET App Suspend on Windows Server 2012 R2
(Rich Lander) ASP.NET App Suspend is a big new feature in the .NET Framework 4.5.1. You can read an overview of ASP.NET App Suspend (including a demonstration video) over on the .NET blog. ASP.NET App Suspend is a great feature for shared hosters and Enterprise IT.
How to Limit IO Requests with SQL Server 2014 Resource Governor
(Matan Yungman) Resource Governor was introduced in SQL Server 2008 in order to allow us have better control over our system resource consumption. With Resource Governor, we can divide our users to groups, when each group gets a certain percent of our resources.
Wait Statistics in SQL Server
(Kevin Kline) When it comes to troubleshooting in relational databases, there’s no better place to start than wait statistics. In a nutshell, a wait statistic is an internal counter that tells you how long the database spent waiting for a particular resource, activity, or process.
SQL Server XML EDIT(Modify)/REMOVE(Delete)/ADD(Insert)
My previous post I was discuss about XML data type and validations.This post I’m going to discuss about XML Modify(Insert/Update/Delete).
SSWUGtv: The advantage of working from home can also be its downfall.
Video Programming for IT Professionals Career management advice, coaching and much more. We discuss making the best of your professional development, provide specific tips and ideas for advancing your career and even answer questions from field.
Building a large scale WebSphere Application Server Liberty collective topology
(Brian Hanczaryk, W David Chuang and Ming-Chieh Yu)This article describes how you can build and manage a large scale Liberty collective topology with IBM WebSphere Application Server Network Deployment V8.5.5, focusing on the procedures and techniques for building a replica set, building up collecti
On MySQL plugin configuration
(Shlomi Noach) MySQL offers plugin API, with which you can add different types of plugins to the server. The API is roughly the same for all plugin types: you implement an init() function, a deinit(); you declare status variables and global variables associated with your plugin, and of course you im
Differences Among Bind(), Live(), Delegate(), Trigger() in jQuery
(Arpit Jain) In this article we will learn about the live(), bind(), click(), delegate(), trigger(), and triggerHandler() methods for adding event handlers to elements. They are one of the most confusing parts of jQuery library and if you are working on any big project and want a top-class user int