Viewing 15 posts - 4,621 through 4,635 (of 7,506 total)
- please post the sqlserver version info.
Select Serverproperty( 'ProductVersion' ) as ProductVersion
- did you check the fixlist for the available cumulative hotfixes (9) for this kind of...
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 4, 2008 at 3:33 am
There is a separate KB you need to read which explains the procedure to follow for system databases !!
Check "Restoring the master Database" in BOL
http://technet.microsoft.com/en-us/library/aa176749(sql.80).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
September 4, 2008 at 3:06 am
Rem,
I would leave the affinity default.
Gail,
Thanks for the bol ref.
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 4, 2008 at 12:14 am
Yes you can.
We try to avoid it (just in case...)
Books online has the cluster install procedure.
-Keep in mind to prepare your Windows groups to host the instances service accounts
- Keep...
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 3, 2008 at 1:58 pm
With sql7 and sql2000 you're better off putting your user objects NOT in the primary filegroup, but is your own added filegroup(s).
Reasons ? Think IO parallisme.
- you can place an...
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 3, 2008 at 1:48 pm
James Horsley (9/3/2008)
Jeff Moden (9/2/2008)
Yeaup... but if you loose the disk where the log file is, you're still going to miss data regardless of backups.
I don't really agree - surely...
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 3, 2008 at 6:53 am
Rem,
Can you post sqlserver version info (sp/cu) ?
Gail,
Do you have a kb ref for the min = max memory config 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
September 3, 2008 at 1:50 am
Indeed, this guideline to enhance IO still goes for sql2005 and 2008.
However, if you're going for partitioned objects, you should keep in mind there is a huge advantage in keeping...
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 2, 2008 at 1:33 pm
We just created a "group mailbox" (=classic mailbox) and granted every dba read of the mails. This way every dba can see if a mail has been handled or 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 2, 2008 at 1:26 pm
sanjeev_krs2004 (9/2/2008)
I got it; could you please tell me how to use for loop if I need to pick up one of the different lookup (drop-down) values.
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 2, 2008 at 5:05 am
did you also have a look at this article ?
http://sqljunkies.com/WebLog/ktegels/archive/2006/11/09/25306.aspx
You can off course always make a comment to the article, so Frederik can reply himself.
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 1, 2008 at 1:16 pm
sanjeev_krs2004 (9/1/2008)
I have two tables namely account and invoice.
I want to update one field in account table when there is A NEW RECORD inserted in invoice table. 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
September 1, 2008 at 11:10 am
- look for implicit conversions (show xml execution plan)
- how is your sqlservers memory doing (pressure ?)
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 1, 2008 at 10:50 am
WayneS (8/31/2008)
One of the databases has some views that use :
select top 100 percent <columns to retrieve)
order by columna, etc.
the view...
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 1, 2008 at 5:44 am
one should provide index for FKs by default.
Except when it hurts your databases performance.
Keep in mind the in SQLServer 2005 you can disable an index and only build it 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
August 30, 2008 at 2:34 am
Viewing 15 posts - 4,621 through 4,635 (of 7,506 total)