Viewing 15 posts - 1,036 through 1,050 (of 7,499 total)
Brandie Tarvin (7/30/2015)
...EDIT: Seriously, can anyone give me a real reason why WITH (NOLOCK) might be functionally necessary for production code?
To keep the answer brief and firm: No.
The risk encountering...
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 30, 2015 at 6:50 am
As you know with AlwaysOn it's the little things that really matter.
Don't just set it up, but test it to the max before you go live.
And that includes Backup 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
June 18, 2015 at 8:39 am
Perry Whittle (6/18/2015)
...It will never work in this configuration, you won't be able to enable the standalone instance for AlwaysOn when the node is not part of a WSFC.
It will...
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
June 18, 2015 at 6:54 am
GilaMonster (6/17/2015)
Alvin Ramard (6/17/2015)
GilaMonster (6/17/2015)
Please note: 10 year old post.Hopefully the OP isn't still looking for that procedure.
Hopefully the SQL 7 server has long since been relegated to 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
June 18, 2015 at 12:42 am
The big downside of using three part naming is during "same instance different DB-name recovery" !
This mostly happens to correct a mishap.
Hush hush repair may cause more damage due...
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
June 11, 2015 at 7:53 am
Could not find stored procedure 'Validate_User_Token'
Indeed, at least Schema qualify all objects !
Exec [YourSchema].Validate_User_Token
Accounts can have their own default schema set !
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
June 11, 2015 at 7:47 am
Solved the issue !
The trick lies in Set-ClusterOwnerNode and specify a Resource !
$Res = Get-ClusterResource -Cluster cl11 -Name "SQL Server ($InstanceName)" |
where ResourceType -eq...
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
April 30, 2015 at 6:16 am
I have this issue on our SQL2008R2 SP2 instance.
It just didn't register any deadlock data in system_health for the last 11 days ( and counting ).
To fix it I request...
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
March 17, 2015 at 2:53 am
Perry Whittle (2/11/2015)
ALZDBA (2/11/2015)
- You need to know the difference between Clustering and Always-on !My stairway series details this, has been linked and is available on this site
...
and a great...
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
February 11, 2015 at 4:36 am
I haven't read through the whole thead, but just want to share my 2ct
- You need to know the difference between Clustering and Always-on !
- clustering: HA solution...
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
February 11, 2015 at 4:18 am
I don't use maintenance plans because of different issues.
I use Backup devices for all sqlserver backups ( 3 devices per database ( Full / Diff / Log ) )
Diff...
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
February 11, 2015 at 4:06 am
No worries ! There are more ways to skin a cat 😉
Off course an "alter database [x] set offline with rollback immediate" is the most safe way.
Seems strange:
Or the db...
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
February 10, 2015 at 5:58 am
I always put the target database offline ( with rollback immediate ) right before the actual restore statement, to be sure no one blocks my restore.
I have incorporated it all...
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
February 10, 2015 at 5:21 am
did you check out Idera's SQL Permissions Extractor (freeware)?
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
February 10, 2015 at 1:52 am
as Gail stated it is only intended to mimic sql server behaviour of an older level.
It is supposed to be used for a "short" time to be able to move...
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
February 10, 2015 at 1:49 am
Viewing 15 posts - 1,036 through 1,050 (of 7,499 total)