Viewing 15 posts - 4,681 through 4,695 (of 7,506 total)
I'm quit with you Andy. :smooooth:
With one exception ... The DWH bulk loaders ;). They are being granted "bulkadmin".
We also implement our own reader/app (writer/exec-on-schema) / ReleaseManager db-groups and only...
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
August 12, 2008 at 1:39 am
sql (8/7/2008)
A: Principal (Site A)
B: Mirror (Site B)
C: Witness (Site A)
Witness Server was placed in Site A, because at night time the link between...
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
August 12, 2008 at 1:11 am
First thing MS will ask you is :
- What SP level are you on ? (sp4 is the current)
- did you apply any hotfixes ?
If you are not on...
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
August 12, 2008 at 1:04 am
paul (8/11/2008)
...The question is: How can I determine what's telling SQL Server to truncate the log on this database?
- run a trace to see what's going on.
(you can schedule a...
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
August 12, 2008 at 12:52 am
- 10% of 2.6Gb +-260Mb so that explains the file growth
- of that 260Mb (available after auto growth) you have already consumed (260-139) 121Mb.
No problem.
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
August 12, 2008 at 12:39 am
here's a nice overview ...
http://www.sqlservercentral.com/articles/63472/
http://www.codeproject.com/KB/database/SQP_performance.aspx
http://www.mssqltips.com/tip.asp?tip=1556
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
August 12, 2008 at 12:30 am
Carolyn Richardson (8/11/2008)
See article on this site:-http://www.sqlservercentral.com/articles/Administration/3177/
Written by yours truly :w00t:
I guess I lost track of this forum thread I'd launched myself.
Thanks for adding the link.
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
August 11, 2008 at 6:07 am
hth
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
July 29, 2008 at 8:04 am
Yuckon (7/25/2008)
...Sorry but I thought you guys on here like a challenge!
This is not a challenge.
The point always is to find a thingy that works, alligned with what's reasonable, and...
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
July 25, 2008 at 9:17 am
Yuckon (7/25/2008)
DB Mirroring is not an option as I dont want the overhead on Server A - the load must be totally offline.
The reason I want 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
July 25, 2008 at 8:55 am
- Wouldn't you be better off setting up db-mirroring ?
(maybe even using db-snapshots to use the data you want)
It will keep up with the updates if...
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
July 25, 2008 at 8:44 am
I'm in Toronto this week spending some quality time with the family :w00t:
I'll see if I can get the info you requested.
Johan
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
July 24, 2008 at 7:17 am
BTW the new drivers are:
HP DL380G5
ComponentFirmwareDriver
Bios P56-01/24/2008-
ILO1.431.13.0.0
Networkcards2.1.2.04.4.21.0
Raidcontroller1.786.12.4.32
Videocard-6.14.10.6744
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
July 23, 2008 at 2:38 pm
GilaMonster (7/21/2008)
ALZDBA (7/18/2008)
And sweet is the odor of victory 😎But sometimes no one acknowleges it ... "after all you just did your job".
The best part was that a few months...
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
July 21, 2008 at 1:15 pm
just a ping back http://www.sqlservercentral.com/Forums/Topic510666-1291-1.aspx
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
July 19, 2008 at 4:50 am
Viewing 15 posts - 4,681 through 4,695 (of 7,506 total)