Forum Replies Created
Viewing 15 posts - 5,971 through 5,985 (of 7,502 total)
-
RE: Access to SQL Server: The Upsizing Wizard
Today, your article was one of the featured articles with the newsletter.
Since your filed the article in 2005, things have changed.
Now you have 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
-
RE: Get latest record without timestamp
actualy it is a common pitfall to determine "age"/"most recent",.. based on an autonumber !
Add a datetime-column with default getdate() or getUTCdate().
I takes 8 bytes a row, but at least 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
-
RE: Move a database between two hard drives
just to add ...
there are special procedures to move master, model, tempdb and msdb.
check out bol or msdn (I cannot recall the KB wright now)
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!
- 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
Viewing 15 posts - 5,971 through 5,985 (of 7,502 total)