Forum Replies Created
Viewing 15 posts - 6,166 through 6,180 (of 7,499 total)
-
RE: Sql Query Optimization
just my 2 Ct
-
Avoid predicates containing functions !!! (e.g. SUBSTRING
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: Some clients cann''''t connect to QSL server after restarting SQL service
you should use Cluster Administrator to stop/start all clustered applications !!!
Clustermanager loose connectivity info an try to failover ... it the stop/start is taking more than a "isalive"-poll-interval.
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: Some clients cann''''t connect to QSL server after restarting SQL service
- How about the connection-pools ? Did they reach the timeouts ?
- Did the users stop and start their applications ? or just tried executing some stuff with the ongoing...
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: Some clients cann''''t connect to QSL server after restarting SQL service
did you restart the services using CLUSTER MANAGER ?
If not, that will be your problem.
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: Beware of Search Argument (SARG) Data Types
And probably INTEGER would be mutch faster
and preferable because you have precision 0.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: Want to change logical file name.
I was probably updating my previous reply whilst you replied to it
It does not need to be in single user mode, but may...
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: Want to change logical file name.
you can modify the LOGICAL filename.
If you want to alter the physical filename , you're stuck with detatch / rename-file (e.g. with explorer) / attatch
from BOL :
- FILENAME
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
- FILENAME
-
RE: Beware of Search Argument (SARG) Data Types
btw precedence has been changed with sql2000 sp4
Let's hope they don't do that again
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: Beware of Search Argument (SARG) Data Types
add this one to "10 things i wish my developers knew about sql"
Make sure you use the datatype of your columns ! because you avoid your dbms to translate 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: Restore v Detach/Attach
you can query inter-collation !
but you have to convert to the same collation in the query :
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=4&messageid=95954
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: dbcc showcontig
can you run sp_updatestats and dbcc updateusage , just to make sure the statistics are OK ?
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: How to enable connection pooling for ODBC source?
afaik this is set with the connection !
Connection Pooling in .NET Applications
conn.ConnectionString = "...;Min Pool Size=50";
perfmon can show you the counters.
you may want 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: SQL Server Copy not working
just my 2ct
- I use this step in a job:
execute @ReturnCode = msdb.dbo.sp_add_jobstep @job_id = @JobID , @step_id = 9, @cmdexec_success_code = 0, @on_success_action = 1, @on_success_step_id = 0,...
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: dbcc showcontig
- how many files are in the filegroup ?
- how many columns compose your clustring index key ?
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: No enough Storage?
can you provide some config info ?
SQLServer version and sp
Server OS and sp
Memory
If you can reproduce this or know the interval this recurs, start profiler to capture...
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 - 6,166 through 6,180 (of 7,499 total)