Forum Replies Created
Viewing 15 posts - 6,181 through 6,195 (of 7,499 total)
-
RE: Select on table not working
just to add to David's reply :
When you are logged in as member of the sysadmin fixed server role, internaly the user is switched to "sa" which defaults to schema...
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
from BOL :
- Understanding Logical Scan Fragmentation and Extent Scan Fragmentation values.
Logical Scan Fragmentation and, to a lesser extent, Extent Scan Fragmentation values give the best indication of a...
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
- Understanding Logical Scan Fragmentation and Extent Scan Fragmentation values.
-
RE: SQL Memory ! What is the best setting ?
"Buffer Cache Hit ratio is around 65% on average."
That's still surprising on a 1.8 Terrabytes system with only 1,7Gb ram for sqlserver.
Maybe you can optimize by investigation partitioned tables...
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 Memory ! What is the best setting ?
every litle bit of ram helps in this case !
Keep in mind windows itself needs some memory, I guess the 500mb you're leaving will do if it's a dedicated...
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 Memory ! What is the best setting ?
In the servers Boot.ini file add :
[operating systems]
multi(0)disk(0)rdisk(0)partition(1)\WINNT="whatever windowssystem " /fastdetect /3GB
You will have to reboot the server to activate 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: SQL Memory ! What is the best setting ?
By default windows only allows an application to use up to 1,7Gb ram.
Adding the /3Gb windows startup parameter, for systems up to 4Gb ram, windows will allow an application 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 Memory ! What is the best setting ?
Seems to me that your server is on the
smalltiny side
Adding /3Gb to your startup parameters of Windows may have your sqlserver...
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: Function for Time Conversions
What I mean is that if you want to e.g. select data with a where-clause which has your UTC time used as a predicate, it's best to convert your search-criteria...
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: Function for Time Conversions
keep in mind that if you access an indexed column to which you apply a function, will make the predicate non-sargeble. Meaning the index will not be used and the function...
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 Memory ! What is the best setting ?
I'd say that would be good.
How mutch is SQLserver actualy using (task manager) ?
If sqlserver has not enough memory, it has to swap and _that_ may be what's strangling you.
In...
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: Productivity Gains?
SSIS/Bi-dev studio :
- now they can build packages in a way programers should be used to, debug them and implement them into SSIS like one would implement a program.
-...
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: Deadlock Trace Flag question.
-- 1204 Returns the type of lock participating in the deadlock and the current command affect by the deadlock.
-- 1205 Returns more detailed information about the command being executed...
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: Productivity Gains?
- don't forget to mention the scripting capabilities of SSMS / SMO.
- solution-oriented (cfr VS2005) script libraries
- enhanced (out of the box) templates
- XML datatype and XML-schema-binding !
- XML-docs 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
-
RE: Easiest query to find start of month
use SQL2005 SSMS and you'll find it very usefull.
copy/past keeps the colors
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: Collations
the SQL-prefixed ones are collations used by sql2k.
Aparently MS did some optimisations for unicode handling with the new collations.
- Only performance factor i read about is 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
Viewing 15 posts - 6,181 through 6,195 (of 7,499 total)