One of the challenges of working with large datasets or datasets that become stale is the need to move large chunks of data in and out of your tables. This can be done with large INSERT and DELETE statements or by using views, but with SQL Server 2005 data partitioning makes this task much easier t
Other News
ADF 11g Rich Faces: using clientTriggers and JavaScript API to implement client side logic in ADF Faces pages (Client Side programming in ADF Faces Rich Client Components Part 3)
(Lucas Jellema) As described in earlier postings in this series, the ADF Faces 11g RichFaces library has several facilities for client side logic to complement the already pretty rich client functionality. Among these facilities are the JavaScript API that allows client side manipulation of the comp
Managing SQL Server Updates: One Approach
SQL on Call Show Available Now The latest SQL on Call show is live now and you can watch it on the site – in today’s show Chris closes out the series of top 10 SQL Server thoughts about 2007. > Watch here Also available: [Watch] SelectViews, the SQL Server Show – Keeping up with technology, Microsoft interviews and more. […]
Max Degree of Parallelism
(Arshad Ali) When SQL Server runs on a computer with more than one microprocessor/CPU or on SMP (a computer-architecture where two or more identical processors can connect to a single shared main memory and I/O and can perform the same functions. In case of multi-core processors, the SMP architectur
IBM Education Pack – can now be used to attend IBM technical conferences
(Susan Visser) The IBM Education Pack can be used to attend IBM Technical conferences, such as Lotusphere 2008 – Orlando, Florida, USA Impact 2008 – Las Vegas, NV Automated Operations Technical Council – New Orleans, Louisiana, USA IBM Pulse 2008 (a new Tivoli Technical User Conference) – Orl
TEI: one of the main consequences of XML
(juditt) Nowadays, XML is usually thought of as a markup technique utilized by programmers to encode computer-oriented data. According to David Mertz, even DocBook and similar document-oriented DTDs focus on preparation of technical documentation. However, the real roots of XML are in the SGML commu
How pre-fetching relay logs speeds up MySQL replication slaves
(Xaprb) I dashed off a hasty post about speeding up replication slaves, and gave no references or explanation. That’s what happens when I write quickly! This post explains what the heck I was talking about.
Using Reflector to search through code and resolve .NET issues
(Tess Fernandez) As you already know, I spend my days analyzing dumps for customers, and more often than not I don’t have access to the customer’s code.
Identifying Duplicate Data in the table
In response to one of the previous blog posts on how to delete duplicate data one of our readers asked how to identify the count of the duplications. It is pretty simple and can be done by simply grouping on the columns that you need to find the duplicate occurences of.
DBMS_STATS METHOD_OPT default behaviour changed in 10g. Be careful
(Richard Foote) A question on the OTN forum has prompted me to quickly knock up a demo on the possible dangers of the default behaviour in 10g with regard to the METHOD_OPT option in DBMS_STATS.