Viewing 15 posts - 4,156 through 4,170 (of 7,499 total)
Feedback:
I've upgraded the dev servers to SP3 and got the approval to re-test it in cooperation with one of our biztalk devs.
After I activated the "old" logon trigger again, the...
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
January 13, 2009 at 6:19 am
Did you read:
-SQL2005 http://msdn.microsoft.com/en-us/library/ms188706(SQL.90).aspx
-SQL2008 http://msdn.microsoft.com/en-us/library/ms188706.aspx
- http://www.sqlservercentral.com/articles/SQL+Server+2005/61765/
- http://www.sqlservercentral.com/articles/Development/3144/
- http://msdn.microsoft.com/en-us/library/ms345146.aspx
- http://www.sqlservercentral.com/Forums/Topic414210-338-1.aspx
- http://www.sqlservercentral.com/Forums/Topic623669-360-1.aspx
also keep in mind, if partitioning an existing table, you may still end up with DOWN TIME for your application(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
January 13, 2009 at 5:30 am
As always, play it safe and start with a full backup scenario of ALL your databases (including systems databases !)
If all backups completed successfully, only then start the sp3 exe.
Read...
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
January 12, 2009 at 12:58 pm
did you log grow over night to 17 Gb ?
or is it due to the fact you do not make log-backups ?
In full recovery mode, you need to make log-backups...
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
January 12, 2009 at 12:31 pm
you should be able to update directly to SP3.
There is a CU1 for sp3, but you'll have to check it the items fixed would match your usage environment.
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
January 12, 2009 at 12:25 pm
Indeed, a word of caution should be said.
Undocumented surely means the behaviour may change with every hotfix/cumulative update/service pack/new version.
They may even be removed without any notification or alternative !
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
January 12, 2009 at 7:23 am
Thank you for the confirmation 🙂
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
January 11, 2009 at 11:53 pm
There are some more special characters you need to double up when using them in T-sql or in a dynamic sql string.
If you use variables from you calling application (vb.net,..)...
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
January 11, 2009 at 11:26 am
Books online has good info.
"create event notivication" and further...
Be sure to use the most recent one (dec.2008)
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
January 11, 2009 at 11:13 am
- figure out how many times the application calls the sproc in a single application run. (or how many times it executes the cmd-object)
it must be a loop of some...
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
January 10, 2009 at 10:59 am
Best is to run your code on a box where you have a sql2005 client installed.
If you need to run the code locally on a box, best is 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
January 10, 2009 at 7:56 am
Nicholas Cain (1/10/2009)
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
January 10, 2009 at 7:51 am
SQL Noob (1/9/2009)
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
January 10, 2009 at 5:03 am
Like Gail said, because it is a big sproc, with multiple functionallities, it may be hard to "just optimize by reading it" and therefor it is better to split 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
January 9, 2009 at 5:18 am
- an update trigger is fired by an update event at object level (table/view) !
(so not only from your sprocs, but also by all other update statements !)
- one...
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
January 9, 2009 at 1:28 am
Viewing 15 posts - 4,156 through 4,170 (of 7,499 total)