Viewing 15 posts - 4,156 through 4,170 (of 7,506 total)
Could you also post your version number of SQL2005 ?
Select @@version
-- or
Select Serverproperty( 'ProductVersion' ) as ProductVersion
, Serverproperty( 'ProductLevel' ) as ProductLevel
, Serverproperty( 'ResourceLastUpdateDateTime' )...
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 14, 2009 at 3:39 am
here's a starter :
- simplyfied http://www.extremeexperts.com/sql/articles/BestPractices.aspx
- http://vyaskn.tripod.com/sql_server_administration_best_practices.htm
- http://msdn.microsoft.com/en-us/sqlserver/bb671432.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
January 14, 2009 at 12:22 am
Jeff Moden (1/13/2009)
Holy moly... you are a very patient human... 470 hours... 19.58 days. And to think I...
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 14, 2009 at 12:18 am
If you cannot fine any reasonable / related message in sqlservers errorlog,
I would suggest to at least run DBCC CheckDB (for the db if you know it, 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
January 14, 2009 at 12:07 am
IMO your variable is declared to small !! char(10) seems rather small.
Be sure to match you declared size to the size of the column in de table ddl.
DECLARE @Driver_Name...
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 11:59 pm
a log file can only shrink up to the last virtual log file it has in use.
This script will write dummy data to the log file, until it's first VLF...
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 11:41 pm
Can you check it restrictions apply to the number of user connections ?
/* "user connections" is an advanced config setting
enable show advanced options */
exec sp_configure 'show advanced...
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 7:41 am
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
Viewing 15 posts - 4,156 through 4,170 (of 7,506 total)