HSN

Seven Tips for SQL Server Production DBAs

2009-12-10T18:34:00.000-08:00

Use Forfiles utility (forfiles.exe) to delete old database backup files:forfiles /p "e:\sqlbackup" /m "*.bak" /c "cmd /c del /Q @path" /d -2Use ALTER USER WITH LOGIN to repair orphaned logins.Use sp_addsrvrolemember to give yourself the sysadmin role. Use the PortQryUI utility to troubleshoot connectivity problems. Use a different strategy when running DBCC CHECKDB against large databases. Use

HSN: MSSQL DBA daily jobs

2009-12-09T01:23:00.000-08:00

HSN: MSSQL DBA daily jobs

MSSQL DBA daily jobs

2009-12-09T01:19:00.002-08:00

Daily maintenance jobs:Backup database.Check database integrity: check primary key etc.History cleanup: log history archive.Check indexes: rebuild index, re-organize index etc.Shrink database.Daily monitoring jobs:Monitor database connections.Monitor physical storage usage.Monitor memory usage: cache hits ratio, page reads, writes/sec etc.Monitor CPU usage.Monitor physical disk I/O, network

HSN: Oracle DBA checklist

2009-12-09T01:19:00.000-08:00

HSN: Oracle DBA checklist

Oracle DBA checklist

2009-12-09T01:18:00.000-08:00

Daily proceduresVerify all instances are up: run daily reports or via "Oracle Enterprise Manager's 'probe' event"Look for any new alert log entries: Check ORA-errors in $ORACLE_BASE//bdump/alert_.logVerify success of database backupVerify success of database archiving to tapeVerify enough resource for acceptable performance:a. Verify free space in tablespaces (free.sql, space.sql)b. Verify

HSN: 股票买卖操盘策略

2009-12-09T00:41:00.000-08:00

HSN: 股票买卖操盘策略

股票买卖操盘策略

2009-12-09T00:30:00.000-08:00

根据美国次贷危机，中国A股崩盘，网络泡沫破裂，911危机及亚洲金融风暴经验，股市通常会下跌到1/5位置，甚至会到达1/10，在此调整操盘策略：买入:跌幅百分比买入金额-20% 81% 1000 (短期）：从近期高处下跌-20% 63% 1 / 4 （短期）-20% 45% 1 / 3 （中期）-20% 36% 1/2 （中期）-20% 25% 1 （长期）-20% 15% reserved 1/2 （长期）卖出:涨幅百分比卖出金额 +30% 130% 1000 (短期）：从近期低处上涨+30% 170% 1 / 4 （中期）：中期走势+30% 220% 1 / 3 （中期）+30% 280% 1 / 2 （长期）+30% 350%

HSN: Replication Configuration Between MSSQL 2005 and Oracle

2009-12-09T00:19:00.001-08:00

HSN: Replication Configuration Between MSSQL 2005 and Oracle

HSN: VMs vs. Multiple SQL Server Instances

2009-12-09T00:19:00.000-08:00

HSN: VMs vs. Multiple SQL Server Instances

HSN: Steps to set up oracle database RAC

2009-12-09T00:18:00.000-08:00

HSN: Steps to set up oracle database RAC

HSN: 基金买卖操盘方式

2009-12-09T00:17:00.001-08:00

HSN: 基金买卖操盘方式

HSN: 我的投资策略

2009-12-09T00:17:00.000-08:00

HSN: 我的投资策略

HSN: 如何从MACD指标研判股市走势?

2009-12-09T00:16:00.000-08:00

HSN: 如何从MACD指标研判股市走势?

HSN: Dollar Cost Averaging

2009-12-09T00:14:00.000-08:00

HSN: Dollar Cost Averaging

HSN: 4 ways to be a millionaire

2009-12-09T00:10:00.001-08:00

HSN: 4 ways to be a millionaire

HSN: All Money Sense

2009-12-09T00:10:00.000-08:00

HSN: All Money Sense

HSN: Linux User Guide (2)

2009-12-09T00:09:00.000-08:00

HSN: Linux User Guide (2)

HSN: Linux User Guide (1)

2009-12-09T00:08:00.000-08:00

HSN: Linux User Guide (1)

HSN: Oracle Dictionary - DBA Views

2009-12-08T23:43:00.002-08:00

HSN: Oracle Dictionary - DBA Views

HSN: Oracle Dictionary - All Views

2009-12-08T23:43:00.001-08:00

HSN: Oracle Dictionary - All Views

HSN: Oracle Dictionary - Dynamic Views

2009-12-08T23:43:00.000-08:00

HSN: Oracle Dictionary - Dynamic Views

HSN: Oracle Dictionary - User Views

2009-12-08T23:42:00.000-08:00

HSN: Oracle Dictionary - User Views

HSN: SCJP 310-035 Sample Questions (1)

2009-12-08T23:33:00.000-08:00

HSN: SCJP 310-035 Sample Questions (1)

HSN: Sun Certified Web Component Developer 310-081 Sample Questions

2009-12-08T23:32:00.001-08:00

HSN: Sun Certified Web Component Developer 310-081 Sample Questions

HSN: J2EE Patterns

2009-12-08T23:32:00.000-08:00

HSN: J2EE Patterns

HSN: Catalog of design patterns

2009-12-08T23:31:00.001-08:00

HSN: Catalog of design patterns

HSN: Configure MSSQL to use more than 2GB RAM

2009-12-08T23:31:00.000-08:00

HSN: Configure MSSQL to use more than 2GB RAM

HSN: MCTS 07-431 Sample Questions (1)

2009-12-08T23:30:00.001-08:00

HSN: MCTS 07-431 Sample Questions (1)

HSN: MSSQL 2005 Knowledge Base 1

2009-12-08T23:30:00.000-08:00

HSN: MSSQL 2005 Knowledge Base 1

HSN: Using LogMiner to analyze transaction history

2009-12-08T23:28:00.000-08:00

HSN: Using LogMiner to analyze transaction history

HSN: How to query server and client environment in PL/SQL

2009-12-08T23:26:00.002-08:00

HSN: How to query server and client environment in PL/SQL

HSN: OCA references

2009-12-08T23:26:00.001-08:00

HSN: OCA references

HSN: OCP References

2009-12-08T23:26:00.000-08:00

HSN: OCP References

HSN: 1Z0-043 sample questions (1)

2009-12-08T20:03:00.001-08:00

HSN: 1Z0-043 sample questions (1)

HSN: 1Z0-042 sample questions (1)

2009-12-08T20:03:00.000-08:00

HSN: 1Z0-042 sample questions (1)

HSN: Steps to set up oracle database RAC

2009-12-08T19:53:00.000-08:00

HSN: Steps to set up oracle database RAC

基金买卖操盘方式

2008-01-18T22:55:00.001-08:00

买入:跌幅百分比买入金额-20% 81% 1000 (短期）：从近期高处下跌-10% 72% 1 / 3 （中期）-10% 63% 1 / 2 （中期）-10% 54% 1 （长期）-10% 45% reserved 10k （长期）-10% 34% reserved 20k （长期）卖出:涨幅百分比卖出金额 20% 120% 1000 (短期）：从近期低处上涨20% 144% 1 / 4 （中期）：中期走势20% 172% 1 / 3 （中期）20% 206% 1 / 2 （长期）20% 247% 1 （长期）取参照点:以上一次拐点为参照点.举例:A涨B跌C

Oracle Dictionary - Dynamic Views

2008-01-03T20:12:00.000-08:00

SQL> SELECT * FROM DICT WHERE TABLE_NAME LIKE 'V$%' ORDER BY TABLE_NAME;TABLE_NAME COMMENTS------------------------------ ----------------------------------------------------------------------------------------------------V$ACCESS - Synonym for V_$ACCESSV$ACTIVE_INSTANCES - Synonym for V_$ACTIVE_INSTANCESV$ACTIVE_SERVICES -

Oracle Dictionary - User Views

2008-01-03T20:11:00.002-08:00

SQL> SELECT * FROM DICT WHERE TABLE_NAME LIKE 'USER_%' ORDER BY TABLE_NAME;TABLE_NAME COMMENTS------------------------------ ----------------------------------------------------------------------------------------------------

Oracle Dictionary - All Views

2008-01-03T20:11:00.001-08:00

SQL> SELECT * FROM DICT WHERE TABLE_NAME LIKE 'ALL_%' ORDER BY TABLE_NAME;TABLE_NAME COMMENTS------------------------------ ----------------------------------------------------------------------------------------------------ALL_ALL_TABLES - Description of all object and relational tables accessible to the userALL_APPLY - Details about each

Oracle Dictionary - DBA Views

2008-01-03T19:55:00.000-08:00

SQL> SELECT * FROM DICT WHERE TABLE_NAME LIKE 'DBA_%' ORDER BY TABLE_NAME; TABLE_NAME COMMENTS------------------------------ ----------------------------------------------------------------------------------------------------DBA_2PC_NEIGHBORS - information about incoming and outgoing connections for pending transactionsDBA_2PC_PENDING

我的投资策略

2007-12-09T05:47:00.000-08:00

1. 只买不卖,长期投资.在熊市中持续买入优质股,坚持持有至20年后才等待机会卖出.熊市定义:从高出下跌50%以上,每半年买一次,每次2K - 10K.板块优质股:a. 金融1) 000001 深发展 2) 002142 宁波银行 3) 601009 南京银行 4) 601166 兴业银行 5) 601169 北京银行6) 601318 中国平安 7) 601628 中国人寿 8) 601328 交通银行 9) 601998 中信银行b. 地产1) 000002 万科 2) 000024 招商地产 3) 600113 浙江东日 4) 600193 创兴置业 5) 600246 万通地产6) 600393 东华实业 7) 600463 空港股份 8) 600641 万业企业 9) 600675 中华企业 10) 600606

盘口变化盯庄家

2007-12-04T19:21:00.000-08:00

挂单心理战　　在买盘或卖盘中挂出巨量的买单或卖单，纯粹是庄家引导股价朝某方向走的一种方法。其目的一但达到，挂单就撤消。这也是庄家用来引导股价的常用手法。当买盘挂出巨单时，卖方散户心理会产生压力。是否如此大单买进，股价还会看高一线？相反，当卖盘挂出巨单时，买方散户会望而却步。斗智斗勇在盘口，散户只须胆大心细，遇事不慌，信仰坚定，暂死跟庄。　　内外盘中显真情　　内盘是以买盘价成交的成交量，也就是卖方的成交量。　　外盘是以卖盘价成的成交量，也就是买方的成交量。庄家只要进出，是很难逃脱内外盘盘口的。虽可用对敲盘暂时迷惑人，但庄家大量筹码的进出，必然会从内外盘中流露出来。　　隐形盘中露马脚　　盘口中，买卖盘面所放的挂单，往往是庄家骗人用的假象。大量的卖盘挂单俗称上盖板，大量的买盘挂单俗称下托板。而真正庄家目的性买卖盘通常是及时成交的，隐形盘虽在买卖盘口看不到，但在成交盘中是跑不了的。

Replication Configuration Between MSSQL 2005 and Oracle

2007-12-04T19:04:00.000-08:00

1. Oracle as publisher 1) Configuring an Oracle PublisherReplication modes are: snapshot and transactional replication.Preparation steps before creating a publication from an Oracle: 1.1 Create a replication administrative user within the Oracle database using the supplied script.Connect to the Oracle database using an account with DBA privileges and execute the script. This script

VMs vs. Multiple SQL Server Instances

2007-12-04T19:03:00.000-08:00

1. Performance VM can not provide the same level of performance as the physical machine, most estimated VM overhead is at 10% - 15%. 2. Software Patching VM will add more OS & software patching and administrative effort.3. Backup/Recovery & Replication VM has the advantage on backup/recovery and replication to another machine.4. Licensing Multiple SQL server

如何从MACD指标研判股市走势?

2007-12-04T19:00:00.000-08:00

MACD指标是市场上大多数投资者都熟知的分析工具，但在具体运用时，投资者可能会觉得MACD指标运用的准确性、实效性、可操作性上有很多令人茫然的地方，有时会发现用从书上学来的MACD指标的分析方法和技巧去研判股票走势，所得出的结论往往和实际走势存在着很大的差异，甚至会得出相反的结果。其中的主要原因是市场上绝大多数论述股市技术分析的书中关于MACD的论述只局限在表面的层次，只介绍MACD的一般分析原理和方法，而对MACD分析指标的一些特定的内涵和分析技巧的介绍鲜有涉及。本文将在介绍MACD指标的一般研判技巧和分析方法基础上，详细阐述MACD的特殊研判原理和功能。MACD指标的一般研判标准主要是围绕快速和慢速两条均线及红、绿柱线状况和它们的形态展开，一般的分析方法主要包括DIF和MACD值及它们所处的位置、DIF和MACD的交叉情况、红柱状的收缩情况和MACD图形的形态这四个大的方面分析。

Using LogMiner to analyze transaction history

2007-10-23T23:56:00.000-07:00

1. LogMiner Configuration There are four basic objects in a LogMiner configuration that you should be familiar with: the source database, the mining database, the LogMiner dictionary, and the redo log files containing the data of interest. # The source database is the database that produces all the redo log files that you want LogMiner to analyze. # The mining database is the database that

Steps to set up oracle database RAC

2007-06-10T02:00:00.000-07:00

Verify hardware requirementRAM - min 512MBHD - 4GBSwap - 1GBTemp - 400MBmin 2 NICTCP/IP for public NIC, UDP for interconnect NICsVerify system requirementUser groups: oinstall, dba, nobodyUser oracle's main group - oinstall, second group - dbaEnvironment variables: ORACLE_BASE, TMP, TMPDIRCustomized Kernel and open file limitsStorage - OCFS, Raw device or ASMInstall CRS (Cluster Ready Service)

Linux User Guide (2)

2007-06-09T04:57:00.000-07:00

Managing users: /etc/passwd stores all user account information, its format is: username:encrypted password:UID:GID:fullname:home directory:login shell /etc/shadow stores shadow password. 1. Adding users · Add an entry to /etc/passwd file; ·

Catalog of design patterns

2007-06-05T23:54:00.000-07:00

Scope in class level Creational: Factory Method (121) Structural: Adapter (157) Behavioral: Interpreter (274), Template Method (360) Scope in object level Creational: Abstract Factory (99), Builder (110), Prototype (133), Singleton (144) Structural: Adapter (157), Bridge (171), Composite (183), Decorator (196), Facade (208), Flyweight (218), Proxy (233) Behavioral: Chain of Responsibility (

Configure MSSQL to use more than 2GB RAM

2007-06-04T00:49:00.001-07:00

Add /pae in boot.ini Configure these in MS SQL 2000 (recommeded): awe enable 1 max server memory (MB) 30000 min server memory (MB) 30000 set working set size 1 service account has "lock pages in memory" rights memory settings are not dynamic when AWE is involved, stop and start SQL server is required for new setting takes effect. MSSQL 2005 Knowledge Base 1 MCTS 07-431 Sample Questions (1

Dollar Cost Averaging

2007-06-03T19:50:00.001-07:00

The idea is simple: spend a fixed dollar amount at regular intervals (e.g., monthly) on a particular investment or portfolio/part of a portfolio, regardless of the share price. Since in general the market goes up, this is widely considered a safe investing strategy over the long term. In fact while Dollar Cost Averaging is a relatively safe investment strategy over the long term, however it also

Linux User Guide (1)

2007-06-03T01:05:00.000-07:00

File links: Hard link: $ln source dest By using hard link, all links and original file have the same inode. Using ls command to list link information: $ls –i test

PSP, XBox, Zen Skins

2007-06-02T10:34:00.000-07:00

Sun Certified Web Component Developer 310-081 Sample Questions

2007-06-01T23:00:00.001-07:00

1. Which of the following methods is used to extract a session ID from a manually rewritten URL? A. getParameter(String name) B. getSessionID() C. getPathInfo() D. getID() 2. Which of the following is a legal exception-type description? A. javax.servlet.ServletException B. ServletException C. javax.servlet.http.UnavailableException D.

Network Articles

2007-06-01T17:48:00.000-07:00

CISCO=>

Unix Articles

2007-06-01T17:46:00.000-07:00

Linux User Guide (1) Linux User Guide (2) =>

Comics And Humor

2007-06-01T17:43:00.000-07:00

Boss Quotes =>

Boss wants to blog

2007-06-01T17:15:00.000-07:00

Yahoo CTO is leaving

2007-06-01T17:08:00.000-07:00

Aged at 45, Mr. Nazem, 45, CTO of Yahoo, will follow a turbulent year at Yahoo that included a companywide revamping. Read the full story here.

Quotes

2007-06-01T16:32:00.000-07:00

Hope is tomorrow's veneer over today's disappointment.

How to query server and client environment in PL/SQL

2007-05-31T21:46:00.001-07:00

To query the oracle server environment variables inside a pl/sql block that were set when the database was started:$ . oraenvORACLE_SID = [oracle] ? ora1022$ /usr/ucb/ps auxwwe | sed -n '/[o]ra_smon_ora1022/s/$.*$$TZ=...$$.*$/\2/p'TZ=MET$ export TZ=GMT$ printf "%s\n" "set lines 10" "var f varchar2(40)" "set autop on" \> "exec dbms_system.get_env('TZ',:f)" |> sqlplus -s / as sysdbaTo query

Market Articles

2007-05-31T00:05:00.000-07:00

All Money Sense 4 ways to be a millionaire Google's market share jumped in April RBS group raises the stakes in ABN Amro bidding Yahoo CTO is leaving Dollar Cost Averaging PSP, XBox, Zen Skins =>

J2EE Articles

2007-05-31T00:03:00.000-07:00

Catalog of design patternsSun Certified Web Component Developer 310-081 Samp...SCJP 310-035 Sample Questions (1)Answers of "SCJP 310-035 Sample Questions (1)"J2EE Patterns=>

MSSQL Articles

2007-05-31T00:02:00.000-07:00

MSSQL 2005 Knowledge Base 1 MCTS 07-431 Sample Questions (1) Configure MSSQL to use more than 2GB RAM =>

Oracle Articles

2007-05-30T23:57:00.000-07:00

OCA referencesOCP References1Z0-042 sample questions (1)Answer - "1Z0-042 sample questions"1Z0-043 sample questions (1)Answer - "1Z0-043 sample questions"How to query server and client environment in PL/SQLSteps to set up oracle database RACUsing LogMiner to analyze transaction history=>

Answer - "1Z0-042 sample questions"

2007-05-30T23:53:00.000-07:00

Click here for original questions:1Z0-042 sample questions1. A. Tables share a namespace with views, sequences, private synonyms, procedures, functions, packages, materialized views, and user-defined types. Objects sharing a namespace cannot have the same name.2. C. The database is the parameter supplied after the port designation. Therefore, you connect to the orcl database.3. C. The Memory

Answer - "1Z0-043 sample questions"

2007-05-30T23:52:00.000-07:00

Click for original questions:1Z0-043 sample questions1. A, C. The DBID and DB_KEY are required to identify the database incarnation when using SQL*Plus to query the recovery catalog tables.2. C. The correct command sequence for recovering a missing tempfile named temp is as follows:1. STARTUP MOUNT2. DROP TABLESPACE temp3. CREATE TEMPORARY TABLESPACE temp TEMPFILEThe database must be mounted, and

1Z0-043 sample questions (1)

2007-05-30T23:50:00.000-07:00

Click here for answers:Answer - "1Z0-043 sample questions"Question1. What two values are required to identify a database incarnation within the recovery catalog?A. DBIDB. DATABASE NAMEC. DB_KEYD. DATABASE_VALUE2. What is the correct command sequence for recovering a missing tempfile named temp?A. STARTUP MOUNT, CREATE TEMPORARY TABLESPACE temp TEMPFILEB. STARTUP NOMOUNT, DROP TABLESPACE temp,

1Z0-042 sample questions (1)

2007-05-30T23:48:00.000-07:00

Click here for answers:Answer - "1Z0-042 sample questions"Question1. Which of the following objects share the same namespace and therefore cannot have the same name?A. Tables and sequencesB. Tables and indexesC. Tables and tablespacesD. Tables and constraints2. You connect to the database using the command sqlplus scott/tiger@abc.com:1522/orcl. To which database are you connecting?A. abc.comB.

MCTS 07-431 Sample Questions (1)

2007-05-30T23:46:00.000-07:00

1.You have a custom application that employees use to manage product data. They often search for products based on the product description, so you decide to implement full-text search.What version of SQL Server can you use to support this? (Choose all that apply.)A. Express EditionB. Workgroup EditionC. Standard EditionD. Enterprise Edition2.In the scenario from question 9, how much space will

Answers of "SCJP 310-035 Sample Questions (1)"

2007-05-30T23:39:00.000-07:00

Click here for original questions:SCJP 310-035 Sample Questions (1) Answers:1) A, B, D. The angle-bracket notation is part of release 5.0's generic collections. See Chapter 6for more information.2) B, D. All the choices are valid method signatures. However, in order to be the entry point of an application, a main() method must be public, static, and void; it must take a single argument of type

SCJP 310-035 Sample Questions (1)

2007-05-30T23:35:00.000-07:00

Click here for answer:Answers of "SCJP 310-035 Sample Questions (1)"Questions:1)Which of the following are valid declarations? Assume java.util.* is imported.A. Vector v;B. Set s;C. Map m;D. Map m;2)Which of the following signatures are valid for the main() method entry point of an application?(Choose all that apply.)A. public static void main()B. public static

J2EE Patterns

2007-05-30T23:23:00.000-07:00

MSSQL 2005 Knowledge Base 1

2007-05-30T23:20:00.000-07:00

-- Estimating table storage requirements1. Calculate the space used by a single row of the table. Row_Size = Fixed_Data_Size + Variable_Data_Size + Null_Bitmap + Row_Header Variable_data_size = 2 + (num_variable_columns × 2) + max_varchar_size Null_bitmap = 2 + ((number of columns + 7) ÷ 8) Row_Header = 42. Calculate the number of rows that will fit on one page. 8096 ÷ (RowSize + 2)3.

OCP References

2007-05-30T23:19:00.001-07:00

(1) Advanced Security Administrator's Guide (2) Backup and Recovery Advanced User's Guide (3) Enterprise Manager Advanced Configuration (4) Globalization Support Guide (5) Secure Backup Administrator's Guide=>

OCA references

2007-05-30T23:13:00.000-07:00

(1) Oracle® Database Platform Guide10g Release 2 (10.2) for Microsoft Windows (32-Bit) (2) Oracle® Database Installation Guide10g Release 2 (10.2) for Linux x86 Number B15660-02(3) Oracle® Database Concepts10g Release 2 (10.2) Part Number B14220-02(4) Oracle® Database Administrator’s Guide10g Release 2 (10.2) Part Number B14231-02(5) Oracle® Database Security Guide10g Release 2 (10.2) Part Number

RBS group raises the stakes in ABN Amro bidding

2007-05-29T03:34:00.000-07:00

Banks add more cash to $95 billion offer, seeking to thwart rival Barclays.A consortium led by Royal Bank of Scotland on Tuesday officially launched its offer for ABN Amro, seeking to thwart rival Barclays by raising the cash portion of its 71।1 billion euros ($95.5 billion) proposal.Read full story ...

Google's market share jumped in April

2007-05-28T07:08:00.000-07:00

Web search leader Google Inc. in April showed a sharp gain in market share among U.S. Web search users, taking business from its three closest rivals, research firm comScore Inc. said on Friday.Google held 49.7 percent of the U.S. search market, up 1.4 percentage points over March.By contrast, the No. 2-ranked Web search provider, Yahoo Inc. saw its U.S. search share in April fall 0.7 points to

4 ways to be a millionaire

2007-05-26T19:46:00.000-07:00

1. Make saving automatic Sign up for automatic investing plans, which will funnel the savings directly from your paycheck into your investment account. That way the money starts compounding immediately. Plus, you'll never miss it.Beginning at age 30, if you save $671 each month at an 8% return, you'll have $1 million by age 60. Begin at age 40, and you need to save $1,698 each month.2. Make

All Money Sense

2007-05-25T00:46:00.000-07:00

All Money Sense Matters:Keep watching your moneyDo not over-spentThink bigDare dream100000000000000000000000000000000I am the oneetc