Viewing 15 posts - 3,451 through 3,465 (of 7,506 total)
another option is to move your table to its own database and then create database snapthots at your desire.
Please refer to SQL Server 2005 Books Online topic "Database Snapshots"...
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 2:59 am
Like Elliott W replied the job will not be automatically resubmitted because of a failover;
However, if the job has an active schedule or is being activated by any other means,...
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 2:52 am
Please reply at the duplicate thread : http://www.sqlservercentral.com/Forums/Topic792349-146-1.aspx
just because at this moment that thread has more replies.
Thanks.
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 2:46 am
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
Viewing 15 posts - 3,451 through 3,465 (of 7,506 total)