(Peter Shaw) Hands up; how many of you have only really ever used LINQ for database access? How many of you only ever really believed it was for database access? Well it’s not, it’s potentially very useful in all manner of scenarios.
Other News
Message Queues in SQL
I have written here on SSWUG a few times with tips or articles about how to use SQL Server tables as a queue. It’s rather simple to do and quite effective. Today I wanted to ask a few questions about this practice. There are some alternatives available today that you could use for queuing instead. For example, you could use […]
Tips for using SQL Server 2014 triggers
Tips for using SQL Server 2014 triggers Try to minimize the DML trigger’s code size. Triggers fire during INSERT, UPDATE, or DELETE statements, so the more code that runs in the trigger, the slower each INSERT, UPDATE, and DELETE that fires it will be. Use cascading referential integrity constraints instead of triggers whenever possible. For example, if you need to...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
DB2 Tips n Tricks Part 40 – How to Find DB was implicitly or explicitly activated or deactivated
(Harishkumar Baburao Pathangay) How to Find if a Database was implicitly or explicitly activated or deactivated
DB2 Health Checks – Part Two
(Craig S. Mullins) In the first part of this series on DB2 health checks, DB2 Health Checks – Part One, I discussed the general concept of a health check and their basic importance in terms of maintaining a smooth-running DB2 environment.
IBM InfoSphere Optim Data Growth: Setting up your first Archive
(Satvinder Kaur) This article introduces IBM InfoSphere Optim Solutions, which help you manage enterprise data in every phase of the information lifecycle. Learn the fundamentals of InfoSphere Optim Data Growth Solution. A step-by-step example shows how to set up your first Archive request and quick
Easy Method to Split Large XML File Using LINQ to XML
(ravgill66) You have a large well formed XML file which you wish to split into smaller manageable files. Each output file is also a well formed XML file.
Understanding and using tokens in Oracle #GoldenGate
(Bobby Curtis) Recently, I’ve been doing some work with a client where tokens need to be used. It came to my attention that the basic usage of tokens is misunderstood. Let’s see if I can clear this up a bit for people reading.
Implications of threaded_execution = true in 12c
(Martin Bach) I had an interesting discussion as part of my latest presentation at the UKOUG RAC CIA & Database Combined SIG. Part of my talk was about the implications of the new threaded execution model in Oracle.
ADF Performance Monitor: Measuring Slow Network Time
(Frank Houweling) Recently I was implementing the ADF Performance Monitor at a customer site and doing a detailed performance analysis. This customer had severe (and less severe) performance problems but was unable to pinpoint the exact pain points.