Viewing 15 posts - 2,971 through 2,985 (of 7,502 total)
Paul White NZ (7/17/2010)
CirquedeSQLeil (7/17/2010)
Tom.Thomson (7/17/2010)
Alvin Ramard (7/17/2010)
Steve Jones - Editor (7/17/2010)
I'm rubber and you all are glue....And we'll soon find out that it's true ...
But I'll stretch and sick...
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 17, 2010 at 12:11 pm
hxkresl (7/16/2010)
...SQL Agents likes to stop running all by itself for some unknown reason..
You should investigate this !
Have a look at the SQLAgent.OUT file, SQLServer's Errorlog file (to be found...
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 17, 2010 at 12:05 am
two first impressions :
1) I don't like using windows accounts for job owners ( had to much troubles with that in the early yaers )
Backup jobs are...
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 15, 2010 at 8:37 am
- do you have auto-update statistics enabled for the database ?
- how is the fragmentation rate of your indexes ?
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 14, 2010 at 2:41 pm
Now we know why it's important to set your cellphone alert at the planned end time for the meeting :hehe:
-- edited : emphasized end
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 14, 2010 at 6:41 am
I was having the same issue after installing SSMS SQL2008R2.
The regsvr fix worked like a charm. 😎
( I first changed my current directory in the command prompt to "C:\Program Files\Microsoft...
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 14, 2010 at 3:48 am
- Did you follow the BOL ref "How to: Notify an Operator of Job Status (SQL Server Management Studio)"
- did you create a dbmail profile to be used by...
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 13, 2010 at 12:26 am
sqlbrowser only translates instance name to port number.
So, if you don't want to specify port number with your connections, you should activate sqlbrowser.
You'll have to open the udp port 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
July 12, 2010 at 2:04 pm
Just a little side note :
Keep in mind ms published a "sqlserver migration assistant for oracle"
This may get you started with your plan of attack 😉
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 11, 2010 at 2:18 am
If this is a brute force single action operation, you could use something like:
create table #wrk16_17 ( TbName sysname not null, Age17 bit, Age16_17 bit )
truncate table #wrk16_17
set nocount on
declare...
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 11, 2010 at 2:11 am
Some questions:
1) Do you really need this update "in transaction / in process" ?
If a single update in database y doesn't succeed (e.g. locked) your whole trigger...
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 9, 2010 at 7:18 am
Denesh Naidoo (6/24/2010)
...I do not want to add the BUILTIN\Administrators group...
What we do is we create a domain group to manage every server, add that group to the local administrators...
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 7, 2010 at 5:24 am
simple .... avoid xp_cmdshell.
There must be more optimal ways to perform the same thing without having to open xp_cmdshell and accept the risks that come with it.
Did you grant exec...
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 7, 2010 at 5:19 am
Any news on this matter ?
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 5, 2010 at 6:06 am
Suresh B. (6/30/2010)
Do you get any error when you run sys.dm_db_index_usage_stats?Is the database compatibility level = 90?
Do you have any index (which is used) on this database?
Good points Suresh.
If this...
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 30, 2010 at 5:51 am
Viewing 15 posts - 2,971 through 2,985 (of 7,502 total)