Viewing 15 posts - 2,761 through 2,775 (of 7,506 total)
did you check your firewall is open for this port number ?
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
October 16, 2010 at 10:49 pm
By default, sqlserver will fill pages to 100%.
You can change this default behaviour using sp_configure 'fill factor', ...
This is an advanced setting.
ref: http://msdn.microsoft.com/en-us/library/aa196711%28SQL.80%29.aspx
If you have the space available, and 85%...
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
October 16, 2010 at 11:45 am
ss-457805 (10/16/2010)
Correction: you're doing 4 PK clustered index scans (aka table scan) on the LEISTUNGSPREISE table, each time on a different column (KONTO_BUCH, KONTO_STEUER_PROV, KONTO_PROV and KONTO_STEUER_VK). It seems 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
October 16, 2010 at 11:35 am
Predictability can be an issue when using a uniqueidentifier for clustering key.
They (ms) provided the new "new sequential id" to help with that, so when you start inserting a bunch...
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
October 15, 2010 at 3:12 pm
- Did you run the upgrade advisor ?
- do you run dbcc checkdb on a regular basis, so you know your dbs pages are in good shape.
- did you run...
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
October 15, 2010 at 2:56 pm
It is a good thing you posted the sqlplan :w00t:
Did you notice you are hitting 31 objects with this simple delete statement ?
Table [LEISTUNGSPREISE] is accessed using a clustered...
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
October 15, 2010 at 2:40 pm
Still fixing problems, although I did warn the teams for the consequences of their decisions and their neglecting the advises dba have handed to them.
This fixing is to the advantage...
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
October 15, 2010 at 2:30 pm
Kind of like "I heard a brake noise ... now my dog is limping ... Why?"
Please post the ddl of your table and all of the current constraints (including FKs).
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
October 15, 2010 at 2:18 pm
can you provide a bit of input.
- can you find any info in your sqlserver errorlog file(s) ?
- how did you set up your mirroring (ddl please)
- what kind of...
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
October 15, 2010 at 1:55 pm
If I'm correct, any restore database command will disable SSB for the restored db.
It is up to you to double check if the SSB guid for the db is still...
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
October 15, 2010 at 7:37 am
GilaMonster (10/14/2010)
CirquedeSQLeil (10/14/2010)
That's quality entertainment
Yup.
Currently watching them test to see if a cup of soda can kill you through a windscreen if thrown while cars travelling at highway speed. Actually...
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
October 15, 2010 at 2:37 am
- can you repro the situation ? (DDL ?)
- can you post the actual tsql you tried ?
(and their results)
- what's the relation between the service account and 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
October 14, 2010 at 11:47 am
did you try "sp_changedbowner newlogin, true" ?
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
October 14, 2010 at 11:28 am
The maint plan has the "statistics only" option.
Otherwise you might be using something based on:
select 'UPDATE STATISTICS ' + quotename(object_schema_name(object_id)) + '.' + quotename(object_name(object_id)) + ' ' + quotename(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
October 14, 2010 at 11:21 am
Don't they come with solar cells on the back ... euhm top ...:alien: ????
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
October 14, 2010 at 10:50 am
Viewing 15 posts - 2,761 through 2,775 (of 7,506 total)