Viewing 15 posts - 4,921 through 4,935 (of 7,502 total)
did you try the "for each loop" container to get this doen (in stead of a script task)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 28, 2008 at 10:49 am
peace2007 (4/26/2008)
Does it mean there's no tool to show that in diagram?:(
AFAIK you dan define logical relationships in ERwin in the logical model.
But I think that will be about the...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 28, 2008 at 8:03 am
A PK is mainly for DA-purposes, to document the key that will be used to support FK-references to your table. ( http://www.sqlservercentral.com/articles/Advanced/coddsrules/1208/
)
Nowadays many rdbms systems only need a unique...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 28, 2008 at 2:38 am
Indeed.
-If you can, migrate;
Reasons:
- in case of disaster you'll have to build your server exactly as your current server. i.e. start with install sql 7.0, restore your sql7.0 databases,...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 28, 2008 at 12:38 am
If your DA / DBA do a good job documenting the relationships, they would for sure use DRI in the database itself AND document the external relationship in the comment...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 26, 2008 at 8:48 am
- Defragging your table will help ! No doubt about it ! Less IO = better performance.
- less IO = less time needed to hold locks
- create an index that...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 25, 2008 at 1:05 pm
There is a little typo in the concatenations ( remove "as colname")
i've also added leading zeros to hours and minutes.
it should be :
Declare @theMinutes int
Set @theMinutes = 2945
Select convert(varchar(15),...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 25, 2008 at 8:01 am
dw (4/25/2008)
Peso (4/25/2008)
The correlated subquery might return NULL if there is no match.
UPDATEmt
SETmt.FKID = x.FKID
FROMMyTable AS mt
LEFT JOINMyFK2Table AS x ON...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 25, 2008 at 6:12 am
You may need to execute this more than once.
-- Shrink_TrxLog.SQL
--INF: How to Shrink the SQL Server 7.0 Transaction Log
-- SQL7 http://support.microsoft.com/support/kb/articles/q256/6/50.asp?id=256650&SD
-- SQL7 http://www.support.microsoft.com/kb/256650
-- SQL2000 http://support.microsoft.com/kb/272318/en-us
-- SQL2005...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 25, 2008 at 6:09 am
Did you try the set-based approach.
[Code]
-- avoid implicit rewrites by adding a nullable column
alter table Mytable add colmigrated datetime NULL; -- to keep track if data has already been processed
go
declare...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 25, 2008 at 3:31 am
as Viking already stated, a column of datatype timestamp is of very little use outside of the sql db.
Even trying to represent it is useless.
btw a timestamp column is automaticaly...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 25, 2008 at 3:19 am
keep in mind the number of rocket scientists is not that high 😉
Declare @theMinutes int
Set @theMinutes = 2945
Select @theMinutes / 1440 as NoDays -- 1440 minutes per...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 25, 2008 at 1:11 am
- Check your sql7 service pac for the prereqs !
- Start with SQL2005 Upgrade advisor !
- run dbcc checkdb for all databases;
- if you can , don't upgrade, but migrate...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 24, 2008 at 2:59 am
BIDS stands for BI-dev studio.
With sql2000 you need to be granted exec of the debug procs.
http://support.microsoft.com/default.aspx/kb/817178
http://support.microsoft.com/kb/280101/
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 23, 2008 at 2:05 am
prefer coalesce.
Not only because it is ansi, but also because it can do more for you.
isnull(thecol, thereplacement)
coalesce(thecol,thefirstreplacement, usethisifthefirstreplacementisNULL,...)
and I've had some issues with sql2000 when using isnull is certain...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 22, 2008 at 2:34 pm
Viewing 15 posts - 4,921 through 4,935 (of 7,502 total)