|
SQL BI Wins 5 awards in Intelliegent Enterprise Readers Choice Awards
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, ...
2 Oct 2004 21:45:52 -0700
|
Change buffer size for the text datafile data
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 ...
1 Oct 2004 15:23:29 -0700
|
Update a big table with a reference table's info
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 3
...
Fri, 1 Oct 2004 15:13:02 -0700
|
Fixed values at a particular level
I have a value of a begining balance that I want only displayed at the month
value. Right now when I add time and I save the value as a measure I get the
sum of the value.
I know I have seen ways to solve this in books but I have been unable to
find the answer.
Please help
Thanks
Tom ...
Thu, 30 Sep 2004 13:17:05 -0700
|
The Problem of Unary
Hi,
I have a dimension table named "DimAll" in SQL Server as the source of all
of the parent child dimensions.
I defined two members 'X999' and 'Y999' use to be the filters, and use the
column "dim_oper" as customer operator.
So, in Dimension Edit of AS that I enable the Unary Operators.
When I set these tw ...
Thu, 30 Sep 2004 10:13:29 +0800
|
sql 2000 analysis manager
I am practicing building cubes with the analysis manager tutorial. I follow
their instructions exactly. Starting from the first tutorial. But I still
get the error "unable to browse dimension "New Dimension". Provider cannot
be found. It may not be properly installed." When I get to the finish page
of ...
Wed, 29 Sep 2004 14:09:04 -0700
|
Concept confused... Please help
Sorry for this dump question!!!
I am confused with the concept...
I install a SQL Server and Analysis Services at home and I would like to
play around the Analysis Serverices function.
I need to build the datawarehouse on SQL Server and use Analysis Services to
Gerenrate the Queries I want in Analysis Serv ...
Wed, 29 Sep 2004 12:15:04 -0700
|
Reporting Database
We want to create a reporting database from our OLTP database. We are
thinking to take an initial snapshot and then use transactional replication.
However, we also want to keep the OLTP database with only one year of data.
If after one year, we remove records from OLTP, the transactional
replication will be re ...
Wed, 29 Sep 2004 11:48:07 -0400
|
Exportar OWC to Excel
some times when exporting a cube of a pagina Web with OWC to Excel, after 5
minutes does not finish and if it finishes not they see the data. That I can
do? thank you very much to help me ...
Wed, 29 Sep 2004 06:51:08 -0700
|
Indexes on Star Schema
Hi
I've got a typical star schema for a retail store, i.e. sales facts
and dimensions for: Day, Product, Store & Brand.
I have put a clustered index on the Day surrogate key, and indexes on
each of the other surrogate keys.
A lot of different, ad-hoc queries get run against the database, as
well as many ...
27 Sep 2004 08:27:16 -0700
|
How do I rename an a/s database?
Hi
Does anyone know if this can be done, and if so how?
Thanks
Jono ...
Sun, 26 Sep 2004 19:03:27 -0700
|
Bunjee Love
Pictures of me and my girlfriend having sex at the end of a Bunjee Rope 100 meters off a bridge in Scotland
http://bunjeelove.fsckme.net/BunjeeLove.zip
...
Sat, 25 Sep 2004 16:06:45 GMT
|
Bunjee Love
Pictures of me and my girlfriend having sex at the end of a Bunjee Rope 100 meters off a bridge in Scotland
http://bunjeelove.fsckme.net/BunjeeLove.zip
...
Sat, 25 Sep 2004 16:02:30 GMT
|
Good Book on Datawarehousing with SqlServer?
Can anyone recommend a good book on designing and implementing a data
warehouse using sql server specifically? Not just one in your library, but
one that stands-out?
Thanks,
Michael ...
Thu, 23 Sep 2004 15:13:06 -0700
|
using col_name
how can i use COL_NAME in where?
SELECT *
FROM table
WHERE COL_NAME(OBJECT_ID('tableTTT'),6)=value_to_compare
the column is int && value_to_compare is same int
in fact COL_NAME(OBJECT_ID('tableTTT'),6) returns just a string with the
col.name && not the value
thx ...
Thu, 23 Sep 2004 06:41:05 -0700
|