Viewing 15 posts - 3,451 through 3,465 (of 7,499 total)
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
afaik size doesn't matter, unless you have a sqlexpress instance.
There has been a limit regarding the number of files when using sp_attachdb.
Best is to use "create database .... for...
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 12:47 am
There are only two reasons why one should stop and restart a sqlserver instance:
- to apply a servicepack/hotfix
- to have tempdb to its original or set starting size ( 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
September 18, 2009 at 12:42 am
- commit and overwrite .. yes , SHRINK ... No !
- things that can cause your log files to grow with simple recovery :
-- long running transactions
-- huge...
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 17, 2009 at 4:32 am
Gail posted a very explanatory article on this subject !
http://www.sqlservercentral.com/articles/64582/
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 17, 2009 at 2:58 am
Viewing 15 posts - 3,451 through 3,465 (of 7,499 total)