|
|
|
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 |
Determining Last Day of the Month--Quick UDF Posted by Namwar Rizvi at 6/26/2007 11:47:24 PM Hi All,
Getting the last day of the month, for the given date, by TSQL is bit
tricky. Following user defined function provides you a handy general purpose
function to get the last day of the month.
It gets the last day of the month as follows:
For example we have a given date 17-March-2007...more >>
Is there a perfmon counter(s) that show the results is from cubes? Posted by Vui at 6/25/2007 6:57:00 PM How do I find out if the result is from the cube(s) with perfmon?
...more >>
Fact Table Design for Hours Worked Posted by Mahesh at 6/22/2007 3:26:33 PM Hi,
I am trying to design a cube with Date, Time and Employee dimension
which can answer following questions:
- how many employees were working at 10am on 15 June 2007? I
- how many man hours were pais between 10am -11am on 15 June 2007. If
somebody has punched in at 10:30 then he should ...more >>
Implementing Data Warehouse Posted by Roger Tranchez at 6/22/2007 10:08:01 AM Hello, all of you, DB Gurus!
I would like you to give your opinion about the way I'm implementing Data
Warehouse on my company, and the ways to enhance it.
If this is not the best place to publish it please let me know, as far as
this is an important question for the future of information ...more >>
ProClarity and Windows Vista Posted by Darren at 6/22/2007 5:49:00 AM I have recently moved over to Windows Vista Business Edition and have issues
with the installation of ProClarity 6.1 (also with v6.3).
Having installed ProClarity, I find that it fails to launch. All I get is a
Windows message stating that it has stopped working.
Has anyone else had this ...more >>
referential integrity Posted by news.microsoft.com at 6/20/2007 12:00:00 AM When implementing a schema for data warehousing is it common practice not to
implement referential integrity across the tables in the database?
If true is it purely for ETL purposes or does it improve query performance
if the referential integrity is not applied to the tables.
Ollie
...more >>
Analysis Services service hangs cube build / timeout on process cu Posted by Shari at 6/18/2007 3:31:00 PM We have two apparent issues with Analysis Services (AS) as outlined below:
1. We have a rebuild of the nightly cube build and quite often the first
step would hang (just run without processing). We would have to stop the
job, restart Analysis Services and then start the job again, resulting...more >>
Data Mart rollbacks Posted by Joe at 6/18/2007 9:13:46 AM How have folks been managing rollbacks on failures inside SSIS when =
populating data marts?
For example - we have a seperate package for each dimension table, then =
a master Fact table update. If one of the dimension table updates fails =
- how have you rolled back the previous changes in t...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
BI Studio: Poor Performance When Opening a Solution Posted by SBublitz at 6/12/2007 10:46:00 PM When I am opening a Business Intelligence Solution it takes up to 6 minutes
until the system is ready to work.
The first 4 minutes I see Visual Studio with the grey background. In the
remaining time the packages appear but don't accept any input. Meanwhile
Visual Studio is reporting that it...more >>
ETL and SSIS/SSAS roles in it all. Posted by Laura at 6/8/2007 11:46:01 AM I am a student in a data warehousing class. This is my only experience using
SQL Server 2005 BI ETL tools. I need to extract, transform, and load into a
data warehouse using SQL Server 2005. I've extracted all tables from my 3nf
d.b. into flat files using SSIS. My question is about the con...more >>
How Large Is Too Large? Posted by Joe at 6/7/2007 7:40:22 AM Hi,
Just got done with the requirements gathering and discovered
that my users want to measure about 200 items with the warehouse. So
I envision a Fact table with about 200 columns. This seems quite
large to me - but maybe other developers feel differently.
So my question ...more >>
How are you documenting your ETL processes Posted by GreenHillCourt at 6/1/2007 9:51:42 PM I'm currently using SSIS on a fairly large project. I wanted to know how
other developers are documenting their ETL processes. I've started using
Visio for flow charting some of my ETL processes. But I am finding it
difficult to use.
So, What tools/products are you using and are they working ...more >>
SSIS Merge Join Posted by LjP at 6/1/2007 12:56:03 PM I am trying to move data from sql2000 to sql2005
In the data flow source I have
select str_seq, one_seq, one_cd, two_seq, two_cd from table1
After this I have a Mulicast with two lookups (in sql 2005)
Lookup one is asking for one_key based on one_seq and lookup two is asking
for two_key based...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |