|
|
|
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 |
Shrinking transaction log file in sql server 2000 Posted by Ganapathiraman at 5/27/2006 10:04:02 PM I need to shrink the Transaction Log file only (weekly or monthly) to
certain size automatically ( as a scheduled process) in the Sql Server 2000.
we are taking database backup daily. Please advice, if there is any option
available.
...more >>
How do I find someone to help with Sql Server 2005 BI Project? Posted by PeterF at 5/26/2006 9:36:02 AM I've been building out a data warehouse of my product's usage with some
segmentation of our customer base. I am doing this using SQL Server 2005
Integration Services, Analysis Services and Reporting Services. My problem
is, I am doing this as a "side project" and I am not making enough prog...more >>
Sql weird behavior Posted by csmba at 5/22/2006 6:04:56 PM Hi all. I got the next very simple and strange problem. When running the
following 2 slqs, one runs very fast, and one very slow. I looked at my
indexes time and time again, and cannot figure out why. The table has about
8 million rows.
Very fast:
Select top 1 keyA from tableA where fiel...more >>
Newbie Questions About Surrogate Keys and SCD Posted by Gummy at 5/19/2006 5:31:42 PM Hello,
I am new to data warehousing and trying to get my head around two issues:
My understanding is that everything should use a surrogate key, not the
"natural" one that comes from the source system. For example, I have a fact
table of customers and it has a Product Key on it. That Product...more >>
ADO.NET Timeout Exception - I have tried everything Posted by sorcerdon NO[at]SPAM gmail.com at 5/18/2006 8:46:49 AM Hello!
I am looking for someone who has solved this multi-million people's
problem. EVERYONE seems to ahve this problem.
Im a creating a data set and populating it with a call to a store proc.
Its a complex stored proc with the end result as an insert to a temp
table. Then I do a select fro...more >>
Time Dimensions in the Retail Industry Posted by Manu Puri at 5/16/2006 11:06:01 AM Question from Retail ISV, your guidance appreciated:
Questions:
1. Is it possible to create a time dimension with these extended levels and
utilize the out-of-the-box functionality provided by SQL Server for time
dimensions?
2. If it cannot be qualified as a time dimension, can we still ...more >>
Enterprise or Standard edition !!! Posted by Mathew at 5/15/2006 6:04:02 AM Hello,
Is there any exact database size limitation for standard edition? My
database is almost 5 GB and it's getting too slow. Do i have to switch to
enterprise?
Is there any way to check the database to see it's certainly tuned and
optimized and the only problem is the edition of SQL Se...more >>
Measure data disappears Posted by shawrie at 5/12/2006 1:56:41 PM help!! can someone please help me. I built a simple cube with three
tables in. When i clicked on the data tab within the cube editor i can
see my cube data. When i clicked on save the measure data disappear and
just my dimensions stayed there and i could drill down okay but no
measure data
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
AS 2005 browse cube problem Posted by gmarketos NO[at]SPAM gmail.com at 5/10/2006 5:09:50 AM I have successfully deployed an Analysis Services Project on Analysis
Server 2005 with SP1. However, when I try to browse the cube using
either BI studio or SQL Server management studio, everything stucks.
Dimensions browsing and cube processing works fine!
Any ideas?
Thanks, Makis
...more >>
Basic Design Question Currency Dimension or New Measure Posted by erdal akbulut at 5/9/2006 3:38:02 PM Hi All,
I am in the middle of a decision and I would like to ask experts for their
ideas.
I have Sales Reporting System on MSSQL 2000 + AS + RS
So far I have used only USD as reporting currency, now I am going to add
EURO and Local Currencies. My Current Model has "Sales", "Performance%" et...more >>
Table rowcount in properties is incorrect Posted by lucycard at 5/8/2006 8:05:01 AM I have DTS jobs that delete and copy a table from one server to another.
I check the rowcount in the receiving server's table properties by right
clicking the table and selecting properties and it has not updated properly
in several weeks.
I ran the EXEC sp_updatestats and the record coun...more >>
Table is not responding Posted by NR at 5/7/2006 6:15:02 AM Hi,
I am using SQL Server 2000. I have created one database named : ICS
This database was working fine just few minutes before one of its table
named "LogInOut" has stoped responding.
Now even if i go for deletion it doesn't respond. Rest of the tables are
responding normally. What could be...more >>
fact or dimension table Posted by -ants- at 5/6/2006 9:42:36 PM Hi
How does one decide if data should go into a fact or dimension table?
I have 1 primary key and lots of textual information (5 fields) which
suggests dimension.
However, the data is extremely unlikely to change, which suggets fact??
Ant
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |