Forum Replies Created
Viewing 15 posts - 5,731 through 5,745 (of 7,499 total)
-
RE: Disappearing Service Manager Icon
I've also seen this happening when we installed sql2005 beta x and hooked it onto our production network.
Service manager got back to normal after we shutdown this sql2005 server (or...
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: The OLE DB provider "Ifxoledbc.2" has not been registered.
maybe let the system determine the driverversion itself.
@Provider = 'Ifxoledbc',
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: Logic realted question
you could fire a trigger at insert time that records the invoice-key(s) to a staging table and have that staging table qeuried every x-minutes by a job that sends 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
-
RE: Linked server to RDB (oracle 7x)
maybe eureka
With this linked server definition, the connectiontest succeeds ...
it is a start ...
EXEC
master.dbo
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: Linked server to RDB (oracle 7x)
Thanks for the reply.
I've tried that, but with no good results.
Now I would want to connect using the system dsn.
EXEC
master.dbo.
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: Sort column without ORDER BY
well ... as already mentioned, you have to provide an order by clause if you want data guaranteed in a certain order.
BTW Don't use the order by in a view...
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: BAKUP databast form one sys to another
If the server can reach a shared location there is no problem.
put your backup file(s) at the shared location and restore it from the shared location.
e.g. put an xcopy-cmd at...
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: Alert on Deadlock
- keep in mind the responce to the alert is assync ! You may not find the situation anymore.
- Start traces 1204 and 3605 so you get the deadlock info...
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: EMAIL SQLServerAgent Mail but not SQLMail
- Are the service accounts the same for sqlagent and sqlserver ?
- we use smtp-mail so we don't depend on all the hassle with the outlook client. you can check it...
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: Foreign Key/Primary Key GRRR!
That's a big 10-4
During pre-aggregate phase, the fk-indexes will speed up the queries wherever possible. The relationships themselves indeed can be dropped.
Keep in...
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: Transaction log not clearing out
another nice ref regarding impact of shrink operations :
http://www.karaszi.com/SQLServer/info_dont_shrink.asp
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: Shutting down SQL servers
there are serveral ways to shutdown sqlserver:
- service manager
- TSQL : Shutdown
- net stop sqlserver
- EM rightclick servername / stop
They all shutdown sqlserver.
If there are open transactions going on (They...
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: Foreign Key/Primary Key GRRR!
... Is it necessary to maintain the production relationships in the first place ...
- maybe not the actual FK's , but certainly keep the FK-indexes because They will speed up queries...
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: Server consolidation and instances (or not??)
- there are # articles at SSC and sql-server-performance.com
- Keep in mind you need to determine criteria for databases to be hosted in an instance.
e.g.
- how/when will you be...
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: Foreign Key/Primary Key GRRR!
maybe this script can help you a bit :
I used it to convert primary keys to be clustered.
So just exclude the drop/create primary key part and off you go...
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 - 5,731 through 5,745 (of 7,499 total)