Archived Months
January 2003
March 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007


all groups > sql server data warehouse > october 2004 > threads for october 1 - 7, 2004

Filter by week: 1 2 3 4 5

Recover data from yesterday
Posted by Alain at 10/7/2004 12:02:23 PM
Hi, I'm not a database manager, I have to recover the old database instead of the actual. I backed up the old one from a tape backup. Do i have just to rename the existing one and copy the one that i want in the same folder. People told me that there was no change between these two ...more >>

Excel 2002/2003 Add-in for SQL Server Analysis
Posted by Stephen at 10/6/2004 4:05:23 PM
Is "Excel 2002/2003 Add-in for SQL Server Analysis Services" supported under Win XP SP2 ? When I try to install it I get "The advertised application will not be installed because it is unsafe. Contact your administator to change the installation user interface option of the package to ba...more >>

Retaining formatting in Excel defined in cube
Posted by Tom at 10/6/2004 10:05:03 AM
I have set formatting of a calculated member in a cube to 'percent'. When I view the calculated member in an office 2003 pivot table, it does not apply the formatting defined in the cube. Is there a way I can get measures to display the format defined in the cube in a pivot table? Thanks!...more >>

Sql Quey or view
Posted by Murat YEÞÝLBAÞ (By AbbA) at 10/5/2004 7:48:06 PM
Arkadaþlar Merhaba programlama bölümüne bu iletiyi gönderemedim herhalde bir problem var Bende bu bölüme attým belki bilenler vardýr.. Basit bir stok takip programý yapacam ama biryerde takýldým kaldým konuyla ilgili fikirlerinizi sunarsanýz sevinirm Aþaðýdaki yapýda birden faza...more >>

Can I reserve all the rows in Fact table when add the dimension in cube
Posted by ad at 10/5/2004 5:59:34 AM
My fact table join with a dimension table with a foreign key. But there some foreign key in the fact table which doesn't exist in the dimension table. When I add the dimension in cube, all no match rows will be filtered out Can I reserve all the rows in Fact table when add the dimension in...more >>

Schedule Restart Windows 2003 Server.
Posted by Hadri at 10/4/2004 11:00:37 PM
Hello, I would like to know on how to SCHEDULE restart a server which is running on a Windows 2003 Server platform at anytime we desire. thank you....more >>

Delete in a dimension table is very long...
Posted by Jéjé at 10/4/2004 2:06:45 PM
Hi, I want to delete "Inactive" rows in a dimension in my DW, but its slow due to relationships. First. I want to keep these relationships to insure a excellent data integrity Second. I delete rows linked to these deleted items before I delete my dimension. (So, normally, my "inactive" fl...more >>

SQL BI Wins 5 awards in Intelliegent Enterprise Readers Choice Awards
Posted by karenmiddleol NO[at]SPAM yahoo.com at 10/2/2004 9:45:52 PM
The prestigious Intelligent Enterprise Readers Choice awards for 24 strategic business applications was announced last week. Apparently Microsoft SQL Server BI seems to swept all the BI readers choice awards beating longtime industry BI heavy weights like Cognos & Business Objects. Amazingly, re...more >>



Change buffer size for the text datafile data
Posted by cjeffwang NO[at]SPAM gmail.com at 10/1/2004 3:23:29 PM
When populating a table with a column of TEXT datatype, an error message was shown, indicating that the data is too large for the specified buffer size. How we I change the buffer size from the SQL Server Enterprise Manager? TIA, Jeffrey...more >>

Update a big table with a reference table's info
Posted by ttidy at 10/1/2004 3:13:02 PM
Hi, I need to program a update statement to update 4.3 millions records in a table, which changes were according to a reference table. What is the fastest way to do this update statment. Thanks so much advance! Reference table example: Current_code new_code 1 ...more >>


DevelopmentNow Blog