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...
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...
Satya, The server already is running on default configuration (thread mode).
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...
Hi all, I completely aware of these recommendations. Let me state again. BUILINAdministrators is intack with sysadmin rights. Domain account is...
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...
Luis, I used msdb.dbo.backupset and master.dbo.sysdatabases tables to verify last time backup ran. What are metadata or system tables that I can...
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...
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...
Separate names with a comma.
