Author: bsingh@yahoo.com

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 Server User Interface functionality. In the first article that I wrote about getting data from…

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 directory or subdirectory to myn>>>> executing script.n>n>>n>> Maybe this one?n>> #vn>> MY_HOME=`which $0`n>> #v-nnnwhich is…

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 that are negatively affecting your SQL Server’s performance. In this section, we will take a…

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 run manually. This is how to bind it to the “Windows” and F5 keys with…

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 log mode ARCHIVELOG Automatic archival ENABLED Archive destination /path/to/archive/dir Oldest online log sequence 2 Current…

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 mode = alter tablespace xxxx read write; In the destination offline and drop the tablespace…

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 Block I/O’s – Number of I/O blocks Use this report to identify any “hot spots”…