all groups > sql server data warehouse > october 2003 > threads for october 15 - 21, 2003
Filter by week: 1 2 3 4 5
Call a stored procedure from another
Posted by Boni at 10/21/2003 12:17:02 PM
I'm sorry for my english!!!
I have 2 stored procedure.
The first accept a Input Var, this is a Id from a Table. My first stored
procedure check if exist the Id and return the value for another field, else
return a string "not present"
My second stored procedure return a list from another ... more >>
Rebuilding indices of a SQL Server 2000 DB
Posted by Jean-Marc Filiatrault at 10/20/2003 1:16:21 PM
What is the recommended frequency for the rebuilding of
the indices of a SQL 2000 production DB to ensure
responsiveness of the DB?... more >>
How to check SQL database size?
Posted by Mirko at 10/20/2003 6:45:48 AM
How to check SQL 2K SP3 database size? How much space is
SQL database taking from the disk.
Please help.
Thanks in advance. Mirko... more >>
Populating Datawarehouse
Posted by Gil at 10/18/2003 11:46:27 AM
Hi,
What information do you have for populating the data warehouse ( With ETL
tools ) ?
Where can I find books/e-books or any web site about the Subject?
Thanks.
... more >>
SQL 2000 - convert local time to GMT
Posted by apm at 10/17/2003 5:52:43 PM
I'm working with SQL 2000. The database server is located
in the Pacific Time zone. Data will to be collected from
other time zones (CT, MT, ET, etc.). Is there a stored
procedure that can convert the time stamp on the data
retrieved from the time zones into GMT?
Thank you in advance. ... more >>
Eng ver support chinese char ??
Posted by Sunny at 10/17/2003 1:00:07 AM
Hi,
My company are using SQL Server 2000 Eng ver, but I need
to store chinese char data on the server, what things I
need to do or upgrade ??
Thanks a lot !!
Sunny
... more >>
SQL databases on NAS
Posted by Eric Piersol at 10/15/2003 8:38:29 AM
I am trying to find out how to configure a SQL 2000
server to be able to store and access databases on NAS or
a mapped drive that physically exists elsewhere on the
network. The knowldege base is not much help. Can anyone
help me here?... more >>
|