Viewing 15 posts - 4,921 through 4,935 (of 7,506 total)
- do you rebuild the indexes on a regular basis ?
(if you have SQL2005 EE, you can do that online !)
- Check if you really need the 'distinct'...
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 29, 2008 at 12:35 am
- do you have more than one named instance on that server ?
- can you connect using the instances portnumber ?
- I have a similar issue with one server hosting...
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 29, 2008 at 12:33 am
I always use backup devices and withing a cycle (between full backups) have my log-bacups incremental.
Only very rare I've noticed backups failing because of the device.
We regulary test pit-restores and...
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 29, 2008 at 12:00 am
GSquared (4/28/2008)
just so long as only one of them is clustered.
It is not mandatory to have a clustering index, but I'd advise to always have one.
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 11:53 pm
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
Viewing 15 posts - 4,921 through 4,935 (of 7,506 total)