The following is a stored procedure you can use when you want to quickly identify procedures in your SQL Server database which are taking up excessive CPU time. The script returns 3 recordsets: The number of active connections by database name, with login name and hostname All stored procedures with...
Find Inefficient T-SQL Stored Procedures
Posted in Database on Friday, May 29 2009 by Nick Kewney
Migrating a SQL Server Database to Oracle 11g
Posted in Database on Saturday, April 19 2008 by Nick Kewney
After attending a session with an Oracle consultant this week, I thought I'd share with you some tips for migrating an SQL server database to the Oracle platform. Firstly, let's get one thing clear. I love SQL Server. I use it for 99% of projects I do. However, for a particular project I'm working on...