Viewing 15 posts - 3,511 through 3,525 (of 7,499 total)
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
to early for homework 😉
it are table aliasses.
a pointing to syscolumns
b pointing to sysobjects
They are only valid for that specific sql statement.
Books online (bol) has more info. http://msdn.microsoft.com/en-us/library/ms187455%28SQL.90%29.aspx
btw I always...
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:08 am
You cannot have multiple logins pointing to dbo !
In most cases, we have 'sa' mapped to dbo.
sp_changedbowner @loginame = 'sa' ,@map = 'true'
User 'sa' is never used by applications and...
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:00 am
- what kind of trace file are you refering to ?
(If sqlserver trace files, which events does your trace capure ?)
- you could implement a DDL-trigger to keep track...
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 25, 2009 at 8:16 am
helpmhost (8/24/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
August 24, 2009 at 2:35 pm
Check the security settings if your package AND of your IIS.
If the package is configured to use SQLAuthentication (SQLusername and password), it should run fine if your IIS has 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
August 24, 2009 at 11:40 am
Keep in mind that if auto update statistics is on (on by default) there will be other incentives (usage driven) that cause this auto update process to update the statistics.
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 24, 2009 at 8:08 am
there are couple of SSC articles and scripts that should get you started :
http://www.sqlservercentral.com/scripts/31857/
http://www.sqlservercentral.com/scripts/Rebuild+Index/65933/
http://www.sqlservercentral.com/scripts/SQL+Server+2005/61278/
Just search SSC on "rebuild index" and the search result will show # of results.
You can use...
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 24, 2009 at 2:24 am
Viewing 15 posts - 3,511 through 3,525 (of 7,499 total)