Monday, April 15, 2013

[SQL 2012] Comparing column data in 2 tables with the same schema containing 1.5 billion records

[SQL 2012] Comparing column data in 2 tables with the same schema containing 1.5 billion records

Comparing column data in 2 tables with the same schema containing 1.5 billion records

Posted: 14 Apr 2013 10:07 AM PDT

I have had the task of recreating a table in our data warehouse which contains 1.5 billions rows to make use of partioning on the clustered index by date. To keep the tables in sync over the past few weeks I have had to run import jobs on both tables.Before moving across to the new partitioned table (by renaming it to bring it into production) I need to ensure that the EffectiveEndDate column in both tables is identical for every row (which has a PK).So my question is how best is it to compare 2 tables with 1.5 billion records to ensure the data in both is the same?At this stage 3rd party tools are not an option and I am using SQL Server 2012 SP1 Enterprise Edition.Any help greatly appreciated!!

multiple instances of sqlserver different dns alias

Posted: 14 Apr 2013 01:33 AM PDT

Hi , I have installed named instances sqlserver2005 express and sqlserver2012 on the same Windows 2008 server Virtual machine ,configured sqlserver2012 to use NON Default TCP IP port .we need 2 different DNS Aliases for these 2 database Servers i.e I should be able to access by specifying the following properties in my applicationuser=sapassword=myPwdhostname=mysql2005.us.comp.comport=1433instanceName=sqlserv2005user=sapassword=myPwdhostname=mysql2012.us.comp.comport=1533instanceName=sqlserv2012Is this possible?Can you give pointers on how to achieve thisManyThanks,BG

multiple instances of sqlserver different dns alias

Posted: 14 Apr 2013 08:35 PM PDT

Hi ,I have installed named instances sqlserver2005 express and sqlserver2012 on the same Windows 2008 server Virtual machine ,configured sqlserver2012 to use NON Default TCP IP port .we need 2 different DNS Aliases for these 2 database Servers i.e I should be able to access by specifying the following properties in my applicationuser=sapassword=myPwdhostname=mysql2005.us.comp.comport=1433instanceName=sqlserv2005user=sapassword=myPwdhostname=mysql2012.us.comp.comport=1533instanceName=sqlserv2012Is this possible?Can you give pointers on how to achieve thisManyThanks,BG

Configure the SSAS to web using TOMCAT

Posted: 14 Apr 2013 05:13 PM PDT

Hi, Am using the SQL SERVER 2012,am trying to configure the ssas in to web using Tomcat.If anybody know please help me out.Thanks,Basee
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog