Forum Replies Created
Viewing 15 posts - 6,766 through 6,780 (of 7,502 total)
-
RE: SQL2000 Stored Procedures run WAY slower than straight TSQL Queries?
- did you take a look at locking ? maybe http://www.sqlservercentral.com/scripts/contributions/826.asp can help out.
- Maybe executing the sql with (nolock) hint will deliver sufficient data.
(be aware of uncommitted 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
-
RE: Using a between statement within a case statement
case when yourcol between x and y then 'xy'
when yourcol between a ane b then 'ab'
else 'not between'
end
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: Update numbers in a field
update yourtable
set yourcol = replace(replace(yourcol,'2','"'),'1','!') --
where yourcondition
Check out "replace" in books online
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: Frank''''s Addition to Family
Contratulations Frank.
Must be at least 64-bit 8-way
Enjoy 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
-
RE: Scheduled job won''''t run
- Is the schedule active ?
- who is job-owner ? (and is cmdshell open for non-sysadms (don't if not explicitly needed ! ) ?
- does the sqlagent service account have...
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: not connecting to database
what's in de error-collection of bds after the bds.open ?
err.message, ...
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: recovery from different server.
Don't use the copy database wizard because it detaches the source-db for a while (and reattatches it).
You may want to consider using restore using UNC.
Restore database MyDb
from DISK = '\\myserver\disk$\msSQL\BACKUP\mybackup.BAK'
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: SQL Backup causes Unexpected Shutdown
No Idea.
check :
- windows event logs
- sqlserver logs
- sqlagent logs
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: Are clustered index columns actually usable in non-clustered indexes?
That's why you 'll want to have your clustering keys as small as possible.
All your NCI's will be affected because they nolonger...
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: ''''Wait Statistics''''
Check out Gert's article :
http://sqldev.net/articles/WaitTypes.htm
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 2000 Restore Operation Failing
- can you post your restore statement ?
- can you post the execution report containing the error(s) ?
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: user not able to run jobs
only sa can run jobs he/she does not own.
you might consider a workaround using alerts which launch the wanted job.
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: Poor Trigger Performance - Why?
Are there other users in the db/tb when you run your test(s).
Because you are performing another tableaction
SELECT MIN(PremInstalmentDate)
FROM tblPremPolicyPremium
WHERE PremPoliID = PoliID
AND PremDeleted = 'N'
AND PremIncludeInTotal = 'Y'
GROUP BY PremPoliID
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 Jobs failing to run a DTS
can you explain what's happening in step 1 of your package.
If it is fileaccess, your user Domain\sqladmin may not have access-authority to that file.
If you want to 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: T-SQL brain teaser, tricky sum for employee data.
maybe this is a good starter 
select Subsel.EMPLID, Subsel.EFFDT, sum( C.AMOUNT ) as TotAmt
from (select J1.EMPLID, J1.EFFDT
, isnull((select dateadd(ms,-3,min(J2.EFFDT) ) from PS_JOB J2 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
Viewing 15 posts - 6,766 through 6,780 (of 7,502 total)