SQL Server 2008 SSIS Update Command Performance Issue
Hello, In SQL Server 2008 R2, I have created an SSIS package to pull from an ODS and feed a Data Mart. To build the OLAP cube, I am using identity keys as the primary keys to the tables. TableA has 4,000,000 rows and I am updating each row with a foreign key from TableB [...]

Answer Question   |  August 13, 2010  9:37 PM
SQL Query Analyzer, SQL Server, SQL Server 2008, SQL Server 2008 R2, SSIS

SQL Server 2005 Performance
1. How can I lookup the change rate of a database? 2. How can I check the percentage of calls to the database that are reads? 3. How can I check the percentage of calls to the database that are writes?

Answer Question   |  August 10, 2010  6:40 PM
SQL 2005 Database, SQL Server, SQL Server 2005, SQL Server 2005 performance, SQL Server performance

How to roll back service pack in SQL server 2005
HOW TO ROLL  BACK SERVICE PACK IN SQL SERVER  2005 

Answer Question   |  August 12, 2010  6:24 AM
SQL Server, SQL Server 2005, SQL Server administration, SQL Server Service Packs

steps for accessing sql data through ado.net code over LAN NETWORK
steps for accesing sql data through ado.net code over LAN NETWORK

Answer Question   |  August 10, 2010  5:29 AM
ADO.NET, SQL, SQL Data Set, SQL Server 2005, Visual Studio 2008, Windows 7, Windows 7 in 2010

Automatic backups for production databases without taking SQL server offline
I need to automatically create backups of my 42 production databases every night without taking my SQL Server 2008 offline. Is this possible? A full backup and transaction backup so I can step back to the exact time I need?

Answer Question   |  August 10, 2010  3:49 PM
Backup, SQL Server, SQL Server 2008, Sql Server 2008 Backup

Standby Database Server
I am using oracle 10g and I want to use a standby database for high availability of my database. I did almost everything; but I don’t know how a user can connect to the standby server when the primary has failed. This is my connection string “Data Source=(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = [...]

Answer Question   |  August 9, 2010  2:00 PM
Database servers, Oracle 10g, Oracle Database, Standby Database, Standby Server

AS400 online cobol program that needs to get data dynamically from a vendor systems SQL server database.
I have a AS400 online cobol program that needs to get data dynamically from a vendor systems SQL server database. Is there a API or some method for doing this. Help.

Answer Question   |  August 9, 2010  1:27 AM
API, AS/400, COBOL, iSeries, SQL Server, V5R4

java
Can u tell me how to connectivity in java & oracle / my sql. I know connectivity in java & Ms Access. But i want to connect java & oracle. Pls give each & every steps. Bcause i’ll be connecting 1st time. Pls tell me all settings & which file for connect & …….

Answer Question   |  October 21, 2010  3:50 PM
Java 1.6, Java Database Connectivity, MySQL admin, SQL Server

Upgrade SQL 2005 Cluster to SQL 2008
We have a remote sql 2005 server set we will be replacing with a Windows 2008 Cluster. The db supports a 3rd party app. The app has not completely endorsed for sql 2008. If I build an active/passive cluster with sql 2005 on Windows 2008, is there the ability to upgrade the sql server to [...]

Answer Question   |  August 9, 2010  5:48 PM
Active/Passive SQL Server 2005 Cluster, SQL Server 2005, SQL Server 2008, SQL Server clustering

Database Log File sql server 2005
We have a 500GB database, we use a san server with 16 drives. Eight drives are for storage and the other eight for mirroring. All eight drives is one RAID 10 and within that RAID 10 we partition the drives into 8 drives (please seee below) we are having so much slow performance on the [...]

Answer Question   |  August 10, 2010  4:35 PM
RAID, SQL Server 2005, SQL Server 2005 performance, SQL Server logs, SQL Server performance

Oracle DECODE and SSMA
Does the SSMA or SQL Server Migration Assistant actually have a custom DECODE function that can be used in SQL Server? I’ve installed SSMA and can’t find that function in the sysdb database. I assumed there was such a function based on a blog posting made by Kevin Kline.  If there is a function in SSMA could [...]

Answer Question   |  August 4, 2010  6:49 PM
DECODE, Oracle 9i, Oracle migration, SQL Server 2005, SSMA for Oracle

Creating Alert/Email when Automatic Failover Occurs In Sql-Server 2005 and 2000
HI]] I want to send email alert when aotomatic failover occurs in in Sql-Server 2005/2000.  Specs: Active/Active  NO DR solutions

Answer Question   |  August 3, 2010  8:07 PM
Automatic failover, SQL Server, SQL Server 2000, SQL Server 2005

Transactional Replication: Publisher & Subscriber size mismatch
Hello, We have implemented transactional Replication[Push] on our SQL Server 2005 DB. The Distributor is the Publisher. The publisher is on one server and the subscriber on another. After synchronizing the DB, the tables count and the no of recs per table are identical on both the servers, however the actucal db size on the hard [...]

Answer Question   |  August 5, 2010  12:26 PM
Hard drive space, SQL 2005, SQL Database, SQL Server, SQL Server 2005, SQL Server 2005 Database

Exporting to Excel – Sort doesn’t work due to merged cells
How can I change my SSRS to allow exporting into EXCEL and eliminate the header portion of report which includes merged cells. These prohibit my user from being able to sort a column in the table data.

Answer Question   |  August 6, 2010  9:40 PM
excel, Excel import/export, SSRS, SSRS Migration, SSRS reports

ORA-06502: Character string buffer too small
Hi guys, Here’s my script I have created aggregate string function 'Tab_To_String' using this below script CREATE OR REPLACE TYPE t_varchar2_tab AS TABLE OF VARCHAR2(4000); CREATE OR REPLACE FUNCTION Tab_To_String (p_varchar2_tab IN t_varchar2_tab, p_delimiter IN VARCHAR2 DEFAULT ',') RETURN VARCHAR2 IS l_string VARCHAR2(32767); BEGIN FOR i IN p_varchar2_tab.FIRST .. p_varchar2_tab.LAST LOOP IF i != p_varchar2_tab.FIRST [...]

Answer Question   |  April 19, 2013  8:50 AM
Oracle, SQL Scripting, SQL Server, String manipulation

Tool for ETL/SSIS packages testing
Which is the Best Tools for ETL/SSIS packages testing

Answer Question   |  August 11, 2010  8:43 AM
ETL, SSIS, SSIS Package, SSIS Testing

SQL query How to select nth row from a table if they are not in any order
How to select nth row from a table if they are not in any order

Answer Question   |  July 30, 2010  8:40 AM
SQL, SQL Data Set, SQL Query, SQL tables

How to display values in one table by referring and checking values in another table?
how to display values in one table by refering and checking values in another table

Answer Question   |  July 28, 2010  8:08 AM
SQL Database, SQL Server, SQL Server database, SQL Server tables, SQL tables

Excel as a front end to sql, data integrity
how do I put a value in a sql field that will not be counted in a excel pivot table? I am using excel as a front-end to sql. In particular, I am using pivot tables to slice and dice sql tables. The field I am interested in has either a text value or a [...]

Answer Question   |  July 27, 2010  6:00 PM
Excel Database, SQL 2005, SQL Export to Excel, SQL Server, SQL to Excel Database Conversion

Change the size of a column and then reorganize the rows in SQL tables
I think this one will be tricky. What I have is a table like: CREATE TABLE PHOTO_DETAIL   (     ”PHOTO”        VARCHAR2(25 BYTE) NOT NULL ENABLE,     ”NUM_LINE”   NUMBER(20,0) NOT NULL ENABLE,     ”PHOTO_LINE”  VARCHAR2(180 BYTE)   )   what I am going to have is: CREATE TABLE PHOTO_DETAIL   (     ”PHOTO”   [...]

Answer Question   |  August 2, 2010  12:13 PM
INSERT SELECT statement, INSERT statement, SQL Database, SQL Server, SQL tables