Viewing 15 posts - 3,511 through 3,525 (of 7,506 total)
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
just my 2ct:
- your rows indeed aren't that wide, so this number of rows should be manageble.
- does your table have a clustering index (I guess it does, if 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
August 31, 2009 at 4:38 am
when removing a CLIX, the data will get rewritten to an 0 index (=heap).
Check out the structural changes of a heap vs a clustering index, and the effect this has...
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 29, 2009 at 5:49 am
- any chance on using SSIS to migrate your data from SQL to Oracle or the other way around ?
- if not, maybe a SQLCLR proc can help out. Also...
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 26, 2009 at 11:48 pm
DON'T DO IT ! At least not with a trigger !
What if "the other instance" goes in maintenance, your "primary" instance will nolonger work because that trigger will fail !
If...
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 26, 2009 at 9:31 am
- disabling tcp\ip for that instance may get you to it !
- follow "Moving the MSDB database" in this KB-art : http://support.microsoft.com/kb/224071
- this may also help out: http://www.sqlservercentral.com/articles/Administration/2605/
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 26, 2009 at 9:00 am
2 x yes
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 26, 2009 at 6:39 am
Check out "The Art of XSD" by Jacob Sebastian in the Books section of SSC !
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 26, 2009 at 6:21 am
did you check Books online (BOL) topic "Starting and Restarting Services" ?
http://msdn.microsoft.com/en-us/library/ms190917.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
August 26, 2009 at 6:16 am
Viewing 15 posts - 3,511 through 3,525 (of 7,506 total)