Viewing 15 posts - 3,151 through 3,165 (of 7,499 total)
:blink: that also goes for the minor changes in the pricing model(s) ...
if you ever succeed to pull out the needed data from your sqlinstance itself .....
:sick:
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
February 17, 2010 at 2:43 am
-do you experience (dead) locks during your troublesome periodes ?
- have you got deadlock reporting activated in your sqlserver errorlog ?
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
February 16, 2010 at 2:45 pm
not everyone has sqlagent active and it lives separate from sqlserver as a service.
A startup stored procedure that sends a mail or message may be the solution for that case.
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
February 16, 2010 at 12:13 am
did you try using a tally table ?
Check out the articles of Jeff Moden or Lynn Pettis
set nocount on;
declare @myTest table
( person varchar(80)
...
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
February 14, 2010 at 9:38 am
Did you check with Gails wonderful article ?
http://www.sqlservercentral.com/articles/Corruption/65804/
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
February 14, 2010 at 3:47 am
Zutendaal, Belgium.
And yes, I like good beer!
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
February 13, 2010 at 3:02 pm
Do you mean SQLserver startup time or actual hardware startup time ?
SQLServer uptime: http://www.sqlservercentral.com/scripts/Administration/63771/
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
February 13, 2010 at 12:59 pm
Did you notice a Missing index recomendation in your Q1 plan ?
anyway Q2 is the one that causes problems ...
It shouldn't matter .... but did you try this alternative ?
...
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
February 12, 2010 at 8:09 am
Another improvement I came up with is just because it always uses a fixed column combination to check for existence ..... use a checksum of those columns.
ALTER TABLE dbo.T_DBA_ConnectionTracker
ADDFastTrack_CheckSum...
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
February 12, 2010 at 3:27 am
Thank you for the feedback.
- Any particular techniques used in the "Attach-but-dump" database ?
- What's the db-level of that db ?
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
February 11, 2010 at 3:21 am
You need to figure out what is actually involved and causing the deadlock.
How To ?
This will enable deadlock info printing in your sqlserver errorlog file.
dbcc traceon(1204, 1205, 3605, -1)
This...
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
February 11, 2010 at 12:42 am
Yes you can:
- You can set your SSMS query properties to use ANSI implicit_transactions.
( Tools / Options / Query execution / SQLServer / ANSI )
OR
- 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
February 11, 2010 at 12:38 am
Thank you all for your replies.
Give me some time to interpret them and check them on this instance.
A little work around I 've done in the mean while, is to...
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
February 10, 2010 at 11:58 pm
as Grant stated the intersect is meanth to compare two sets of data, based on all columns of these sets.
An inner join result set is only based on the matching...
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
February 10, 2010 at 12:08 pm
I would prefer to wait for the rollbacks to complete, unless they take way , way to long.
GilaMonster (2/10/2010)
Don't be tempted to restart SQL. If you do that, the rollback...
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
February 10, 2010 at 12:03 pm
Viewing 15 posts - 3,151 through 3,165 (of 7,499 total)