| Groups | Blog | Home |
|
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 |
Filter by week: 1 2 3 4 5 SQL JOB Posted by MS User at 10/27/2004 12:25:54 PM SQL 2K
I got a SQL job which executes a storedprocedure ,which populates data for a
data warehousing application.
Each day my job execution time increases, but the underlying table from
where it reads and populates doesn't increase too much.
Any specific performance monitoring step to loo...more >>
Clustered Indexes Posted by anonymous NO[at]SPAM discussions.microsoft.com at 10/26/2004 5:57:59 PM I just gone through a datawarehouse CD seminar for SQL2K
but a little confused on something. The author said not
to use clustered indexes with star/snowflake schemas. Is
there a reason for this? The author never explained why
we should not use clustered indexes in a datawarehouse.
Does...more >>
BI Accelerator: problem with current day setting Posted by Eugene Frolov at 10/26/2004 3:45:42 PM Hi, All!
I'm experimenting with MSSABI and look this problem - after running
SetCurentDay.dts package every measure values mutiplied by 6.
Here is my steps:
1. Create Analytical, SM and staging databeses with Analytics builder
utility for SMA template (unmodified).
2. Manualy run Master I...more >>
Can't connect to / see cube Posted by Kaisa at 10/25/2004 6:10:49 AM Need some input please.
I have a development domain, with one server running SQL Server 2000 sp
3 Enterprise edition, Analysis Services Sp 3 Enterprise Edition and
REporting Services.
I used to be able to connect to my databases in Analysis Services, but
today I updated one of them, and now I...more >>
Reloading Cube Data Posted by Yash at 10/25/2004 12:47:02 AM Hi,
Is there anyway to reload data for a specific day by clearing the existing
data.
I need to reload data for a specific day by clearing the existing day data
in the cube. Full process or refresh is time consuming until I increase the
number of partitions. If I perform an incremental update...more >>
Slow Aggregations Designer Posted by Yash at 10/23/2004 4:25:02 AM Hi,
Any hints why the aggregation designer will be slow.
Many Thanks.
--
Regards,
Yash
...more >>
SSL forced encription will not work under a Domain User account Posted by Jason Robertson at 10/22/2004 2:50:19 PM Hi,
I have set up an Active Directory, Certificate Services on Windows 2003
Server. I am running SQL 2000 Server. AD and Certificate Services were
installed correctly.
My goal is to be able to use SSL when connecting to SQL Server via Query
Analyzer. I also want to keep the SQL Server insta...more >>
Identity Column Increment Control Posted by Derek Shi at 10/22/2004 1:08:54 PM Hi,
I have a table with identity column. I set the increment
to 1. But after I have deleted a couple of rows then
inserted a new row, the increment is not based on the
existing row number. For example, I had 100 rows already.
After I deleted two rows from the bottom., the last row I
hav...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Analysis Services Cube Editor Posted by Homer at 10/22/2004 11:19:02 AM How does one create outer joins in the cube editor. The documentation states
that by default only inner joins are created and to use Visual Database Tools
( a Visual Studio module). Any workarounds for this?
thanks in advance...more >>
Disadvantages in using cube partitions Posted by anonymous red at 10/22/2004 6:13:40 AM Hello,
Could anyone tell me if there are any disadvantages in using partitions
in cubes ?
Thanks
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |