Viewing 15 posts - 1,906 through 1,920 (of 7,506 total)
are you shrinking the .log file or one of the .mdf/.ndf files ?
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
July 8, 2011 at 5:03 am
John Mitchell-245523 (7/8/2011)
... You should be table to build ...
professional dyslexic :hehe:
Happens to me all the time :blush:
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
July 8, 2011 at 5:00 am
I would check out the applications connection string.
If it states the "failover partner=serverb" it will just be redirected without a problem.
If it lacks the "failover partner" keywords, something is wrong...
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
July 8, 2011 at 4:07 am
Please elaborate on what you are actually trying to do !
Triggers can perform queries, but keep the transaction scope and locking in mind !
Special objects _in_ triggers are the "inserted"...
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
July 8, 2011 at 12:56 am
- create primary keys for your tables and foreign keys to support your data integrity !
( very nice ref on how SQLServer takes advantage of this: Do...
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
July 8, 2011 at 12:42 am
check "create trigger" in books online.
http://msdn.microsoft.com/en-us/library/ms189799%28v=SQL.90%29.aspx
Golden rule for triggers: keep it short, as it is performed "in transaction", so if the trigger fails, the transaction fails !
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
July 8, 2011 at 12:34 am
David Burrows (7/7/2011)
GSquared (7/7/2011)
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
July 7, 2011 at 6:57 am
Jeff Moden (7/7/2011)
ALZDBA (7/3/2011)
It's great to see many of SSC addicts have been granted MVP once more.Congratulations to you all.
Dang... I missed this one on the first pass. Thank...
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
July 7, 2011 at 6:16 am
GilaMonster (7/6/2011)
Kit G (7/6/2011)
GilaMonster (7/6/2011)
Kit G (7/6/2011)
Fal (7/6/2011)
anyone with a minor dose of manners and a sense of humor is invited.
Please,...
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
July 6, 2011 at 7:21 am
Gianluca Sartori (7/6/2011)
ALZDBA (7/6/2011)
Another justification I used was:...
You must be working for a GREAT company, Johan.
I tried to figure out how that conversation would have been here at my...
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
July 6, 2011 at 7:14 am
SQLkiwi (7/5/2011)
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
July 6, 2011 at 3:20 am
did you change service accounts passwords ?
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
July 6, 2011 at 12:19 am
You may also want to start a sqlprofiler trace on your sqlinstance capturing all login info an all oledb errors to get more detail on what's going wrong.
( keep 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
July 5, 2011 at 8:20 am
1) Is your production server sql2008 ?
2) is your production DB dblevel 100 ?
DMV may not work when running the db in a lower compatibility mode.
btw avoid usage of 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
July 5, 2011 at 5:15 am
SQLkiwi (7/4/2011)
ALZDBA (7/4/2011)
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
July 5, 2011 at 1:10 am
Viewing 15 posts - 1,906 through 1,920 (of 7,506 total)