Viewing 15 posts - 2,971 through 2,985 (of 7,499 total)
- 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
Bhuvnesh (6/30/2010)
i am sql administrator, is that enough for it ?
That should be ok.
What level of SQL2005 are you on (sp/CU )
Select @@version
or
Select Serverproperty( 'BuildClrVersion' ) as BuildClrVersion
...
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:03 am
it's your exec statement that is bogy ....
exec [fnSplitString] [OPI:'0','XYZ','22.0','DES XYZ',\N'1','ABC',44.0','ABC DES',\N'0','XYZ','22.0','DES XYZ',\N'1','ABC',44.0','ABC DES',\N],':',','
should be something like
exec [fnSplitString] 'OPI:0,XYZ,22.0,DES XYZ,\N1,ABC,44.0,ABC DES,\N0,XYZ,22.0,DES XYZ,\N1,ABC,44.0,ABC DES,\N',':',','
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 4:30 am
have you been granted VIEW SERVER STATE permission ?
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 4:25 am
Viewing 15 posts - 2,971 through 2,985 (of 7,499 total)