|
|
|
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 |
PK's Posted by Joe at 6/26/2006 11:19:51 AM 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.
For example - there are assesments questions for clients w...more >>
Torn Page Error Posted by Tam OShanter at 6/23/2006 7:37:42 PM Hi All,
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.
The torn page error began occuring several days ago.
Can we restore successfully from a backup taken afte...more >>
Reduce time connection to AS2005 Posted by Kazmane at 6/23/2006 4:57:07 PM can someone help to reduce a time connecting to As2005 with using OLEDB9.0
and PivotTable.
thanks.
...more >>
Track a flow in DTS Posted by Rainier at 6/23/2006 9:41:58 AM 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
stage occurred the problem.
Thanks!
...more >>
how to convert KB into MB Posted by Ricky at 6/21/2006 8:13:04 PM Hi
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
[]
Ricky
select location+space(1)+'-'+space(1)+dept as 'Location',
compname as 'Computer Name',
ext_mem as 'Memory',
computermodel as 'Model',
drive_c as...more >>
in sql server 2000+ is there some stored procedure that shows your current disk space usage? Posted by Daniel at 6/20/2006 4:18:39 PM in sql server 2000+ is there some stored procedure that shows your current
disk space usage?
...more >>
sql 2000 dts designer in SQL 2005 Posted by Will Byron at 6/20/2006 1:14:38 PM 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
environment.
I downloaaded the sql 2000 dts components web file and als...more >>
Reference an alias field name in an SQL Statement Posted by Kent Prokopy at 6/16/2006 11:30:50 AM Is there a way to Reference an alias field name in an SQL Statement?
Example:
Select
1 + 1 AS F1,
F1 + 1 AS F2
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Reference an alias field name in an SQL Statement Posted by Kent Prokopy at 6/16/2006 11:29:00 AM Is there a way to Reference an alias field name in an SQL Statement?
Example:
Select
1 + 1 AS F1,
F1 + 1 AS F2
...more >>
how i can make script Database with Data? Posted by Tark Siala at 6/14/2006 3:57:40 PM hi
i am working on Windows 2000 Advanced Server + SP4 and SQL2000 Enterprise +
SP4.
i have database contains Tables, and i want make script to build Tables on
other Database,
but i need this script include Data in Tables too, i can make that ? and
how?
thanks
--
Tarek M. Siala
...more >>
Formatting an attribute with a datatype double in a dimension Posted by Marc at 6/13/2006 7:32:01 AM Dear all
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 the...more >>
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 Posted by Daniel at 6/8/2006 6:50:21 PM 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?
...more >>
Analysis Services + MDX Book recommendations Posted by barnseenio NO[at]SPAM gmail.com at 6/8/2006 7:20:41 AM
Can anyone recommend any books on analysis services and/or MDX.
We're a pretty tech savvy bunch of developers who need some kick start
books on using 2005 analysis services, warehousing principles, writing
MDX queries, designing cubes etc
Any ideas welcomed
db
-------------------...more >>
how to display 10 rows at a time when 1000's returned form sql query Posted by Daniel at 6/7/2006 10:15:28 PM how to display 10 rows at a time when 1000's returned form sql query
how to select the 20th-30th row in a where clause? e.g. select the 20th to
30th employee who name is 'bob' in tsql. i need this because my select often
returns 1000s of rows and i want to display them in pages of 10 at a tim...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |