Viewing 15 posts - 6,646 through 6,660 (of 7,506 total)
Thanks for the reply, but the thread is over 1 year old
The sp-recompiles is what we've worked on, as well as ram-extention.
We've...
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 4, 2005 at 12:28 am
I think you only need this :
SELECT
a.fieldname,
a.Code,
CASE a.fieldname
WHEN 'Thing1' then b.Thing1
WHEN 'Thing2' then b.Thing2
WHEN 'Thing3' then b.Thing3
ELSE 0
END As Description
FROM ATable a
left join Thing1...
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, 2005 at 7:50 am
if you can handle the bit typework you might consider using the replace sql-function.
check BOL.
-- use select for POC-test
-- later alter to update-statement
select myalfanumber, replace(replace(upper(myalfanumber),'A','') ,'B',''),.... as mynumber
from mytable
where...
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, 2005 at 12:56 am
As you might have found out, there is litle info regarding sysprocesses available on the web. (many using it, but none describing it)
So I fallback to sybase :
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, 2005 at 12:21 am
You could also use sysprocesses for a quick ref.
This is a system-table, NOT to be modified/updated by anyone but the system !! ![]()
But 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
April 28, 2005 at 12:14 am
I guess your reboot-policy comes from an NT-4 era ![]()
We only reboot if fixes are planned and installed or if our production-plant has a...
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 27, 2005 at 1:10 am
I've used PSTAT.exe from the Wk2 resource kit to capture the data,
then transfered the intercepted output to a central place
, imported them into SQL and ran a filterquery to...
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, 2005 at 7:27 am
![]()
print screen on a stone plate ?? ![]()
I've got 50+ servers to monitor.
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, 2005 at 5:15 am
ThΓ© big thing with any RDBMS (sqlserver/oracle/db2/...) is to work set-oriented. Once you get that in the fingers, things will work smoothly. ![]()
Maybe...
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, 2005 at 12:12 am
Let's hope your worktables are no #- or ##tables
These are only available within their own connection. ![]()
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 21, 2005 at 12:42 am
- Avoid using a cursor !! ![]()
Is this what you aim for ?
Declare @MyError int, @MyRowcount int
Update S
SET NAME = REPLICATE( CHAR(65 +...
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 21, 2005 at 12:32 am
- How many times is your trigger fired ?
(I've seen systems that perform an insert and then do a couple of updates to the same row to complete data....
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 19, 2005 at 1:50 am
win2k3 ? MSDTC enabled for remote usage ? ![]()
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 14, 2005 at 1:19 am
you'll have to look for negative length parameter used in a substring function.
I've encountered this some times when using "dynamic" substrings based on CHARINDEX.
e.g. select substring(mycol, Johan Dont drive faster than your guardian angel can fly ... - How to post Performance Problems - 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
Learn to play, play to learn !
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post data and code to get the best help
April 14, 2005 at 12:41 am
there can be tons of reasons why it gets stuck ![]()
- how is your linked server defined
- problems with the network ?
- is 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 14, 2005 at 12:32 am
Viewing 15 posts - 6,646 through 6,660 (of 7,506 total)