Viewing 15 posts - 1,081 through 1,095 (of 7,504 total)
since this is occasionally, I would suspect the restore process not being the 'single user'.
Can you double check there isn't anything between the 'set single user' and the 'restore database'.
That's...
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
January 8, 2015 at 1:42 am
the deadlock resource is dbid = "10" objectname = "F1SB.dbo.LiveMatches" indexname = "PK_LiveMatches"
that is the object involved in the merge operation as receiving object !
I've seen trancount =3 mentioned ...
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
December 29, 2014 at 3:53 am
you'll have to investigate the object referred by waitresource.
e.g. "KEY: 27:72057594095534080 (989126c604a2)"
and interpret how that resource is being used by the conflicting threads
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
December 29, 2014 at 2:37 am
Ray Herring (12/9/2014)
is there 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
December 10, 2014 at 12:56 am
Brandon Forest (12/8/2014)
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
December 9, 2014 at 12:32 am
MG-148046 (12/8/2014)
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
December 8, 2014 at 7:20 am
My shrink already told me I wouldn't be the only one puzzled with such documentation.
Thank you for the confirmation 😀
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
December 8, 2014 at 2:35 am
Apparently the link to the script disappeared.
So here is the link to my script at OneDrive
Scripting SQL Server databases with SMO
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
December 8, 2014 at 12:56 am
I know Milos has written a number of interesting articles about the new CE and some pitfalls he encountered.
http://milossql.wordpress.com/category/sql-server/
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
November 21, 2014 at 3:22 am
have a look at my little article:
Scope: The drastic caveat with Logon Triggers. [/url]
It will get you on the right track.
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
November 21, 2014 at 1:51 am
Last SQLPass ( summit 2014 ) a twitter conversation popped up mentioning Paul White lost (part of) his voice
Jes Borland @grrl_geek-2
@SQL_Kiwi You got your voice back, then?
......
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
November 12, 2014 at 1:19 am
what connection library are you using?
What's the content of your content file ?
( does it contain the full connection string or just parts of it)
Can you mail the connection string...
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
November 10, 2014 at 12:45 am
Perry Whittle (11/7/2014)
ALZDBA (11/7/2014)
With SQL2008 (R2 ?) you'll need to modify your connection strings and add the failoverpartner parameter.[assuming your chosen connection library supports the database mirroring parameters
Indeed.
If your connection...
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
November 7, 2014 at 7:23 am
the 20 characters limit rings a bell, but only for Reporting Server service accounts !
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
November 7, 2014 at 5:57 am
With SQL2008 (R2 ?) you'll need to modify your connection strings and add the failoverpartner parameter.
http://www.connectionstrings.com/sqlconnection/database-mirroring/
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
November 7, 2014 at 5:52 am
Viewing 15 posts - 1,081 through 1,095 (of 7,504 total)