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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|