Viewing 12 posts - 7,486 through 7,498 (of 7,498 total)
It is a nice wizard, but keep in mind it DETACHes the original db for a litle while, and hereby generates unavailability of your originating db.
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
July 18, 2002 at 7:20 am
Just think about the fact that your sp will run dynamic sql ! (privileges)
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
July 8, 2002 at 2:16 am
Stop searching, the "problem" is solved. The application developer actualy defined a table-column to short for the data that would be placed into it.
Thanks anyway for all your efforts.
🙁 these...
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
May 23, 2002 at 6:48 am
This is described at "FIX Enterprise Manager Returns Unexpected Error on Table or View" (Q273472)
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
May 14, 2002 at 4:06 am
Check this query to get a view on what soundex is doing :
select 'bijnens', soundex('bijnens')
union all
select 'bainens', soundex('baainens')
union all
select 'beinens',soundex('beinens')
union all
select 'beijnens', soundex('beijnens')
union all
select 'bynens', soundex('bynens')
union all
select 'bijnans', soundex('bijnans')
union all
select...
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 10, 2002 at 7:55 am
Building on this I got it to work in VB6 with the folowing code :
'declaration STDERR-file
Dim FileSysSTDERR As FileSystemObject
...
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 2, 2002 at 6:59 am
There's an example-application on this issue shipped with sql-server.
check "C:\Program Files\Microsoft SQL Server\80\Tools\DevTools\Samples\sqldmo"
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
March 22, 2002 at 12:51 am
didn't you make a carthesian product in your first query (the join-predicate is missing) ?
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
March 22, 2002 at 12:48 am
Could you check the mdac version. My sql7-servers using mdac 2.6 have enormous VM-sizes which are nomore visible after instaling mdac 2.6 sp1.
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
March 21, 2002 at 4:22 am
... change an sa-password without even blinking an eye
... keep a server up and running without even being consulted by the rest of the world
... make a backup-copy of your...
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
March 21, 2002 at 4:15 am
In Tsql the "show [estimated] accesspath"-options are great to check if they match whatever you've supposed it was going to do. This works fine for single query tuning. When using...
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
January 15, 2002 at 12:38 am
I've just noticed that my VMsize seems a bit high. (700mb memusage / 1100mb VMsize)
Still searching why.
Jobi
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
December 27, 2001 at 6:44 am
Viewing 12 posts - 7,486 through 7,498 (of 7,498 total)