Forum Replies Created
Viewing 15 posts - 6,766 through 6,780 (of 7,499 total)
-
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
RE: Poor Trigger Performance - Why?
can you post the full ddl of the table/indexes/triggers ?
Just to check : There is an index defined for PoliID ? 
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
RE: Index Page VS Data Page
An other difference is that nonclustering indexes have the actual RID (page-row-address) when there is no clustered index defined for the object.
If there is a clustered index defined, it contains 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
RE: Poor Trigger Performance - Why?
How about :
Set Nocount On
IF UPDATE(PoliInstalments)
UPDATE tblPoliPolicy
SET PoliSettlementDueDate = Min_PremInstalmentDate
FROM
( SELECT PremPoliID , MIN(PremInstalmentDate) as Min_PremInstalmentDate
FROM tblPremPolicyPremium T1
inner join Inserted I2
on T1.PremPoliID = I2.PoliID
and T1.PremDeleted = 'N'
AND T1.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
Viewing 15 posts - 6,766 through 6,780 (of 7,499 total)