Cursors 1 Sets 0

Posted by GrumpyOldDBA on SQL Blogcasts See other posts from SQL Blogcasts or by GrumpyOldDBA
Published on Tue, 23 Mar 2010 19:33:26 GMT Indexed on 2010/03/23 20:23 UTC
Read the original article Hit count: 728

Filed under:

Code Tuning

|

diagnostics

|

General Tuning

|

sql2008

I had an interesting experience with a database I essentially know nothing about. On the server is a database which stores session state, Microsoft provide the code/database with their dot net, so I'm told. Anyway this database has sat happily on the production server for the past 4 years I guess, we've finally made the upgrade to SQL 2008 and the ASPState database has also been upgraded. It seems most likely that the performance increase of our upgrade tipped the usage of this database into...(read more)

© SQL Blogcasts or respective owner

Related posts about Code Tuning

WebLogic Server Performance and Tuning: Part I - Tuning JVM

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Each WebLogic Server instance runs in its own dedicated Java Virtual Machine (JVM) which is their runtime environment. Every Admin Server in any domain executes within a JVM. The same also applies for Managed Servers. WebLogic Server can be used for a wide variety of applications and services… >>> More
Soapi.CS : A fully relational fluent .NET Stack Exchange API client library

as seen on Stackapps - Search for 'Stackapps'
Soapi.CS for .Net / Silverlight / Windows Phone 7 / Mono as easy as breathing...: var context = new ApiContext(apiKey).Initialize(false); Question thisPost = context.Official .StackApps .Questions.ById(386) .WithComments(true) .First(); Console.WriteLine(thisPost.Title); thisPost … >>> More
Super Joybox 5 HID 0925:8884 not recognized as joystick in Ubuntu 12.04 LTS

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
Problem: When using the "Super JoyBox 5" 4 port playstation 2 to USB adapter, the device is not recognized as a joystick. there is no js0 created, but instead another input eventX and mouseX are created in /dev/input. When using the directional buttons (up down left right) on a Playstation 1 controller… >>> More
SQLAuthority News – A Successful Performance Tuning Seminar at Pune – Dec 4-5, 2010

as seen on SQL Authority - Search for 'SQL Authority'
This is report to my third of very successful seminar event on SQL Server Performance Tuning. SQL Server Performance Tuning Seminar in Colombo was oversubscribed with total of 35 attendees. You can read the details over here SQLAuthority News – SQL Server Performance Optimizations Seminar – Grand… >>> More
VS 2012 Code Review – Before Check In OR After Check In?

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
“Is Code Review Important and Effective?” There is a consensus across the industry that code review is an effective and practical way to collar code inconsistency and possible defects early in the software development life cycle. Among others some of the advantages of code reviews are, Bugs… >>> More

Related posts about diagnostics

Add Trace methods to System.Diagnostics.TraceListner

as seen on Stack Overflow - Search for 'Stack Overflow'
I wrote a Log class derived from System.Diagnostics.TraceListener like so public class Log : TraceListener This acts as a wrapper to Log4Net and allows people to use System.Diagnostics Tracing like so Trace.Listeners.Clear(); Trace.Listeners.Add(new Log("MyProgram")); Trace.TraceInformation("Program… >>> More
The Benefits of using Oracle Diagnostics for Oracle Applications

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Listen to Kurt Larsen, Vice President of Oracle Support provide an update on the cost savings and problem avoidance provided to customers using Oracle Diagnostics within the E-Business Suite! >>> More
EBS: How To Install Oracle Diagnostics

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Oracle Diagnostics Support Pack is available as a patch and can be applied using adpatch. Installation is easy. Just follow the steps in Doc ID 167000.1, eBusiness Suite Support - Oracle Diagnostics Support Pack Installation Guide For information on how to run the Diagnostics from a menu within… >>> More
Hello it’s your server calling

as seen on SQL Blogcasts - Search for 'SQL Blogcasts'
This is nothing exciting but I've always found this startup procedure very useful. All this simple procedure does is send you an email if the SQL Service Starts. If your Server is a cluster it will tell you which node you're on. -- On it's own this procedure can't actually be… >>> More
Cursors 1 Sets 0

as seen on SQL Blogcasts - Search for 'SQL Blogcasts'
I had an interesting experience with a database I essentially know nothing about. On the server is a database which stores session state, Microsoft provide the code/database with their dot net, so I'm told. Anyway this database has sat happily on the production server for the past 4 years I guess… >>> More