Viewing 15 posts - 1,576 through 1,590 (of 7,506 total)
Roy Ernest (12/6/2011)
Good Job Johan... 🙂 Nice examples.
Thank you, Roy. I hope it gets people started.
skron (12/6/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
December 6, 2011 at 12:39 pm
There is no need for two tables having a FK relationship to be able to use it in a join condition.
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
December 6, 2011 at 12:29 pm
I would check:
- the sqlserver errorlog
- the default trace (it records object creation and delete)
and off course as already suggested a sqltrace will throw light on this issue.
Co-ordinate it with...
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
December 6, 2011 at 10:13 am
Welsh Corgi (12/5/2011)
ALZDBA (12/5/2011)
Does Powershell come in to picture ?http://ask.sqlservercentral.com/questions/36601/powershell-export-multiple-tables-to-csv
A lot less effort.:-)
Do I read "a new addict" ? 😀
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
December 6, 2011 at 4:58 am
GilaMonster (12/5/2011)
ALZDBA (12/5/2011)
- did you update all statistics
- did you perform dbcc updateusage
- did you perform full db maintenance
- did 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
December 6, 2011 at 4:56 am
Does Powershell come in to picture ?
http://ask.sqlservercentral.com/questions/36601/powershell-export-multiple-tables-to-csv
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
December 5, 2011 at 2:05 pm
When you switch to the engine level compatibility (100):
- did you update all statistics
- did you perform dbcc updateusage
- did you perform full db maintenance
- did you run DBCC...
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
December 5, 2011 at 2:01 pm
Is your query "select Users.UserName from Users" producing results ?
Are there usernames that return NULL in stead of a valid value ?
Did you notice
Msg 512, Level 16, State 1,...
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
December 5, 2011 at 12:03 am
aim for uniformity of management and apply the same backup strategy on all your instances.
If you cannot do that, use sqlagent to schedule your backup jobs for the wanted databases.
Double...
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
December 4, 2011 at 11:58 pm
just a little but crucial warning;
- double check your jobs aren't launched using sqlalert(s) ! If a jobs can be launched by a trigger and you disable the job, when...
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
December 1, 2011 at 1:56 pm
- can both instances communicate using those port numbers ? (firewall, ..)
- did you install the certificates correct ?
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
December 1, 2011 at 5:27 am
Do you have deadlock reporting in SQLServer errorlog enabled ?
This can be accomplished using startup trace flags
-T1204
-T3605
and so you don't need to restart you instance you can enable it for...
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
November 30, 2011 at 12:11 pm
Trace Flag 8017 upgrade version conflict http://social.msdn.microsoft.com/Forums/eu/sqlexpress/thread/dd6fdc16-9d8d-4186-9549-85ba4c322d10
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
November 28, 2011 at 1:40 pm
Great job, Roy.
It's been my pleasure to help out.:smooooth:
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
November 28, 2011 at 10:18 am
Dev (11/28/2011)
Lynn Pettis (11/24/2011)
Dev (11/24/2011)
They may not remember and that is why it should be declared as NOT NULL.
Well, I guess we will have to agree...
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
November 28, 2011 at 8:03 am
Viewing 15 posts - 1,576 through 1,590 (of 7,506 total)