Viewing 15 posts - 3,451 through 3,465 (of 7,503 total)
Lynn Pettis (9/22/2009)
... I was so busy looking at the routine itself and comparing it to that other one, I didn't even consider tuning mine more.
Just hopping in 😉
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
September 23, 2009 at 1:23 am
Edd-927544 (9/22/2009)
I have a SQL 2000 database with no need for anything but the simple recovery mode.
I have an ldf file that is 6 times the size of my database...
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
September 23, 2009 at 12:17 am
also add the db autogrowth event to your trace, that will help you determine your point of interest !
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
September 23, 2009 at 12:12 am
Also take into account how your applications connect and use the sproc !
What's their used Isolation Level ? ( should be "read committed" in 99.9% of the cases)
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
September 22, 2009 at 2:23 am
If you had searched SSC for "import errorlog"
you would have come to a lovely script "Deadlock Notifications in SQL Server 2005"
by Patrick LeBlanc ( 2007/10/10 ) which could get 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
September 22, 2009 at 2:10 am
Which parameters did you specify in your BOOT.INI file ?
BOL topic "Process Address Space" states :
If there is more than 16 GB of physical memory available on a computer, 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
September 22, 2009 at 2:04 am
Jack Corbett (9/21/2009)
Builtin\Administrators has not been removed, but has been "disabled" by having sa rights removed.
I noticed if you add builtin\administrators, it gets individual auth in every database, so 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
September 21, 2009 at 8:12 am
IMO the question tended to "would it hurt to always activate AWE" .... That answer is "Yes".
Don't enable it, if it is not needed.
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
September 21, 2009 at 8:01 am
- You shouldn't have switched them to simple recovery, before you have the answer to your question.
If you hadn't switched it to simple recovery, you might have been able 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
September 21, 2009 at 7:39 am
Yes it is !
But if you need to address more than 8GB RAM on a 32-bit system, it is the only option.
from books online (BOL) SQL2008
SQL Server supports Address Windowing...
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
September 21, 2009 at 7:13 am
You could enable C2 auditing and process the trace file to persist the data you want to.
(have a look at BOL for its content)
Maybe even my little article "SQL...
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
September 21, 2009 at 7:03 am
raym85 (9/20/2009)
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
September 20, 2009 at 4:22 am
or use the ever lasting exists with a correlated subquery.
SELECT Q.*
FROM qtral Q
WHERE exists (SELECT 1
FROM qtral Qx
where Qx.tral_no = Q.tral_no
and Qx.tral_pd = Q.tral_pd
group by Qx.tral_no, Qx.tral_pd
having...
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
September 19, 2009 at 11:17 am
The big problem with functions that perform queries, is that they cause hidden joins, hence should be transformed to (well tunable) regular joins !
Functions aren't always visible at first sight...
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
September 19, 2009 at 11:02 am
have a look at Allens article : http://www.simple-talk.com/sql/backup-and-recovery/alert-based-transaction-log-backups---automate-your-database-maintenance-part-2/
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
September 18, 2009 at 5:50 am
Viewing 15 posts - 3,451 through 3,465 (of 7,503 total)