Viewing 15 posts - 3,391 through 3,405 (of 7,499 total)
BOL has all info I have 😉
http://msdn.microsoft.com/en-us/library/ms188755.aspx
Keep in mind a stop/restart of your sqlserver instance will reset these data !!
If you want this info long term, you'll have 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
October 20, 2009 at 7:48 am
Have fun !
I hope I'll get a new occasion next year.
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
October 20, 2009 at 7:42 am
-- list most used tables
-- SQLServermagazine instantDoc 53878
--
SELECT
t.name AS 'Table',
SUM(i.user_seeks + i.user_scans + i.user_lookups) AS 'Total_accesses',
SUM(i.user_seeks) AS 'Seeks',
SUM(i.user_scans) AS 'Scans',
SUM(i.user_lookups) AS 'Lookups'
, min(s.login_time) as StartUp_DateTime
, min(s.Years) as ServerUp_Years
,...
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
October 19, 2009 at 12:30 pm
-did you execute the sproc via SSMS or via another app ?
What were the connection isolation level settings?
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
October 19, 2009 at 12:26 pm
Strange indeed if that user is the actual db owner!
Did you doublecheck the default schema ?
I would try the primitive way and script the full database (with all users 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
October 19, 2009 at 12:02 pm
maybe this ref will shed a good light on the issue.......
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
October 18, 2009 at 12:46 pm
Oh yes... Distributed transactions ...
If the app is killed (client side), msdtc can get stuck and sqlserver will need a non-standard way to get rid of the pending lock(s).
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
October 18, 2009 at 6:56 am
bitbucket showed you the way to extract parts from a date/datetime datatyped column.
In all other cases I advise to your convert to put date/datetime datatyped columns is a certain way.
Convert...
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
October 18, 2009 at 2:05 am
Apparently there is a little bug in this create statement !!
It works if you first specify the start date and then the expire date !
CREATE CERTIFICATE DavesCertificate
WITH SUBJECT =...
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
October 14, 2009 at 8:06 am
Thank you for the feedback.
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
October 14, 2009 at 12:19 am
BOL sql2005 topic "sys.server_principals" states:
modify_date datetime Time at which the principal definition was last modified.
With all my sql2005(sp3) instances, it contains the actual modification date of 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
October 12, 2009 at 2:24 am
In that case, check your databases ! One of them (if not all) may contain a wam_bam schema name !
And the user may have that schema name as default schema,...
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
October 12, 2009 at 1:04 am
Thank you for the feedback.
That kind of mishaps happen to all of us every once in a while 😉
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
October 12, 2009 at 1:02 am
Once again, thank you Dale.
Your advise and refs contained the solution to fix the issue that occured on some of our x64 systems.
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
October 12, 2009 at 12:58 am
Some nasty little virus kept me in bed the last days of last week. :sick:
If you read my script, you'll see a section of the where clause where I added...
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
October 12, 2009 at 12:26 am
Viewing 15 posts - 3,391 through 3,405 (of 7,499 total)