Wednesday, March 13, 2013

[SQL 2012] table partitioning

[SQL 2012] table partitioning

table partitioning

Posted: 13 Mar 2013 12:37 AM PDT

I planning to do table partitioning using the region wise. in my region table there are 18 region are there.... is it required for 18 partition ?Could any one suggest me to do best in scenario.

Linked Server SQL 2000 - SQL 2012 Issues

Posted: 10 Jul 2012 11:44 AM PDT

We installed SQL 2012 recently... linked server between SQL 2012 and SQL 2008 using SQLNCLI11 is working fine; however, we have issues creating linked server between SQL 2000 and SQL 2012. [b]Msg 8522, Level 16, State 3, Line 1Microsoft Distributed Transaction Coordinator (MS DTC) has stopped this transaction.[/b]I am not sure why I am getting this error when the linked server with SQL 2008 is doing fine and there is not MS DTC error also linked server using the same SQL 2000 server with SQL 2008 server is working fine as well so I don't think there is issue with configuring MSDTC. Thanks a lot for your help.

SQL Query

Posted: 13 Mar 2013 02:58 AM PDT

Hopefully, I am posting this in a right area if not I am sorry. Dont mind the $$$$,#### and **** I am trying to get the last 60 days of records from today, and I am having issued writing the query that returns that value....RDMS its tie to SQL/Oracle database and here is my query that is currently working but I just like to see the last 60 days if anyone can possible help!!!SELECT INFORMENT.PRODUCT_OFFER_PURCHASE.*******_#######, INFORMENT.INVOLVED_PARTY.INVOLVED_PARTY_ID, To_Char(INFORMENT.PRODUCT_OFFER_PURCHASE.DATE_ADDED, 'YYYYMMDD'), INFORMENT.DEPOSIT_$$$$$$$.BAL_LEDGER_CURRENT, INFORMENT.PRODUCT_OFFER_PURCHASE.INTEREST_RATE, To_Char(INFORMENT.PRODUCT_OFFER_PURCHASE.DATE_OPEN, 'YYYYMMDD'), To_Char(INFORMENT.PRODUCT_OFFER_PURCHASE.DATE_CLOSE, 'YYYYMMDD'), INFORMENT.PRODUCT_OFFER_PURCHASE.*******_STATUS_CODE, INFORMENT.PRODUCT_OFFER_PURCHASE.CLIENT_DEFINED FROM INFORMENT.PRODUCT_OFFER_PURCHASE, INFORMENT.INVOLVED_PARTY, INFORMENT.DEPOSIT_$$$$$$$$$ WHERE INFORMENT.PRODUCT_OFFER_PURCHASE.INVOLVED_PARTY_ID_PRIMARY = INFORMENT.INVOLVED_PARTY.INVOLVED_PARTY_ID AND INFORMENT.PRODUCT_OFFER_PURCHASE.******** = INFORMENT.INVOLVED_PARTY.*********AND INFORMENT.PRODUCT_OFFER_PURCHASE.******** = INFORMENT.DEPOSIT_$$$$$$$.******** AND INFORMENT.PRODUCT_OFFER_PURCHASE.APPL_ID = INFORMENT.DEPOSIT_$$$$$$$.APPL_ID AND INFORMENT.PRODUCT_OFFER_PURCHASE.*******_######## = INFORMENT.DEPOSIT_$$$$$$$$.******_####### AND INFORMENT.PRODUCT_OFFER_PURCHASE.********* = '020'and(INFORMENT.PRODUCT_OFFER_PURCHASE.APPL_ID = 'SAV' or INFORMENT.PRODUCT_OFFER_PURCHASE.APPL_ID = 'DDA')

SSAS/MDX Unit Testing

Posted: 12 Mar 2013 08:31 PM PDT

Hi All,I've been doing a bit of searching round for ways to unit test cubes and the results seem to be limited. What we're trying to do is make sure that any releases we make to live don't alter the existing numbers, unless we are aware that this should be the case, obviously we'd then make a change to the tests.I've been toying with the idea of creating framework using ADOMD.NET, but this appears to be limited to single result set numbers, e.g.[code="sql"]Select [Measures].[Total Sales Value] On 0From [My Cube]Where [Date].[Year - Month - Day].[Date].&[20130313][/code]Does anyone have any ideas? In the meantime I'll continue searching round for ADOMD.NET stuff and post back any results I find.Cheers,Jim.

We have some issues on configuring IIS 7 with SQLSERVER 2012

Posted: 12 Mar 2013 01:32 PM PDT

Can anyone help us on configuring IIS 7 with SQLSERVER 2012?Regards,Ram
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog