Viewing 15 posts - 3,931 through 3,945 (of 7,503 total)
thieuquanghuy (3/9/2009)
...
Thanks marina.kudryashov, I wonder if Idera is a shareware.
Thanks ALZDBA, this link http://www.sqlservercentral.com/articles/Administration/64974/ is very useful.
and article in http://www.sqlservercentral.com/articles/Security/66151/ is interesting.
I replace FOR LOGIN_EVENT with FOR LOGON, but...
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 10, 2009 at 12:58 am
ehm .... tcp/ip enabled for that sql-instance ?
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 9, 2009 at 3:15 pm
I second RBarryYoung's solution.
That's also how we do it if we want to have our own procedures applicable for 3th party databases.
You could use synonyms in your own 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
March 9, 2009 at 11:40 am
/*
http://blogs.solidq.com/EN/rdyess/Lists/Categories/Category.aspx?Name=Memory
I noticed that I could quite a bit of basic memory information from the system
information, so I thought I would show you a very basic query you could use...
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 9, 2009 at 11:28 am
To get your inventory of which db-users to synchronize, you can use this script:
You need to run this script in every database of the sql instance !!!
print 'print @@servername...
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 9, 2009 at 6:02 am
I forgot to reply on your logon trigger.....
Read my little article regarding exactly that:
http://www.sqlservercentral.com/articles/Administration/64974/
But If you're on sp3 you shouldn't have the problems I encountered.
I also advise to read todays...
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 9, 2009 at 12:53 am
you will have to implement it on each and every individual table you want to monitor.
create trALL_yourtable on yourschema.yourtable
for insert, update, delete
as
begin
set nocount on
.....
end
I would advise to log to 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
March 8, 2009 at 1:51 pm
Keep in mind, on clustered servers, it first upgrades the secondary node(s).
That may indeed take time !
Why aren't you applying SP3 +CU1 or higher ?
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 8, 2009 at 1:48 pm
did you test using row_number or ranking functions ?
That in combination with a CTE or temp table may help out on this kind of stuff.
Check books online or SSC...
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 7, 2009 at 8:43 am
Also keep in mind SQLServer 2005 / 2008 will only show info for objects you are granted to !
Meaning only if you have been granted (implicit or explicit) "view object...
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 6, 2009 at 6:35 am
If you can live with near-time solutions, don't go for realtime.
A trigger is executed in transactions scope, hence if your trigger fails, your whole transaction fails !
or:
-- the old way...
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 6, 2009 at 6:25 am
On the other hand ...
As the OP states
... If a database regularly creates, say, 50 Mb a day in transactions, but once a year I create 500 Mb 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
March 6, 2009 at 5:35 am
here's a nice ref:
http://kendalvandyke.blogspot.com/2009/02/disk-performance-hands-on-series.html
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 5, 2009 at 10:53 am
- must be a large open transaction.
does dbcc opentran show info (position in the correct database) ?
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 5, 2009 at 10:50 am
Thank you for the feedback.
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 5, 2009 at 12:38 am
Viewing 15 posts - 3,931 through 3,945 (of 7,503 total)