Viewing 15 posts - 6,781 through 6,795 (of 7,506 total)
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
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
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
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
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
How about :
SELECT A1.ProductID
FROM tblProductAttributeValues A1
inner join tblProductAttributeValues A2
on A1.ProductID = A2.ProductID
and A2.Active = 1
AND A2.AttributeID = 15
AND A2.AttributeValue =1
inner join tblProductAttributeValues A3
on A1.ProductID = A2.ProductID
and A3.Active...
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
No, but you can use dts to export/import the 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
Basicaly simple recovery works like this :
Your log is still in use for data-transaction-integrity. Once data gets committed, the space used in the log for that transaction is marked for...
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
Check
- http://www.sqlservercentral.com/columnists/chedgate/clusterthatindex.asp
- http://www.sqlservercentral.com/columnists/sjones/sqlserver2000indexing.asp
- http://www.sqlservercentral.com/columnists/dharris/indexesanoverviewandmaintenanceforperformance.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
To perform PIT(point in time)-recovery we perform log-backups before every other type of backup.
If you are not interested in PIT-recovery, you can fall back to other ways :
- make frequent full...
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
You could start with a simple view test.
Start sql Query analyser and build a query the has all the security-features in it wich you desire.
E.g.
Create Myview
as
Select mycol1 from sales...
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
Hi Brian,
You'll off course have to select the server-instance which you want to alter the tcpip properties.
I have a server with 3 virtual instances and all 3 are listed 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
If you can build the query/procedure which contains the mechanism to determine "their clients" only, you can implement that.
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,781 through 6,795 (of 7,506 total)