I just started a new job and the data warehouse was constructed a bit
different than what I have seen.
Some of the dimension tables had so many FK's that they had to create a view
on top of 3 dimension tables to simulate it as one.

Is there a way to Reference an alias field name in an SQL Statement?
Example:
Select
1 + 1 AS F1,

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.

Good afternoon to all!
I am starting to work with DW and SQL 2000 together with Analysis
Server and am needing to know if it is possible and as to make to track
a flow of dts to be able to identify, when to give problem, in which

Quick question...
I've found that a database in our system has encountered a torn page error.
DBCC CheckDB hasn't worked any wonders so we're going to restore from a
backup.

I need some help in how to convert a certain value in KB into MB. Please see
the bellow script where i put the question.
Thanks
[]

Is there a way to Reference an alias field name in an SQL Statement?
Example:
Select
1 + 1 AS F1,

can someone help to reduce a time connecting to As2005 with using OLEDB9.0
and PivotTable.
thanks.

I saved some packages as files on a windows 2003 sp1 machine running sql
2000 sp 4
Some of these files were always files some were in the MSDB database
I saved them all as files since I need to run them in a sql 2005

this sounds perhaps like a silly question, but I cant format an attribute
(double type) in a dimension. The place where I guessed to place a format
string is in the attributes properties source - keycolumns - Format setting.
But my format string did not affect the appearance of ...

in sql server 2000+ is there some stored procedure that shows your current
disk space usage?

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

In ADO.NET how to tread a large NTEXT field in small chunks? e.g. my NTEXT
field is many megabytes but i only wat 10k at a time? how to do this in
ADO.net?

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.