Viewing 10 posts - 1 through 11 (of 11 total)
If you're sql server is 2005 you can use openxml() function to the data from your xml and insert it to your table. You could also use xquery to query...
Albert B. Matubis
Database Administrator: Trend Micro PH
MCP. MCAD. MCDBA. MCT
MCTS: SQL Server 2005
MCTS: Business Intelligence
MCITP: Database Administrator
MCITP: Business Intelligence Applications Developer
November 29, 2008 at 9:39 am
Hi as far as SSRS is concern, I think you may take the MCTS: Business Intelligence Track and upgrade to MCITP: Business Intelligence Applications Developer. It includes SSRS, SSIS and...
Albert B. Matubis
Database Administrator: Trend Micro PH
MCP. MCAD. MCDBA. MCT
MCTS: SQL Server 2005
MCTS: Business Intelligence
MCITP: Database Administrator
MCITP: Business Intelligence Applications Developer
November 20, 2008 at 10:55 pm
If the user complaint you that application is running very slow. As
a DBA where do you start your work ???how do you find where exactly
the problem is???
As for me I...
Albert B. Matubis
Database Administrator: Trend Micro PH
MCP. MCAD. MCDBA. MCT
MCTS: SQL Server 2005
MCTS: Business Intelligence
MCITP: Database Administrator
MCITP: Business Intelligence Applications Developer
November 20, 2008 at 6:14 am
Can u send me a snapshot of your database mirror setup and any error msg if any... I'll try what I can do to help... Thanks
here is my email:
Albert B. Matubis
Database Administrator: Trend Micro PH
MCP. MCAD. MCDBA. MCT
MCTS: SQL Server 2005
MCTS: Business Intelligence
MCITP: Database Administrator
MCITP: Business Intelligence Applications Developer
September 10, 2008 at 10:04 am
Try creating an xml index on the fields containing xml data type. You can create Primary XML index and add secondary XML indexes
Albert B. Matubis
Database Administrator: Trend Micro PH
MCP. MCAD. MCDBA. MCT
MCTS: SQL Server 2005
MCTS: Business Intelligence
MCITP: Database Administrator
MCITP: Business Intelligence Applications Developer
September 10, 2008 at 4:38 am
If you have configured your database mirror as High Availability (with witness). It will automatically failover to the mirror
Albert B. Matubis
Database Administrator: Trend Micro PH
MCP. MCAD. MCDBA. MCT
MCTS: SQL Server 2005
MCTS: Business Intelligence
MCITP: Database Administrator
MCITP: Business Intelligence Applications Developer
September 10, 2008 at 4:34 am
I think this has to do with the schema. SQL Server 2005 uses schema instead of ownership.
The fully qualified names is somewhat like this
FOR SQL 2000
...
Albert B. Matubis
Database Administrator: Trend Micro PH
MCP. MCAD. MCDBA. MCT
MCTS: SQL Server 2005
MCTS: Business Intelligence
MCITP: Database Administrator
MCITP: Business Intelligence Applications Developer
September 10, 2008 at 4:22 am
Database Mirroring in SQL Server 2005 works this way.
The Primary, witness and Secondary forms a quorom of three after a successful setup. A fail over will occur if Witness and...
Albert B. Matubis
Database Administrator: Trend Micro PH
MCP. MCAD. MCDBA. MCT
MCTS: SQL Server 2005
MCTS: Business Intelligence
MCITP: Database Administrator
MCITP: Business Intelligence Applications Developer
September 10, 2008 at 4:16 am
I agree with Markus... You need to modify your trigger to include a statement that every time a trigger is executed, you need to insert that name of the trigger,...
Albert B. Matubis
Database Administrator: Trend Micro PH
MCP. MCAD. MCDBA. MCT
MCTS: SQL Server 2005
MCTS: Business Intelligence
MCITP: Database Administrator
MCITP: Business Intelligence Applications Developer
September 10, 2008 at 3:36 am
try querying sys.trigger_event for sql 2005 or sys.server_trigger_events
Albert B. Matubis
Database Administrator: Trend Micro PH
MCP. MCAD. MCDBA. MCT
MCTS: SQL Server 2005
MCTS: Business Intelligence
MCITP: Database Administrator
MCITP: Business Intelligence Applications Developer
September 10, 2008 at 1:01 am
Viewing 10 posts - 1 through 11 (of 11 total)