Viewing 15 posts - 3,151 through 3,165 (of 7,502 total)
Just keep in mind extending a file is an expensive operation for your system.
Depending on your db usage, 50% free space may be desired state because of processing needs.
How many...
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:02 pm
Also state which columns you want to select.
- Only from table1 or from both tables ?
- How can you differentiate both result sets ?
I have a slight impression...
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 1:55 pm
Keep in mind there is more to service broker than meets the eye !
First read a bit about it, so you know what it is all about and 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 17, 2010 at 2:49 am
: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
Viewing 15 posts - 3,151 through 3,165 (of 7,502 total)