Forum Replies Created
Viewing 15 posts - 7,246 through 7,260 (of 7,500 total)
-
RE: Problem with NOT EXISTS
If the relation between the temp-tb and the tb is 1-1 and you're checking existance on the unique key, supporting it with a clustered index might speed up this join-operation.
With...
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
-
RE: Data Model Changes
And that are just the adjustments you need to rename the tables.
(You coud script your db and perform the rename textwize and recreate it...
you could also use tools like CA-ERwin,...
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
-
RE: Identity column increaments randomly
In addition to Ray's addition
:Having more Deadlocks lately ?
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
-
RE: Problem with NOT EXISTS
I guess that should be a right join because the exists-function is done using the tblMMStudentTestScores.
But because I prefer using Left joins (I find it smoothly to read) ...
SELECT ...
FROM #tblMMStudentTestScoresTEMP...
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
-
RE: DTS error -Orcale Client & networking components not found
Can you check Microsoft Knowledge Base Article - 264012 :
PRB: Connectivity Issue with MDAC and Oracle8i
You might have to add some reg-keys, mentioned in the article.
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
-
RE: stored procedure creation error: already an object named xxx in the database
Maybe defeat it with it's own weapons ?
use master
select object_id('sp_schedule_status_reset') as The_Nasty_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
-
RE: SQL MAIL ERROR !! HELP!!
just my 2ct.
- did you configure the mail-profile when logged in as sql-agent-service-account ?
- does your sql-agent-service-account has the needed authorities for that email-profile ?
- Is it working when you...
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
-
RE: DTS error -Orcale Client & networking components not found
When I install new basic software (Oracle client in this case) I alway reboot.
Especialy when installing on a server. This way I can better relate a problem to a last...
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
-
RE: Identity (Autonumber)
Indeed
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
-
RE: DTS error -Orcale Client & networking components not found
I suppose your sqlserver-agent-account is member of windows-server-administrators group ?
If not, you'll need to give it access to the Oracle-folders and reg-keys.
You might also want to login on the server...
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
-
RE: New Forums are Live!
Hi Andy,
1) When a forum-thread is started as a "comment-on-article", the article is mentioned as text-http-reference.
e.g.:
"Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/dpoole/sqlserverstatisticalfunctions.asp
========================"
Can you...
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
-
RE: DTS error -Orcale Client & networking components not found
did you define the ODBC as system-dsn ?
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
-
RE: Identity (Autonumber)
Maybe this litle article gets you back on track :
http://www.sqlservercentral.com/columnists/fkalis/coddsrules.asp
It's a nice refresh Frank -Sharky-
has written to the benifit of all...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
-
RE: Identity (Autonumber)
What bike ?
(changed the avatar for a couple of minutes to SushiNemo)I hope the original poster...
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
-
RE: Identity (Autonumber)
identity is related to a numeric datatype so leading zeroes are meaningless.
You can present them anyway with things like this :
DECLARE @I INT
DECLARE @C CHAR(8)
SET @C = ''
SET @I =...
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
Viewing 15 posts - 7,246 through 7,260 (of 7,500 total)