Viewing 15 posts - 3,496 through 3,510 (of 7,499 total)
- What version of sql2005 is this ? (+ sp + cu please)
- has the package been modified lately ?
- did you try sp_revoke_login_from_proxy and grant it again ?
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
September 3, 2009 at 1:50 pm
Good input Bob.
We to often forget this new feature of sp2.
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
September 3, 2009 at 1:48 pm
:blink: :blink: Where's my donckey 😀
I've been reading a bit on the cloud topic ..... already forgot the obvious :blush:
At my plant, we only have CI databases.
I 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
September 2, 2009 at 8:01 am
:blink: :blink: Where's my donckey 😀
I've been reading a bit on the cloud topic ..... already forgot the obvious :blush:
At my plant, we only have CI databases.
I 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
September 2, 2009 at 7:57 am
FWIW: concering the "dangers" of CLR modules ....
- http://www.sqlservercentral.com/Forums/FindPost457289.aspx
- http://www.sqlservercentral.com/Forums/Topic483423-386-1.aspx
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
September 2, 2009 at 7:33 am
Are you refering to SQL in the Cloud ?
I don't know :unsure:
We're not into cloud surfing .... at least not yet 😀
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
September 2, 2009 at 7:30 am
Hopping in way to late for this thread, but as I was confronted with application roles nolonger working in SQL2005 for a restored SQL2000 database....
BOL states:
The encrypt option is not...
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
September 2, 2009 at 3:08 am
I think you should alter one db to primary
Check "Pausing and Resuming Database Mirroring " in BOL !
Check "Database Mirroring How-to Topics " in BOL !
from BOL topic "How 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
September 1, 2009 at 4:17 am
As Gail stated, CLR is not a replacement for TSQL procedures, it is just an addition to help where TSQL isn't performing well or just cannot do it.
Regarding content visibility:
-...
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
September 1, 2009 at 4:12 am
just to add a little bit :
- Keep in mind Connection pooling also keeps connections open ! By default it will retain at least one distinct connection for 60 seconds...
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
September 1, 2009 at 12:14 am
Ron (8/31/2009)
ALZDBA (8/31/2009)
Alter your where clause to
WHERE dbo_SAP_CUST.KUNNR <...
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
August 31, 2009 at 1:47 pm
Never use 'sa' !
Consider it only to be in SQLServer to get started and to perform some very basic SQLServer service tasks !
Create your own set of accounts.
Prefer windows...
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
August 31, 2009 at 10:29 am
That's because you have the condition on the SAP_Cust in the where clause, so are excluding NULLs (which are the non matching)
Alter your where clause to
WHERE dbo_SAP_CUST.KUNNR < '0000900000'
or...
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
August 31, 2009 at 10:21 am
can this be your Select query ... a little bit rewritten to avoid the row level count/sum selects ?
SELECT T.SectionID
, T.SectionOrder
...
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
August 31, 2009 at 7:26 am
another guess:
Wat's the relation for ScheduleUserID to the actual user and the actual test (s)he is conducting ?
Can a person take the same test more than once ?
You update query...
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
August 31, 2009 at 4:57 am
Viewing 15 posts - 3,496 through 3,510 (of 7,499 total)