nnnnnUsing Excel to Pull Data from SQL ServernUsing Excel to Pull Data from SQL ServernMichael SchmalznnBefore I start, I want to emphasize that this example uses Excel for the functionality as opposed to Enterprise Manager or any of the SQL…

nnnnn>On 2004-11-08, Petterson Mikael wrote:n>n>>>> How can I determine the directory where my script is run from.n>>>> I need to use that to assign a variable $MY_HOME. It will be used whenn>>>> I call files that are in the same…

nnnnnSQL Server Hardware Performance Checklist: “SQL Server Hardware Performance ChecklistnnBrad M. McGehee | Contributing Writer | 2004-12-10nnnAuditing SQL Server Hardware Is An Important Early StepnnFrom this previous article, on using Performance Monitor, you may have identified some potential hardware bottlenecks…

nnnnnxbindkeys nnA great meta-key for use with XBindkeys is the “Windows” key, which sits idly on so many keyboards. Chances are it’s unused, so it won’t conflict with anything. Say you have a script called “backup” that you like to…

nnnnnStart. 1. add the following to init.ora file log_archive_start = true log_archive_dest = /path/to/archive/dir log_archive_format = _%s.log 2. Starting archive logging startup mount exclusive alter database archivelog; alter database open; 3. Check to make sure SQL> archive log list Database…

nnnnn Make the tablespace Read-Only = alter tablespace xxxx read only; Export it connecting as sys as sysdba = exp file=tt.dmp log=tt.log tablespaces=xxxx transportable_tablespaces=y Copy the .dmp file and the data_files to the destination Put the tablespace back in write…

nnnnnschedule a job which uses the undocumented call xp_fixeddrives Or you can try with master..xp_cmdsh

nnnnn Datafile I/O DATAFILE I/O NOTES: File Name – Datafile name Physical Reads – Number of physical reads Reads % – Percentage of physical reads Physical Writes – Number of physical writes Writes % – Percentage of physical writes Total…