Viewing 15 posts - 1,396 through 1,410 (of 7,502 total)
C3PO's twin (4/17/2012)
... I was wondering if people do a regular reboot of SQL as a general maintenace task.
No. It is concerned a bad practice because after startup 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
April 18, 2012 at 3:13 am
and if it is being hosted on a virtual machine .... ask your VM/Hyper-V sysadmins to take a snapshot before you start your upgarde ! ( easy revert )
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
April 18, 2012 at 3:06 am
apparently someone applied DataTuningAdvisor indexes, which is BAD if applied blindly. _dta_index_TMPPACKAGEOPTION_Opti
IMO, because your query selects directly on the PK column, which is defined as clustering ix ( sql server...
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
April 18, 2012 at 3:03 am
Did you install SSMSToolspak [/url]? ( which is very good , but has this behavior by default, but you can change 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
April 18, 2012 at 2:45 am
HW is supposed to be ok, how about the batteries ? ( I/O caching on/off will be noticeable )
Did you try a scenario "disable index + load + enable index...
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
April 10, 2012 at 5:30 am
Can you post your sqlserver instance version information ( @@version ) so we are sure we're posting for the correct one ? ( rtm sp1/sp2 R2 R2sp1 )
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
April 10, 2012 at 4:01 am
starunit (4/9/2012)
...
I'm glad you like it.
As George stated sp_help_revlogin can help you doing just that. ref: support.microsoft.com/kb/246133
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
April 10, 2012 at 1:19 am
Thank you for the feedback about the remediation. :w00t:
Did you manage to find the cause for this to happen ?
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
April 3, 2012 at 7:50 am
Can you elaborate what you did to handle the issue and solve 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
April 3, 2012 at 5:05 am
great summary, John !
It's good you mention "DB restores" as well, as it is a "non trivial" usage area in many cases. :exclamationmark:
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
April 2, 2012 at 2:43 am
MyDoggieJessie (3/28/2012)
The efficiency of this using the TVF is incredible. I processed a years worth of data in just under 2 minutes...WOW - THANK-YOU!!!
The ROLLUP is not...
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
March 29, 2012 at 11:25 am
did you compare both sqlplans ?
how old is the cached plan for the parameterized query ?
( you can add the .sqlplan as attachment with your reply )
have you checked 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
March 29, 2012 at 11:13 am
Since you really want to shoot yourself in the foot at certain moments , why not just add another factor of uncertainty by using the sqlserver alerts.
Have a look at...
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
March 29, 2012 at 7:46 am
Another great SQL Spackle, Jeff :w00t:
Koen Verbeeck (3/29/2012)
Dalibor Margotic (3/29/2012)
With this query you can do that using INTERSECT AND EXCEPT
...
Or, this one...
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
March 29, 2012 at 3:39 am
Great extrapolation of the KISS principle, Jeff.
Need it to be sead ... [font="Times New Roman"]I LOVE IT[/font] :w00t:
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
March 26, 2012 at 7:49 am
Viewing 15 posts - 1,396 through 1,410 (of 7,502 total)