Search Results

Adhoc vs PROC

Thread by: kmounkhaty, Jan 4, 2007, 1 replies, in forum: Performance Tuning for DBAs

Hi Guru, When I ran my adhoc script below it generated only 45000 reads or 4 seconds but when I wrapped it into procedure it took about two minutes...

SQL Auditing

Thread by: kmounkhaty, Dec 19, 2006, 2 replies, in forum: SQL Server 2005 General DBA Questions

Hi Guru, I turned on the Failure option on the audit level to capture failed login attempts on my SQL 2000 cluster server. However, the failed login...

Error: 14258

Thread by: kmounkhaty, Nov 21, 2006, 4 replies, in forum: SQL Server 2005 General DBA Questions

Hi Guru, I just found out that one of my SQL 2005 reporting server is experiencing this issue. "Error 14258: Cannot perform this operation while...

Can't start the SQLAGENT

Thread by: kmounkhaty, May 10, 2006, 4 replies, in forum: General DBA Questions

Hi Guru, I'm tired of trouleshoot one of my sql box that the sqlagent can't started. Here is the message: SQLServerAgent could not be started...

Script to find last time Cubes get processed

Thread by: kmounkhaty, May 2, 2006, 3 replies, in forum: Analysis Services/Data Warehousing

Hi Guru, Where can I find OLAP tables Metadata? I want to query metadata to find out when was last time the cube ran? I schedule the cube to...

Migrating Oracle corrupted tables

Thread by: kmounkhaty, Feb 27, 2006, 1 replies, in forum: Performance Tuning for DBAs

Hi Guru, We have an old Oracle 8.1.7 version sitting on WIN2003 server but it's a staging server. We're planning to migrate this staging Oracle...