Viewing 15 posts - 1,321 through 1,335 (of 7,499 total)
that's why - although not mandatory - it is best to keep disk-layout equal at db instances involved in db mirroring.
If you need to add a data file in a...
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 22, 2012 at 5:19 am
Here's an ( oldfashioned ) alternative so you can compare performance depending of the % of your set that needs to be updated.
Run it over a big set of data...
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 22, 2012 at 5:10 am
the described scenario is other people activated an IPS system.
There is only little you can do if they don't inform if such thing would cause issues for your db-server or...
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 18, 2012 at 11:50 pm
Thank you for the feedback.
Knowing where to look is a good start for any assessment .
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 18, 2012 at 8:10 am
have a look at "grouping sets" in books online
or at
Technet and Technet too
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 18, 2012 at 8:06 am
This is what I always use :
if OBJECT_ID('tempdb..#tmp_Restores') is null
begin
SELECT @@servername as ServerName
, r.command as [CMD_Type]
, r.start_time
, r.percent_complete
, dateadd(second, r.estimated_completion_time...
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 18, 2012 at 7:57 am
one of the worst practices is converting a datetime any other data type. Let alone to integer format DDMMYYYY !!!
It just looses all date characteristics and functions one can...
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 17, 2012 at 6:15 am
Great article, David.
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 16, 2012 at 1:00 am
have a look at Roberts blog : http://www.sqlsoldier.com/wp/sqlserver/breakingdowntempdbcontention
that is if you're looking for contention issues.
Anther place to start can be :
http://www.sqlservercentral.com/Forums/FindPost1050355.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
July 13, 2012 at 5:15 am
How about:
select @dt [date as is]
, dateadd(yy, -1,@dt) [date-1Y]
, dateadd(wk, datediff(wk, 0, dateadd(yy, -1,@dt)), 0) ...
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, 2012 at 5:30 am
dwain.c (7/4/2012)
ALZDBA (6/29/2012)
dwain.c (6/28/2012)
Jeff Moden (6/28/2012)
dwain.c (6/27/2012)
I like this problem and wanted to contribute.Let other people in on the fun. 🙂 What does dbo.GenerateCalendar() look like?
Please don't laugh! ...
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 4, 2012 at 11:45 pm
to change the login mode option, your sqlinstance needed to restart - which happened because of your crash - so when exactly the registry value has been set .......
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 4, 2012 at 10:46 am
You can test this using the attached simple script and compare the generated plans and consumptions :w00t:
The last result set will contain the execution plans ... if they reside in...
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 2, 2012 at 5:04 am
dwain.c (6/28/2012)
Jeff Moden (6/28/2012)
dwain.c (6/27/2012)
I like this problem and wanted to contribute.Let other people in on the fun. 🙂 What does dbo.GenerateCalendar() look like?
Please don't laugh! ...
1) Keep...
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
June 29, 2012 at 12:12 am
just extract it and run the msi.
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
June 27, 2012 at 11:54 pm
Viewing 15 posts - 1,321 through 1,335 (of 7,499 total)