Forum Replies Created
Viewing 15 posts - 5,971 through 5,985 (of 7,499 total)
-
RE: Production Server Random Crashing - Need help!
- check out AWE Memory SQL Server Performance Tuning Tips how to handle the /3Gb /pae switches !
- max 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
-
RE: Production Server Random Crashing - Need help!
-- exec sp_configure 'show advanced options',1
-- reconfigure
-- go
- Can you give us the result of exec sp_configure ?
- are the windows eventlogs showing any anomalities ?
- maybe http://support.microsoft.com/kb/815209 can...
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
-
RE: JumpStartTV - really sucks
Same problem overhere.
I tried http://www.jumpstarttv.com/Media.aspx?vid=70. After 5 minutes it still wasn't showing the episode, only the animated green bar and the ads
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
-
RE: Convert DataType being Passed to Stored Procedure
- another reason to split presentation and data.
- convert to the correct datatype asap !
- always do some contenct-checking befor converting.
declare @ParamValue2
if ISNUMERIC(@ParamValue)
begin
set @ParamValue2 = convert(decimal(12,2),@ParamValue)
exec dbo.s_Proc...
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
-
RE: VB App on SQL Server 7 machine cannot connect to SQL Server 2000 Database
see my answer at your other post ... http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=20&messageid=335083
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
-
RE: VB App on SQL Server 7 machine cannot connect to SQL Server 2000 Database
update your MDAC to at least 2.6. Best is to use the latest version.
http://msdn.microsoft.com/data/Default.aspx
http://msdn.microsoft.com/data/ref/mdac/
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
-
RE: rename sql server - downside?
Indeed.
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
-
RE: rename sql server - downside?
- have a look at How to: Rename a Stand-Alone Instance of SQL Server 2005
- technically the sp_dropserver / sp_addserver does the switch. So connections and queries will...
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
-
RE: Link Server doesn''''t work except through query analyzer: MSSQL freezing / timing out
- What's your connection's authorisation ? Is it the same as with QA ?
- I guess your connection is running in "repeatable read"-isolation level ! More locking-related resources are needed,...
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
-
RE: Query: SLOW then FAST then SLOW (SQL 2000 SP3, Large Tables)
"I don't have access to the Prod DB" That's why you need good collaboration with your productiondba. It eases things to get hold on figures smoothly.
"AWE is enabled" so...
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
-
RE: sa account attack
you can create your own mysa-account or use your windows-login with granted sqlserver-sysadmin-privileges !
I didn't disable 'sa' with sql2005 up until now, you'd have to test the effect of it,...
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
-
RE: I have a REALLY easy question!
I hope this was the first of a series of usefull answers for this 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
-
RE: sa login for an application
just my 2ct
- also keep in mind that many of the "technical" sales people even don't know their app runs just fine with a non-sa sqlaccount.
- you can try 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
-
RE: sa account attack
maybe you could close your sqlserver's tcp/ip port on your firewall if you don't need external connections, just to delimit your perimeter for investigation.
(Default instances of SQL Server use TCP...
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
-
RE: Query: SLOW then FAST then SLOW (SQL 2000 SP3, Large Tables)
- how is the load of other queries in your system ?
- is this a dedicated sqlserver server ?
- 45 % avg cpu is not that alarming, but gives you...
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
Viewing 15 posts - 5,971 through 5,985 (of 7,499 total)